The snapshotcontrolfile MUST be accessible by all nodes of a RAC database, if the snapshotcontrolfile does not reside on a shared device error will be raised at the timeof RMAN backup while taking snapshot of controlfile.
This applies tobacking up controlfile using sqlplus / having autobackup of controlfileconfigured on non
shared location.
ORA-245 errormessage description
----------------------------------------
00245, 00000,"control file backup operation failed"
*Cause: Failed tocreate a control file backup because some process
signaled an errorduring backup creation.
*Action: Checkalert files for further information. This usually happens
because someprocess could not access the backup file during
backup creation.Any process of any instance that starts a
read/write controlfile transaction must have an access to the
backup control fileduring backup creation.
1. In RACenvironment controlfile autobackup fails with ora-0245
Autobackupof controlfile in RMAN is failing with error:
RMAN-571: ===========================================================
RMAN-569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-571: ===========================================================
RMAN-3009: failure of Control File and SPFILE Autobackup command on
ORA_DISK_1 channel at 10/27/2010 12:13:31
ORA-245: control file backup operation failed
2. In RAC environment, backupcontrolfile to non shared location fails
SQL>ALTER DATABASE BACKUP CONTROLFILE TO '/home/rac1122/test/control.bk' REUSE
*
ERROR at line 1:
ORA-245: control file backup operation failed
3. In RAC environment backing upstandby controlfile to non shared location fails
SQL>alter database create standby controlfile as '/home/oracle/renostdbycntrl.ctl';
alterdatabase create standby controlfile as
'/home/oracle/renostdbycntrl.ctl'
*
ERROR at line 1:
ORA-245: control file backup operation failed
4. In RAC environment copy currentcontrolfile to '${DB_BACKUP_DIR}/rac_tnctv_control.bak';
channelch1: starting datafile copy
copying current control file
RMAN-571: ===========================================================
RMAN-569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-571: ===========================================================
RMAN-3009: failure of backup command on 10/07/2011 11:36:42 channel at ch1
ORA-245: control file backup operation failed
5. In RAC environment, Rman backupfails 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
Only affect Real application Cluster (RAC ), 11.2 specific.
In RAC environment any form of controlfile backup may failwith ORA-0245 if the location of the Snapshot Controlfile is not a sharedlocation.
The backup of the controlfile actualy makes a backup of theSNAPSHOT controlfile. The Snapshot controlfile is created when the controlfileis about to be backed up.
The Snapshot controlfile is a read-consistent copy of thecontrolfile.