The following is Recovery Manager tip #6 from "30 tips in 30 minutes," brought to you by the IOUG. Return to the
main page for more tips on this topic.
A backup retention policy can be configured in RMAN in Oracle9i. If 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> release channel;
Get more tips in minutes! Return to the main page.
About the author: Kenny Smith has been working with Oracle technology on HP servers for over a decade. He specializes in Oracle database architecture, database administration and development. He has presented at numerous Oracle conferences on two continents. He has published many articles describing Oracle solutions and has co-authored "Oracle backup and recovery 101" from Oracle Press.
IOUG: Become a member of the IOUG to access the paper referenced here and a repository of technical content created for Oracle users by Oracle users.