How to reset RMAN saved configuration

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

No comments:

Post a Comment