DBA Notes: 2011/09/30

Cheng Li

Configuring the RMAN Environment

This part gives a simple example how to review and set RMAN backup environment.

To view or change your CONFIGURE command settings:

You can use the SHOW command to display the current value of RMAN configured settings for the target database. You can also view whether these commands are currently set to their default values.

Start RMAN and connect to a target database and a recovery catalog (if used).

Run the RMAN SHOW command.

RMAN>SHOW ALL;

RMAN configuration parameters for database with db_unique_name PROD1 are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default

Configuring Channel Parallelism for Disk and SBT Devices

RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 2;

old RMAN configuration parameters:

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;

new RMAN configuration parameters:

CONFIGURE DEVICE TYPE 'SBT_TAPE' BACKUP TYPE TO BACKUPSET PARALLELISM 2;

new RMAN configuration parameters are successfully stored

Reference:

http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmconfb.htm#i1014902