Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
When backup is taken with Rman, it creates the snapshot of the control file and uses it as backup file.
The name of the directory and file to which this file is created is specified in the Rman configuration. This directory should be accessible from all nodes on RAC systems.
In cases where ASM is used, it is useful to assign a location in the ASM for the parameter rman SNAPSHOT CONTROLFILE NAME.
If the file system is to be used, either the cluster file system must be used or nfs must be defined on a node. This will allow other nodes to access this directory.
I’ve shown below how to specify a directory in ASM.
First, let’s query the current configuration.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | RMAN> show all using target database control file instead of recovery catalog RMAN configuration parameters for database with db_unique_name ORCL 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.3/dbhome_1/dbs/snapcf_ORCL1.f'; # default |
The parameter SNAPSHOT CONTROLFILE NAME should be changed in a common area as follows.
1 2 3 4 5 | RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/ORCL/snapcf_orcl_1.f'; new RMAN configuration parameters: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/ORCL/snapcf_orcl_1.f'; new RMAN configuration parameters are successfully stored |
