今天看A类和B类的數據庫的日誌裏面都出現了如下錯誤:
節點1日誌:
Tue Jul 31 03:02:50 2012
ORA-00245: control file backup operation failed
Tue Jul 31 09:08:37 2012
Thread 1 advanced to log sequence 346 (LGWRswitch)
Current log# 1 seq# 346 mem# 0:+DATA/a1qzdb/onlinelog/group_1.259.786961989
Tue Jul 31 09:08:37 2012
LNS: Standby redo logfile selected forthread 1 sequence 346 for destination LOG_ARCHIVE_DEST_2
Tue Jul 31 09:08:40 2012
Archived Log entry 1132 added for thread 1sequence 345 ID 0x1f7e84e dest 1:
Tue Jul 31 09:27:34 2012
Control file backup creation failed.
Backup target file size found to be zero.
Errors in file/soft/oracle/diag/rdbms/a1qzdb/a1qzdb1/trace/a1qzdb1_arc2_15073292.trc:
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
節點2日誌:
Tue Jul 31 03:02:50 2012
Control file backup creation failed.
Backup target file size found to be zero.
Errors in file/soft/oracle/diag/rdbms/a1qzdb/a1qzdb2/trace/a1qzdb2_ckpt_7602620.trc:
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No suchfile or directory
Additional information: 3
Tue Jul 31 09:16:27 2012
Thread 2 advanced to log sequence 284 (LGWRswitch)
Current log# 6 seq# 284 mem# 0:+DATA/a1qzdb/onlinelog/group_6.275.786964219
Tue Jul 31 09:16:27 2012
LNS: Standby redo logfile selected forthread 2 sequence 284 for destination LOG_ARCHIVE_DEST_2
Tue Jul 31 09:16:30 2012
Archived Log entry 1134 added for thread 2sequence 283 ID 0x1f7e84e dest 1:
Tue Jul 31 09:27:29 2012
Expanded controlfile section 19 from 818 to1636 records
Requested to grow by 818 records; added 2blocks of records
Tue Jul 31 09:27:34 2012
Errors in file/soft/oracle/diag/rdbms/a1qzdb/a1qzdb2/trace/a1qzdb2_ora_15204484.trc:
ORA-00245: control file backup operation failed
相應的trace日誌:
/soft/oracle/diag/rdbms/a1qzdb/a1qzdb1/trace/a1qzdb1_ora_5374100.trc:
*** 2012-07-31 03:02:50.674
*** SESSION ID:(541.7217) 2012-07-3103:02:50.675
*** CLIENT ID:() 2012-07-31 03:02:50.675
*** SERVICE NAME:(SYS$USERS) 2012-07-3103:02:50.675
*** MODULE NAME:(rman@qza1db1 (TNS V1-V3))2012-07-31 03:02:50.675
*** ACTION NAME:(0000011 STARTED114)2012-07-31 03:02:50.675
/soft/oracle/diag/rdbms/a1qzdb/a1qzdb1/trace/a1qzdb1_arc2_15073292.trc:
ORA-00245: control file backup operationfailed
*** 2012-07-31 09:27:34.107
IBM AIX RISC System/6000 Error: 2: No suchfile or directory
Additional information: 3
/soft/oracle/diag/rdbms/a1qzdb/a1qzdb2/trace/a1qzdb2_ckpt_7602620.trc:
*** 2012-07-31 09:27:34.382
*** SESSION ID:(885.58917) 2012-07-3109:27:34.383
*** CLIENT ID:() 2012-07-31 09:27:34.383
*** SERVICE NAME:(SYS$USERS) 2012-07-3109:27:34.383
*** MODULE NAME:(rman@qza1db2 (TNS V1-V3))2012-07-31 09:27:34.383
*** ACTION NAME:(0000021 STARTED114)2012-07-31 09:27:34.383
ORA-00245: control file backup operationfailed
/soft/oracle/diag/rdbms/a1qzdb/a1qzdb2/trace/a1qzdb2_ora_15204484.trc:
*** 2012-07-31 03:02:50.508
IBM AIX RISC System/6000 Error: 2: No suchfile or directory
Additional information: 3
Google了一下,發現這是Oracle11.2.0.2.0以後的一個“特性”:
从oracle 11.2.0.2.0开始,控制文件的快照文件必须能够被所有节点的数据实例访问到,并且必须放在共享的位置。否则,使用RMAN进行备份控制文件的时候会报如下错误:
ORA-00245: control file backup operationfailed。
当使用备份脚本备份的时候,这个错误可能会导致备份工作中断。
METALINK 中的两篇文档:
RAC BACKUP FAILS WITH ORA-00245: CONTROLFILE BACKUP OPERATION FAILED [ID1268725.1]【這篇文字沒找到】
RMAN Snapshot Controlfile Must Reside onSha