ORA-00245: control file backup operation failed during RMAN backup

DB: 11.2.0.4 2 node RAC

OS:  RHEL5

When I’m trying to take FULL Db backup my backup failed and I see the below error message in the logfile

[oracle@oracledev]~/CB> nohup ./bkup.ksh &

released channel: ch2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup plus archivelog command at 08/21/2015 18:02:18

RMAN-03009: failure of backup command on ch2 channel at 08/21/2015 18:00:42

ORA-00245: control file backup operation failed

Recovery Manager complete.

This is the Error Specific to the RAC database, you don’t see this in NON-RAC database.

From 11.2.0.2, RMAN fails on RAC when doing controlfile autobackup which is set to DEFAULT (local server location)

Solution:

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name TEST are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/DBhome1R2/dbs/snapcf_TEST.f'; # default

From the above output we see my snapshot control file  set to the default location, so we need to change to common directory for all the nodes, here I’m using ASM so I’ll set this location to ASM disk group

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_TEST.f';

new RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_TEST.f';

new RMAN configuration parameters are successfully stored

Reference:

ORA-245: In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location (Doc ID 1472171.1)