RMAN CONFIGURE command is the configuration mechanism for RMAN envrionment. These settings (rman configuration) apply to all RMAN sessions until explicitly changed or disabled. SHOW command is use to display the rman configurations for one or more databases.

The RMAN CONFIGURE command always stores a rman configuration for a target database in the target database control file. If you use a recovery catalog, then RMAN also stores rman configuration settings for each registered database in the catalog.

RMAN CONFIGURE Syntax

CONFIGURE [ BACKUP OPTIMIZATION { OFF | ON | CLEAR } ]
  [ { ARCHIVELOG | DATAFILE } BACKUP COPIES FOR DEVICE TYPE deviceSpecifier { TO integer | CLEAR } ]
  [ CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE deviceSpecifier { TO 'format string' | CLEAR } ]
  [ CONTROLFILE AUTOBACKUP { OFF | ON | CLEAR } ]
  [ DEFAULT DEVICE TYPE { TO deviceSpecifier | CLEAR } ]
  [ DEVICE TYPE deviceSpecifier { PARALLELISM integer | CLEAR }]
  [ EXCLUDE FOR TABLESPACE tablespace_name [CLEAR] ]
  [ MAXSETSIZE { TO UNLIMITED | TO integer [ K | M | G ] } ]
  [ MAXSETSIZE CLEAR ]
  [ RETENTION POLICY TO RECOVERY WINDOW OF integer DAYS ]
  [ RETENTION POLICY TO REDUNDANCY [=] integer } ]
  [ RETENTION POLICY { CLEAR | TO NONE } ]
  [ SNAPSHOT CONTROLFILE NAME { TO 'filename' | CLEAR } ]
  [ AUXNAME FOR DATAFILE datafileSpec { TO 'filename' | CLEAR } ]

RMAN CONFIGURE Parameters

 BACKUP OPTIMIZATION

ON: Optimization skips a file if identical file is already backed up on previous backup.

OFF: Backup Optimization is off (default).

CLEAR: return optimization to its default value to OFF

Note: FORCE option can override backup optimization.

ARCHIVELOG | DATAFILE BACKUP COPIES FOR DEVICE TYPE

Specifies number of copies from 1 to 4 (1 is the default) for each backup set on disk or tape. RMAN cannot duplex to tape and disk concurrently.

CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE

Configures the default filename format for the control file autobackup on the specified device type. The default format is %F for all devices.

CONTROLFILE AUTOBACKUP

When on a backup of the controlfile is taken after completion of any BACKUP or COPY and after database structural changes such as adding a new tablespace, altering the state of a tablespace or datafile (for example, bringing it online), adding a new online redo log, renaming a file, adding a new redo thread, and so forth. Controlfile backup goes only to disk.

DEFAULT DEVICE TYPE TO

Specifies the default device type for automatic channels. By default, DISK is the default device type. CLEAR returns the default device type to DISK.

DEVICE TYPE

Specifies the device type (disk or sbt) to which to apply the settings specified in this CONFIGURE command. The CLEAR option resets backup type and parallelism settings for this device to their defaults.

EXCLUDE FOR TABLESPACE

Excludes one or more tablespaces. SYSTEM tablespace cannot be excluded.

MAXSETSIZE { TO UNLIMITED | TO

Specifies the maximum set size. The default setting is in bytes and is rounded down to kilobtyes. The minimum value must be greater than the largest single datafile that would be included in the backup set.

MAXSETSIZE CLEAR

Resets the maximum set size to the default value of UNLIMITED.

RETENTION POLICY TO RECOVERY WINDOW OF integer DAYS

Time window for RMAN to recover database. The window starts from current time (SYSTEM DATE) to the point of recoverability. The point of recoverability is SYSTEM DATE - integer days in the past. 

RETENTION POLICY TO REDUNDANCY [=] integer

Specifies that integer backups or copies of each datafile and control file should be retained. If more than integer backups or copies exist, they are marked as obsolete. DELETE OBSOLETE command removes obsolete backups and copies as well as archived log backups and copies.

RETENTION POLICY { CLEAR | TO NONE }

CLEAR resets the retention policy to its default (REDUNDANCY = 1).
TO NONE disables the retention policy feature. RMAN does not consider any backups or copies as obsolete.

SNAPSHOT CONTROLFILE NAME { TO 'filename' | CLEAR }

Configures the snapshot control file filename to 'filename'. CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR sets the snapshot control filename to the default. The default on some UNIX system is ?/dbs/snapcf_@.f.

RMAN CONFIGURE Examples

//Configure RMAN to Backup controlfile autobackup after every backup
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
//Configure RMAN for controlfile autobackup format
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/cfilebackups/cf%F';
//Configure RMAN retention policy to retains all backups required to recover DB 
//to any point in last seven days:
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
//Configure RMAN retention policy to retains 3 backups of each datafile:
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
//Configure RMAN to assigne two sbt channels for parallelism :
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 2;

 

All RMAN CONFIGURE settings have their defaults. You can return to the default with the CLEAR option. Following example resets any RMAN CONFIGURE setting to their defaults.

RMAN> CONFIGURE RETENTION POLICY CLEAR;
RMAN> CONFIGURE CHANNEL DEVICE TYPE sbt CLEAR;

//CONFIGURE RMAN to Clear file format for disk backups
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT CLEAR;
Go to top
JSN Boot template designed by JoomlaShine.com