rac rman备份因归档不可访问出错RMAN-06059 RMAN-03002 ORA-19625

--linux环境10g的rac库
--rman RAC备份出错如下(部分)
Starting Control File and SPFILE Autobackup at 13-SEP-12
piece handle=+DATA/racdb/autobackup/2012_09_13/s_793904799.271.793904805 comment=NONE
Finished Control File and SPFILE Autobackup at 13-SEP-12
sql statement: alter system archive log current
Starting backup at 13-SEP-12
current log archived
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/13/2012 17:07:11
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /opt/ora10g/racdb1_arch/1_2_792374929.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
--分析,这个原因有3
1、因为手动删除过归档日志,而未更新相关记录导致rman无法确定其文件状态
解决办法:crosscheck后删除过期文件即可
2、对于rac中的归档的备份,需要确定rman可以正常访问到每个节点的归档日志(可以人为将归档拷贝到相关节点目录)
3、对于rac
解决办法:修改rman配置parallelism和脚本(设置的通道每个节点不够)
参考文档:RMAN Backup Of Archivelog Files On RAC Fails With RMAN-6059 [ID 298119.1]Applies to:
Changes
 Possible modification of setting for RMAN "parallelism".
 
Cause
 This problem can be caused by changing RMAN parallelism to too low a setting
or initially not setting it high enough such that not ALL the node specific channels are allocated.
Solution
 Check your rman parallelism setting:
 
RMAN>show all;
...
 CONFIGURE DEVICE TYPE DISK PARALLELISM 1;

 Make sure parallelism is set to at least the number of channels you're
allocating. For example, if you are issuing this backup command to backup
archivelog files on a two node RAC database:

 
run {
 allocate channel d1 type disk connect 'sys/rac@node1';
 allocate channel d2 type disk connect 'sys/rac@node2';
 backup archivelog all delete input;
 release channel d1;
 release channel d2;
 }

 then set parallelism to 2:
 
RMAN>CONFIGURE DEVICE TYPE DISK PARALLELISM 2;

 If parallelism is not set at least to the number of channels allocated, not all
channels will be used  and  RMAN will not be able to access all the archivelogs specific to each node.

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26143577/viewspace-743390/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/26143577/viewspace-743390/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值