Re: backup policy

Posted by ErmanArslansOracleBlog on Jul 04, 2017; 2:37pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/backup-policy-tp2809p2886.html

Why do you have default retention policy of 7 days and DELETE BACKUP COMPLETED BEFORE 'SYSDATE -7';
 at the same time? What will happen if your level 0 backups will encounter errors 2 times.
Consider a scenario.

Sunday Level -> success
Wednesday Level 0 -> error
Next Sunday Level 0 -> error
----after 7-8 days --
Next Monday ->  Level1 will delete your Successful Level0. You will be without any Level 0 backups.
You should consider using the default retention policy.

You want to have a recovery windows of 7 days. Then let rman decide what to delete.
You already have "DELETE NOPROMPT OBSOLETE; " there in your script.

Check the command line by line and see if it suits your purpose.
update me if you any specific questions.