Database Reference
In-Depth Information
6. Setting the Autobackup of the Control File
You should always configure RMAN to back up the control file automatically after running any RMAN
BACKUP
or
COPY
command or after you make physical changes to the database that result in updates to the control file (such as adding/
removing a data file). Use the
SHOW
command to display the current setting of the control file autobackup:
RMAN> show controlfile autobackup;
Here is some sample output:
RMAN configuration parameters for database with db_unique_name O12C are:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
The following line of code shows how to enable automatic backup of the control file feature:
RMAN> configure controlfile autobackup on;
The automatic control file backup always goes into its own backup set. When autobackup of the control file is
enabled, if you're using an
spfile
, it's automatically backed up along with the control file.
If, for any reason, you want to disable automatic backup of the control file, you can do so as follows:
RMAN> configure controlfile autobackup off;
■
if autobackup of the control file is off, then any time you back up data file 1 (
SYSTEM
tablespace data file),
rMan automatically backs up the control file.
Note
7. Specifying the Location of the Autobackup of the Control File
When you enable autobackup of the control file, RMAN creates the backup of the control file in one of the following
locations:
•
Default location
•
FRA
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT
command
•
Location specified via the
If you aren't using an FRA, or if you haven't specified a location for the control file autobackups, the control
file autobackup is written to an OS-dependent default location. In Linux/Unix environments the default location is
ORACLE_HOME/dbs
; for example,
/u01/app/oracle/product/12.1.0.1/db_1/dbs/c-3423216220-20130109-01
If you've enabled an FRA, then RMAN automatically writes the control file autobackup files to directories in the
FRA, using an OMF format for the name; for example,
/<fra>/<dbuname>/autobackup/<YYYY_MM_DD>/o1_mf_s_729103049_68fho9z2_.bkp
