ORA-00245 & RMAN-08132 RMAN之snapshot control file

Tue Jul 23 22:01:01 2013
Errors in file /oracle/app/db/diag/rdbms/db/db1/trace/db1_ora_9114.trc:
ORA-00245: 控制文件备份失败; 目标可能位于本地文件系统1m|-
 
      查看备份的log,
Starting Control File and SPFILE Autobackup at 23-JUL-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 07/23/2013 22:01:57
ORA-00245: 控制文件备份失败
 
       但是在备份log中,控制文件已经备份成功,应该是备份完成后的控制文件快照备份失败。MOS中有以下文档ORA-245: In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location (文档 ID 1472171.1),其中有一段是

5. In RAC environment, Rman backup fails if snapshot controlfile is not in shared location.

 RMAN-00571: ========================================================
RMAN-00569: ============ ERROR MESSAGE STACK FOLLOWS =============
RMAN-00571: =========================================================
RMAN-03009: failure of resync command on default channel at 03/13/2012 10:19:41
ORA-00245: control file backup operation failed
      在RMAN中使用show all发现,snapshot果然只是在单个节点中,
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/11.2.0/db_1/dbs/snapcf_db1.f'; # default
     修改到shared disk中。
 
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '<shared_disk>/snapcf_<DBNAME>.f';
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值