Configuring AUTOBACKUP of CONTROLFILE  and SPFILE

You can configure RMAN to take backup of Control File & SPFILE whenever any type of backup is taken using RMAN.

Note: If you are using RMAN without Recovery Catalog then it's recommended to Turn ON auto backup of Control file and SPFILE.

To configure Control File and SPFILE AUTOBACKUP give the following command

RMAN> configure controlfile autobackup on;

Once you give the above command RMAN will automatically takes the backup of control file and server parameter file in the directory specified in DB_RECOVERY_FILE_DEST

Like for example, when we take the backup of a particular tablespace, RMAN will take backup of Control File and SPFILE as shown in the output below

Turning of AUTOBACKUP of Control File and SPFILE

To turn OFF automatic backup of Control File and SPFILE, give the following command

RMAN> configure controlfile autobackup off;

Configuring the Default Type for Backups

Whenever you give BACKUP command in RMAN, you can tell RMAN to take backup as BACKUPSET or IMAGE copy by configuring the device type.

For example, to take backup as backupset as default whenever you give backup command, give the following command at RMAN prompt

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET;

To take backup as IMAGE COPY as default whenever you give backup command

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;

You can even configure backups to be compressed when you give backup command by issuing the following command

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;