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;
Posts
0 comments:
Post a Comment