delete noprompt obsolete
cdcrOct 21 2012 — edited Oct 21 2012Hello,
RMAN >delete noprompt obsolete;
The "delete obsolete" or "delete noprompt obsolete" will delete the archivelog files past the retention from disk and will also delete any backups on disk or tape.
My retention redundancy is 1. According to the statement above, it will delete the archivelog files and any backups on disk or tape from a previous day. My issue is that I want to delete backups on disk based on the redundancy 1, but keep the archivelogs for 5 days then delete archivelogs. So, the "delete noprompt obsolete" will not work in my case.
So, I replace this "delete obsolete" with this command "delete noprompt archivelog All completed before 'SYSDATE-5';" to delete any archivelogs that are more than 5 days old. That would solve my archivelog issues, but what happens to my backups on disk (I want to delete backups based on redundancy 1)?
Thank you.