Oracle 12c DG主庫ORA-00245: control file backup fail

標籤：mos   unique   oracl   product   記憶   server   app   not   str   

環境是12.2.0.1 version, Oracle Data Guard主庫巡檢發現alert有異常報錯：

2018-07-10T13:24:04.710366+08:00
Errors in file /u01/app/oracle/diag/rdbms/dwdb/dwdb1/trace/dwdb1_m000_4455.trc:
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage
Removing incomplete backup control file /u01/app/oracle/product/12.2.0/db_1/dbs/snapcf_dwdb1.f
Got error: 245

**** WARNING ***

The errors during Server autobackup are not fatal, as it

is attempted after sucessful completion of the command.

However, it is recomended to take an RMAN control file

backup as soon as possible because the Autobackup failed

with the following error:

ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

記憶裡這個是11g的一個bug，用ASM的話，控制檔案的快照得放在共用路徑下，現環境12C，也有這樣的問題？

RMAN> show snapshot controlfile name;

RMAN configuration parameters for database with db_unique_name DWDB are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/12.2.0/db_1/dbs/snapcf_dwdb1.f‘; # default

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+data/dwdb/snapcf_dwdb1.f‘;

new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+data/dwdb/snapcf_dwdb1.f‘;
new RMAN configuration parameters are successfully stored

RMAN> show snapshot controlfile name;

RMAN configuration parameters for database with db_unique_name DWDB are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+data/dwdb/snapcf_dwdb1.f‘;

具體可以參考MOS
ORA-245: In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location (文檔 ID 1472171.1)

特此記錄一下，好記性不如爛筆頭~

Oracle 12c DG主庫ORA-00245: control file backup fail