• Welcome
• Projects
• Presentations
• Research

RMAN Configure Command

The CONFIGURE command can be used to show or set parameter values.

Default Parameters

RMAN includes a number of parameters which initially have default values.

The CONFIGURE command can be used to get or set parameter values.

The default values are as follows:

RMAN> SHOW ALL;

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_TEST.f'; # default

To set a configuration parameter use the CONFIGURE command. For example:

RMAN> CONFIGURE BACKUP OPTIMIZATION OFF;

To unset a configuration parameter use the CLEAR keyword. For example:

RMAN> CONFIGURE BACKUP OPTIMIZATION CLEAR;

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR;

Non-standard parameters can also be cleared. For example:

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK CLEAR;

Non-default configuration parameter values are reported in the V$RMAN_CONFIGURATION dynamic performance view.

In Oracle 11.2 this view has the following columns:

In Oracle 11.2 V$RMAN_CONFIGURATION contains the following rows: