Home > IT Answers > Storage > RMAN Retention Policy
Jlynch019
5 pts.
 RMAN Retention Policy
Backup, Backup and restore, Data Retention Policy, Oracle RMAN, RMAN backup
I'm currently reviewing our company's backup strategy and in particular our retention policy. Currently, due to low disk space, we only keep the most recent backups on disk. The previous nights backup is transferred to tape and then deleted from disk before another backup is taken. Are we able to retain the valid catalog information for a recovery window of 7 days, without having the actual backups on disc? The intention being that we can recover a backup from tape (taken say 5days ago) and restore from that?



Software/Hardware used:
ASKED: October 27, 2010  10:46 AM
UPDATED: November 4, 2010  4:13 AM
RELATED QUESTIONS
Answer Wiki:
it depends alot on what is written on your policy procedure (on retention period and how you are going to do the backup). maybe you can explain more on what you are backing up (windows image, database or etc). with more information I might be able to give you more pointers... Configure Retention Policy is defined to establish how long a backup retain by RMAN before it is expired. If u configure a retention policy & are using FRA, then RMAN & Oracle will take care of automatically remove when it obsolate. The redundancy and the recovery window policies are manually exclusive & either of them may be defined as a time. The procedure is : 1.Launch RMAN & connect to target database (u may connect to recover catalog database if u created one) C:> RMAN TARGET / 2.To set retention policy to a redundancy of 7, 1.RMAN> configure retention policy to redundancy 7; 3.To view it 1.RMAN> show retention policy; 4.To set retention policy to a recovery window of 7 days, 1.RMAN> configure retention policy to recovery window of 7 days; 5.To clear it, 1.RMAN> configure retention policy clear; 2.RMAN> exit; Some more words: If you want to recover ur backup to any point in timeup to 7 days ago (running “archivelog” mode only), then u may set Recovery Window-based Retention Policy of 7 days by: RMAN> configure retention policy to recovery window of 7 days; NOTE: This is old RMAN parameter, may be the new parameter set as 3 days
Last Wiki Answer Submitted:  November 4, 2010  4:13 am  by  jinteik   15,485 pts.
All Answer Wiki Contributors:  jinteik   15,485 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Configure Retention Policy is defined to establish how long a backup retain by RMAN before it is expired. If u configure a retention policy & are using FRA, then RMAN & Oracle will take care of automatically remove when it obsolate. The redundancy and the recovery window policies are manually exclusive & either of them may be defined as a time. The procedure is :
1.Launch RMAN & connect to target database (u may connect to recover catalog database if u created one) C:> RMAN TARGET /
2.To set retention policy to a redundancy of 7,
1.RMAN> configure retention policy to redundancy 7;
3.To view it
1.RMAN> show retention policy;
4.To set retention policy to a recovery window of 7 days,
1.RMAN> configure retention policy to recovery window of 7 days;
5.To clear it,
1.RMAN> configure retention policy clear;
2.RMAN> exit;

Some more words: If you want to recover ur backup to any point in timeup to 7 days ago (running “archivelog” mode only), then u may set Recovery Window-based Retention Policy of 7 days by:
RMAN> configure retention policy to recovery window of 7 days;

NOTE: This is old RMAN parameter, may be the new parameter set as 3 days

Subhendu Sen
 22,035 pts.