This content has been marked as final. Show 8 replies
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';
No, it must be configured on a shared storage:
configure snapshot controlfile name to '/<shared location>/snapcf_PROD02.f';
No, it must be configured on a shared storage: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 188.8.131.52 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 184.108.40.206.0
Use a shared location. On 220.127.116.11 it can work one day on a local target, and fail the next