Databases Reference
In-Depth Information
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
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
I don't usually use the default location or the FRA for control file autobackups. I prefer these backups to be placed
in the same directory the database backups are in. Here is an example:
RMAN> configure controlfile autobackup format for device type disk to
'/u01/O12C/rman/rman_ctl_%F.bk';
If you want to set the autobackup format back to the default, do so as follows:
RMAN> configure controlfile autobackup format for device type disk clear;
Backing Up Archive Redo Logs
You should back up your archive redo logs on a regular basis. The archivelog files shouldn't be removed from disk
until you've backed them up at least once. I usually like to keep on disk any archive redo logs that have been generated
since the last good RMAN backup.
