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

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close