RMAN Configure Command

To see the current RMAN configuration use the following command:

show all;

Configure and run some basic rman commands

configure retention policy to redundancy 3;

(by this rman will keep last 3 backups and previous mark as obsolete)

there is another way to do the above job

configure retention policy to recovery window of 10 days;

(here rman will keep last 10 days backup and remaining mark as obsolete)

To turn auto backup of controlfiles:

configure controlfile autobackup on;

now whenever we issue a backup command or recovery, or any structural change in the database, RMAN will automatically backup the control files.

To configure rman to create multiple copies of datafile backup (permanent and always):

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;


If we want to take 2 copies of datafile backup only once:

BACKUP DEVICE TYPE DISK COPIES 2 DATABASE PLUS ARCHIVELOG;


To set rman to take 2 copies of archivelogs permanently:

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

BACKUP DATABASE KEEP UNTIL TIME 'SYSDATE+7';

Reset RMAN Configure command to default values:

When we first start RMAN and issue show all command, next to each parameter it will show a word called default.  Once we make any change of a parameter value the default word will disappear.

If we want to go back to the default value issue the below command:

RMAN> configure retention policy clear;

RMAN> configure controlfile autobackup clear;

RMAN> configure channel device type disk clear;

RMAN> configure backup optimization on clear;

RMAN> configure backup optimization clear;

RMAN> show all;