Delete Obsolete
723408Sep 21 2009 — edited Sep 21 200910.2.0.4 Windows 2003 Server
Retention policy is defined as 6 Days. Initially we were using RMAN command "DELETE NOPROMPT OBSOLETE;" (through a scheduled script) to delete the obsolete backup sets and archive logs. But the problem is some files in old backups and archive not get deleted and keep piling up. So we started using following
DELETE NOPROMPT BACKUP COMPLETED BEFORE 'SYSDATE-6';
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-6';
And above does the job. My question is why the "DELETE NOPROMPT OBSOLETE;" is keeping some files in old backup sets and archive log directories? Is there any issues if use above 2 commands instead of "DELETE NOPROMPT OBSOLETE;".
Thanks!