I face with that error message on our 11.2.0.4 RAC database which is working on AIX Operating System.
I started to get ORA-00245: control file backup operation failed &RMAN-03009: failure of Control File and SPFILE Autobackup command on C1 channel xxx errors. I noticed that this error has appeared after I have been enabled block change tracking to can take Incremental backup on my system.
Our current RMAN setting is:
RMAN>CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/snapcf_SID.f
The Error message during Incremental(Level 1) is
RMAN-03009: failure of backup command on C1 channel at 04/04/2019 08:50:55 ORA-00245: control file backup operation failed continuing other job steps, job failed will not be re-run RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup plus archivelog command at 04/04/2019 08:53:52 RMAN-03009: failure of backup command on C13 channel at 04/04/2019 08:50:55 ORA-00245: control file backup operation failed
After making some search I get below metalink document:
RMAN Controlfile Must Reside on Shared Device for RAC database in 11G [ID 1263621.1]
So I changed our parameter as below and error has been stopped.
RMAN > CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+ORADATA/SID/CONTROLFILE/snapcf_SID.f’;
Reference:
RMAN Controlfile Must Reside on Shared Device for RAC database in 11G [ID 1263621.1]
In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location [ID 1472171.1]
Top RMAN 11.2 issues [ID 1473914.1]
Yorum bırakın
Comments feed for this article