our RAC (Linux, 126.96.36.199.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/188.8.131.52/db/dbs/snapcf_PROD021.f'; # default
for node #1
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/184.108.40.206/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.
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.
Thanks for sharing the doc.
however ,i've check on 220.127.116.11 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';
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 18.104.22.168.0