our RAC (Linux, 22.214.171.124.0) is rather new and we are still on gaining experiences with that system...
When starting the backup with RMAN we are getting the following error:
Starting Control File and SPFILE Autobackup at 04-JUL-12
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 07/04/2012 16:41:48
ORA-00245: control file backup failed; target is likely on a local file system
The reason for the error is clear ORA-00245 - in a RAC environment the location of the Snapshot Controlfile must be on a shared location.
When executing the RMAN command "show all" on each node, we are getting
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/126.96.36.199/db/dbs/snapcf_PROD021.f'; # default
for node #1
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/188.8.131.52/db/dbs/snapcf_PROD022.f'; # default
for node #2
When using a shared location for the Snapshot Controlfile do we still need to setup 2 different names for that file?
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/<shared location>/snapcf_PROD021.f'; # default
for node #1 and
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/<shared location>/snapcf_PROD022.f'; # default
for node #2
Or should we configure just one Snapshot Controlfile?
The RMAN setup for "CONFIGURE SNAPSHOT CONTROLFILE NAME TO..." must be changed on both nodes - correct?
Hopefully my question is clear enough - any help will be appreciated.
Edited by: VivaLaVida on 05.07.2012 11:41
The controlfile is shared on RAC database and having the backup from anyone node to the shared mountpoint would meet the requirement.
configure snapshot controlfile name to '/<shared location>/snapcf_PROD0.f';
if you running your rman from first node then location could be local file system ,just set below configuration for snapshot controlfile by connecting with rman from 1st node.
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11/db/dbs/snapcf_DBID.f';
Not really required, i've RAC setup and snapshot is configured on local storage.
Configuring the RMAN Snapshot Control File Location
The snapshot control file is a copy of a database control file created in an operating system-specific location by Recovery Manager. RMAN creates the snapshot control file so that it has a consistent version of a control file to use when either resynchronizing the recovery catalog or backing up the control file. In Oracle RAC, the snapshot control file is only needed on the nodes on which RMAN performs backups; the snapshot control file does not need to be globally available to all instances in an Oracle RAC environment.
See below from doc.
It is required - beginning with Oracle 11R2...
Please check Doc-ID "In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location [ID 1472171.1]"...
I've got an RMAN error since the Snapshot Controlfile was NOT located on a shared device :-)
Thanks for sharing the doc.
however ,i've check on 184.108.40.206 setup on AIX 6.1 and rman backup running fine even its snapshot configured on local storage.
even below cmd ran fine..interested...anyway thanks for detail.
SQL> ALTER DATABASE BACKUP CONTROLFILE TO '/u01/app/oracle/product/11/db/dbs/ctl';
11.2 documet is also saying same story.
I have a strange situation
yesterday my RMAN backup failed with ORA-00245: control file backup failed; target is likely on a local file system
BUT BUT BUT
today when i refire the backup kit worked perfectly,i didnt change any of the settings related to the snapshot controlfile,the location of my snapshot controlfile on both the nodes is as folows
on node 1:-
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/oracle/product/11203/db/dbs/snapcf_wbcdb1.f'; # default
on node 2:-
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/oracle/product/11203/db/dbs/snapcf_wbcdb2.f'; # default
i am firing the backup from node1
wat could be the cause for this strange behaviour???
i am using Extended RAC on Linux platform
11g Release 220.127.116.11.0