Reset RMAN configuration back to default

Posted: October 25, 2011 in Oracle RMAN
Tags: , , ,

In RMAN we can use command ‘show all’ to list all RMAN configuration. In some cases it would be quite handy to see the default configuration, how to reset the configuration back to default value? for example

RMAN> show archivelog deletion policy;

RMAN configuration parameters are:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

We can use command ‘clear’ to reset the value back to default

RMAN> configure archivelog deletion policy clear;

old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
RMAN configuration parameters are successfully reset to default value

Cheers
Fiedi Zheng

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s