Configuring and Backing Up Oracle Databases Using RMAN - OCP: Oracle Database 12c Administrator Certified Professional - page 120

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; #default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUP SET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 100 M;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR
LOAD TRUE ; # defaultCONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default]
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\SNCFORCL.ORA'; # default
You can also look at an individual setting by using the SHOW command followed by the
setting you are interested in. In this example, we are interested in the retention policy:
RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
You can clear configuration settings and reset them to the defaults by using the
CONFIGURE CLEAR command, as shown in this example:
RMAN>configure device type disk clear;
Unique RMAN Configuration Settings
Sometimes you need to do something different. Perhaps you have configured your default
channels to go to tape but you want a particular backup to go to disk one time. You can
configure unique one-time-only settings in RMAN through the use of a combination of the
SET command, a run block , and individual keywords available in specific commands. Here
is an example of using a run block to override channel defaults. We also use the ALLOCATE
CHANNEL command to manually allocate channels. All of these commands are described in
more detail later in this chapter:
run {
allocate channel c1 device type disk format 'c:\oracle\oraback1\orcl\%U';
allocate channel c2 device type disk format 'c:\oracle\oraback2\orcl\%U';
backup database plus archivelog;
};