How to reset RMAN saved configuration

To clear the saved configuration in RMAN, please consider following examples for better understanding:

Connect to RMAN prompt:

[oracle@oracle ~]$ rman target / catalog recoveryman/recoveryman@catalogdb

Recovery Manager: Release 11.2.0.1.0 – Production on Thu Jan 9 07:09:36 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1363580714)
connected to recovery catalog database

 

Example 1st:

Configure RMAN with controlfile auto-backup feature that will be auto-backup controlfile in case of major changes done in database.

RMAN> configure controlfile autobackup on;

starting full resync of recovery catalog
full resync complete
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

 

Ensure changes by issuing the following command:

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

 

To clear “controlfile autobackup” parameter, issue the following RMAN command:

RMAN> configure controlfile autobackup clear;

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN configuration parameters are successfully reset to default value
starting full resync of recovery catalog
full resync complete

 

Ensure changes by issuing the following command after clear configuration:

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

Example 2nd:

To enable backup optimization run the following command:

RMAN> configure backup optimization on;

old RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

 

To clear “backup optimization” parameter, issue the following RMAN command:

RMAN> configure backup optimization clear;

old RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
RMAN configuration parameters are successfully reset to default value
starting full resync of recovery catalog
full resync complete

 

Example 3rd:

Configure RMAN backup retention policy for 7 days recovery window:

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

 

To clear “RETENTION POLICY” parameter, issue the following RMAN command:

RMAN> CONFIGURE RETENTION POLICY CLEAR;

old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
RMAN configuration parameters are successfully reset to default value
starting full resync of recovery catalog
full resync complete

 

In same manner you can clear RMAN saved configuration.
***********************************************************************
Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.
Have a easy life ahead.

Leave a Reply