Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN: Retention Policy VS Archivelog Deletion Policy

user8894222May 23 2014 — edited Aug 6 2014

I'm a newbie to RMAN so I've been doing a lot of reading and experimenting and I'm stuck on a problem.

TASK: I want to keep two days of archived logs and one days worth of backups.

SOLUTION: set retention policy to 1, set the archive deletion policy to 2

                   (CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;)

                 and this is my simple backup script

               run

               {

               backup tag 'nightly_backup' database plus archivelog ;

               delete noprompt obsolete;

                }

PROBLEM: This doesn't work. Oracle documentation clearly states (as clearly as the documentation can be) that "delete obsolete" uses the retention policy for deleting the archived logs; and to delete according to the archivelog deletion policy to use "delete archivelog all".

My testing verifies this.

QUESTION. How do I delete the obsolete database backupsets ONLY using the delete command?

--Mark

This post has been answered by user8894222 on Jul 25 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2014
Added on May 23 2014
8 comments
9,308 views