当前位置:  数据库>oracle

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

    来源: 互联网  发布时间:2017-05-08

    本文导语: --linux环境10g的rac库--rman RAC备份出错如下(部分)Starting Control File and SPFILE Autobackup at 13-SEP-12piece handle=+DATA/racdb/autobackup/2012_09_13/s_793904799.271.793904805 comment=NONEFinished Control File and SPFILE Autobackup at 13-SEP-12sql statement: alter system archive lo...

--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.





















































    
 
 

您可能感兴趣的文章:

 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • RAC +GPFS添加节点的问题~~~~~~~~~~~~·
  • 配置Oracle RAC需要注意的问题
  • Linux Oracle RAC内核参数
  • Linux下Oracle RAC一个节点宕机导致共享存储无法挂载的故障排除
  • Oracle RAC 10.2.0.1升级到10.2.0.4
  • Oracle10201 RAC升级到10204后导出数据时报EXP-00056错误
  • 与Oracle RAC相关的连接配置写法实例
  • [Oracle] RAC 之 - 负载均衡深入解析
  • RAC cache fusion机制实现原理分析
  • 基于Linux平台的Oracle RAC 10g集群教程:删除节点所需要的步骤
  • 如何在RAC环境下修改Oracle字符集
  • Oracle RAC 状态检查
  • Linux Oracle10.2.0 RAC配置注意问题
  • redhat 5.5全新安装oracle rac的问题[1000分]
  • oracle 11g RAC 常用命令整理分享
  • Oracle 10201 RAC升级到10204
  • Redflag Linux安装Oracle 10gR2 RAC记事
  • 基于Linux平台的Oracle RAC 10g集群教程:添加节点所需要的步骤
  • Oracle10g RAC for Linux配置全过程


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,