Databases Reference
In-Depth Information
To set the directory and file format back to the default value, run this command:
RMAN> configure controlfile autobackup format for device type disk clear;
You can use the command
set control file autobackup format
, either within a
run
block or at the RMAN
prompt (the
run
block has precedence over the RMAN prompt), to override the configured auto backup format for the
duration of an RMAN session.
How It Works
If you have enabled a fast area as well as the auto backup of the control file, then RMAN will write the backup to the
directory defined for the fast area. By default, RMAN creates these files as Oracle managed files.
When specifying a file name as well as a target directory, you must include the format variable
%F
in the filename.
The format variable
%F
yields a unique combination of the database ID, day, month, year, and sequence.
When you clear the control file auto backup format for disk as shown in the Solution section of this recipe, the
control file will be backed up to the fast recovery area, provided you have enabled it first. If you haven't enabled a fast
recovery area, RMAN will create the auto backups in an operating system-specific location ($ORACLE_HOME/dbs on
Unix and %ORACLE_HOME%\database on Windows).
You can also configure the auto backup to back up the control file to an automatic storage management (ASM)
disk group, as shown in the following example:
RMAN> configure controlfile autobackup format
for device type disk to '+dgroup1/%F';
The control file autobackup will be stored in the disk group
+dgroup1
when you execute this
configure
command.
Specifying the Snapshot Control File's Name and Location
Problem
RMAN occasionally creates a special control file called the
snapshot control file.
You want to specify your own name
for this file as well as the location for storing it.
Solution
Use the
configure snapshot controlfile to ...
command to change the snapshot control file's name and the
directory in which it is stored:
RMAN> configure snapshot controlfile name to '/u01/app/oracle/rman/snapct.ctl';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/rman/snapct.ctl';
new RMAN configuration parameters are successfully stored
RMAN>
