Configure a retention policy in RMAN 9i

Recovery Manager tip #6 from "30 tips in 30 minutes," brought to you by the IOUG.

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.

Dig Deeper on Oracle database backup and recovery



Forgot Password?

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

Your password has been sent to: