If the CONFIGURE CONTROLFILE AUTOBACKUP command is set to ON (by default it is OFF), then RMAN automatically backs up the control file and server parameter file after every backup and after database structural changes.

If the autobackup feature is not set, then you must manually back up the control file in one of the following ways.

  • BACKUP CURRENT CONTROLFILE;

The following example backs up the current control file to the default disk device:

BACKUP AS COPY
CURRENT CONTROLFILE
FORMAT '/tmp/control01.ctl';
  • Using INCLUDE CURRENT CONTROLFILE option of the BACKUP command

The following example backs up tablespace users to tape and includes the current control file in the backup:

#Connect to RMAN
C:\RMAN

#Connect RMAN to target database
CONNECT TARGET SYS/pass@TEST1;

#Connect RMAN to recovery catalog (optional)
CONNECT CATALOG rman/cat@devdb;

#Issue RMAN BACKUP command.
BACKUP DEVICE TYPE sbt
TABLESPACE users
INCLUDE CURRENT CONTROLFILE;

The following example backs up the control file copy created in the previous example to tape:

BACKUP AS COPY
CURRENT CONTROLFILE
FORMAT '/tmp/control01.ctl';
BACKUP DEVICE TYPE sbt
CONTROLFILECOPY '/tmp/control01.ctl';
Go to top
JSN Boot template designed by JoomlaShine.com