11g RMAN backup archive logs, delete options

  • From: "CRISLER, JON A (ATTCORP)" <JC1706@xxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 18 May 2011 19:12:16 +0000

I want to combine the functions of deleting archive logs based on date AND that 
they have been backed up already.  Is this possible ?

For instance this will delete all the archive logs backed up (regulated by rman 
archive log deletion policy)

Run {
backup as compressed backupset
archivelog all
delete all input;

This would delete archive logs-

delete archivelog all completed before 'sysdate -7';

What I am looking for is deleting them based on date, and that they have been 
backed up.

Other related posts: