RE: RMAN Retention Policy
- From: "Johnson, William L (TEIS)" <WLJohnson@xxxxxxxxxxxxxxxxxxx>
- To: "JBECKSTROM@xxxxxxxxx" <JBECKSTROM@xxxxxxxxx>, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>, oracle-db-l <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 22 Apr 2009 13:30:29 -0400
There are actually a couple of things you need to check on for recoverability...
1. If you are using a third party tool for tape management like Commvault or
Netbackup, you need to know what type of policy is used for the backup and how
long the tapes are kept before being recycled. If you are not careful, there
won't be a tape to use for a restore whether the information is in your control
file or your rman catalog.
2. The rman catalog will store information until you do a cleanup - meaning
it will be there until you drop and recreate the rman catalog user id or take
some other action to delete old records.
3. The control_file_record_keep_time default value is 7 days - at least for
Oracle 10g. This really doesn't matter a whole lot if you are using an rman
catalog. When you go to do a restore, just utilize the rman catalog
information and the control file will not be required.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jeffrey Beckstrom
Sent: Wednesday, April 22, 2009 12:36 PM
To: oracle-l-freelists; oracle-db-l
Subject: RMAN Retention Policy
If issue the statement:
configure retention policy to recovery window of 21 days;
Does this mean that recovery information will be kept in the recover catalog
AND the control file for 21 days or will control file still be only 7 days? I
have not set control_file_record_keep_time so won't it stay at 7 days?
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
Other related posts:
