Friday 10 January 2014

How to set retention policy to 2?

[oracle@wasiq 2013_12_27]$ rman

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 27 22:21:28 2013

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

RMAN> connect target /;

connected to target database: PROD (DBID=246965557)

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored

RMAN> show retention policy;

RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

The above commands indicates how many days the backup copies need to be retained. Default is 1 day.

No comments:

Post a Comment