Re: archivelogs deletion

Posted by ErmanArslansOracleBlog on Aug 07, 2018; 8:14am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/archivelogs-deletion-tp6540p6541.html

Your script has the following lines for deleting the backups;

DELETE FORCE NOPROMPT OBSOLETE;
DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 3 TIMES to disk;

So , you are deleting obsolete backups in each backup run..
+ you are deleting archivelog backups if they are already backed up 3 times..

You have level0 + level1 backup and you have a rman retention policy, which will directly effeect the deletion of obsoletes.. (configure retention policy to recovery window of 20 DAYS;)

So probably, your backup schedule is not aligned with your deletion policy.

1)Check your scheduling accordingly..
2)Also , ensure that, your backups are completed successfully.
3)If you have a standby db, this may also prevent archivelog deletion.. In default conf, iF archivelogs are not applied to standby, they won't be deleted...