Configuring persistent RMAN settings for an oracle database

RMAN uses the CONFIGURE command to configure persistent settings for backup, restore and duplication.

Some of the uses of the CONFIGURE command include but not limited to:

• Configure automatic backup control files and server parameter files(SPFILE).
• Configure the backup retention policy
• Configure automatic channels
• Enables us to limit the size of backup pieces
• Specify the number of backup copy to be created
• Configure parallelism
• Enable backup optimization

Examples of RMAN commands for persistent settings:

------ Use SHOW ALL command to view  existing settings
RMAN> <strong>show all;</strong>
 RMAN configuration parameters for database with db_unique_name PRIMARY are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
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 RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\ADMIN\VIRTUAL\VIRTUAL\PRODUCT\12.2.0\DBHOME_1\DATABASE\SNCFPRIMARY.ORA'; # default
RMAN> <strong>show controlfile autobackup;</strong>
 RMAN configuration parameters for database with db_unique_name PRIMARY are:
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
RMAN> <strong>show controlfile autobackup format;</strong>
 RMAN configuration parameters for database with db_unique_name PRIMARY are:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

------For resetting of any persistent configuration to its default value
RMAN> <strong>configure controlfile autobackup clear;</strong>
RMAN configuration parameters are successfully reset to default value
RMAN>