RMAN Retention Policy

5 pts.
Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Subhendu Sen
    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
    27,510 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following