The RMAN backup and recovery environment is preconfigured for each target database. The RMAN configuration is persistent and applies to all subsequent operations on target database, even if you exit and restart RMAN. Following are the some common configuration that you can perform as a RMAN backup configuration.

You can use the SHOW and CONFIGURE commands to view and change RMAN configurations.

Show RMAN Backup Configurations

Use SHOW command to display the current value of RMAN settings for the target database.

  1. Start RMAN
  2. Connect to a target database and a recovery catalog (if used).
  3. Run the RMAN SHOW command
C:\RMAN 
RMAN> CONNECT TARGET SYS/pass@TEST1;
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
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_DEVICE=tape1)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/disk1/oracle/dbs/snapcf_ev.f'; # default

Parameters that are set to their default values have # default at the end of the configuration setting.

You can also use the SHOW command with the name of a particular configuration for example;

RMAN> SHOW RETENTION POLICY; 
RMAN> SHOW DEFAULT DEVICE TYPE;

Clear RMAN Backup Configurations

Use the CONFIGURE ... CLEAR command to return any configuration to its default value.

RMAN> CONFIGURE BACKUP OPTIMIZATION CLEAR; 
RMAN> CONFIGURE RETENTION POLICY CLEAR;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP
FORMAT FOR DEVICE TYPE DISK CLEAR;

Configure RMAN Backup Device Type: Disk or SBT

RMAN is preconfigured to use disk as the default device type. By default RMAN allocates one disk channel for all operation automatically, and direct all backups to disk if no destination is specified RMAN uses the flash recovery area for all backups.

There is no need to allocate or deallocate a specific channel for backups unless you’re using a tape device.

Set or Change default device type:

Following command example specifies that backups should go to disk by default. If a recovery area is enabled, then the backup location defaults to the flash recovery area. Otherwise, the backup location defaults to an operating system-specific directory on disk.  

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK

Following command example specifies that backups should go to tape by default. After RMAN is able to communicate with the media manager, you can configure RMAN to make backups to tape and specify SBT as the default device type.

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt

NOTE: sbt is the device type used for any tape backup subsystem, regardless of vendor.

Override default device type during backup

you can override the default device type by using the DEVICE TYPE clause of the BACKUP command.

RMAN> BACKUP DEVICE TYPE sbt DATABASE; 
or
RMAN> BACKUP DEVICE TYPE DISK DATABASE;

Configure RMAN Backup Type: Backup Sets or Copies

  1. The BACKUP command can create either backup sets or image copies.
  2. The default backup type for disk is an uncompressed backup set.
  3. RMAN can write an image copy only to disk.
  4. RMAN can create backup sets using binary compression.

To configure the default type of backup:

  1. Start RMAN and connect to a target database and a recovery catalog (if used).
  2. Configure backup sets or image copies as the default backup type

The following examples configure the backup type for disk backups to copies and backup sets:

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY; # image copies 
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; # uncompressed

 

The following examples configure compression for backup sets:

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
RMAN> CONFIGURE DEVICE TYPE sbt BACKUP TYPE TO COMPRESSED BACKUPSET;
Go to top
JSN Boot template designed by JoomlaShine.com