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