Wednesday, September 7, 2011

A sample backup retention policy by RMAN

A sample backup retention policy  by RMAN 


A backup retention policy can be configured in RMAN . Starting from Oracle9i it is supported. 
Say  you want to retain backups for four weeks, configure RMAN to retain backups with the configure command:
RMAN> configure retention policy to recovery window of 28 days;
When a backup becomes older than four weeks, RMAN marks it as obsolete. To delete these old backups, allocate a maintenance channel and delete them:
RMAN> allocate channel for maintenance device type disk;
RMAN> delete obsolete;
RMAN>

No comments:

Post a Comment