
To perform basic backup and recovery through RMAN backup tool, RMAN provides facility to show its default configuration, change it and clearing persistent RMAN configuration.
For the sake of simplicity, we can set persistent RMAN configuration settings, so that we can control RMAN behavior.
For example, With the help of ‘SHOW’ and ‘CONFIGURE’ RMAN commands we can configure default destinations of backups, default backup retention policy, default backup device type, controlfile autobackup and so on…
Note: We can overwrite default RMAN configuration while backup.
SHOW RMAN command:
This command is used to show current value of RMAN settings, like below:
RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters for database with db_unique_name GALAXY are: CONFIGURE RETENTION POLICY TO REDUNDANCY 7; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_galaxy.f'; # default
OR We can also use ‘SHOW’ RMAN command with configuration name to show configuration, as follows:
RMAN> show backup optimization; RMAN configuration parameters for database with db_unique_name GALAXY are: CONFIGURE BACKUP OPTIMIZATION ON;
OR
RMAN> show encryption algorithm; RMAN configuration parameters for database with db_unique_name GALAXY are: CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE RMAN command:
This command is used to change the RMAN configuration, like below:
RMAN> configure controlfile autobackup clear; old RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN configuration parameters are successfully reset to default value
RMAN> show controlfile autobackup; RMAN configuration parameters for database with db_unique_name GALAXY are: CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
OR
RMAN> configure backup optimization clear; old RMAN configuration parameters: CONFIGURE BACKUP OPTIMIZATION ON; RMAN configuration parameters are successfully reset to default value
RMAN> show backup optimization; RMAN configuration parameters for database with db_unique_name GALAXY are: CONFIGURE BACKUP OPTIMIZATION OFF; # default
Like above examples, we can show, change and clear RMAN configurations.
Stay Tune. 🙂