On Wed, May 18, 2011 at 12:12 PM, CRISLER, JON A (ATTCORP) <JC1706@xxxxxxx>wrote: > 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; > > } > > ... > Jon, If you don't already know it, RMAN has a very useful feature for checking syntax when playing with stuff like this $ORACLE_HOME/bin/rman checksyntax Now run scripts and type commands - they just get parsed, not executed. RMAN will tell you the syntax is OK, or raise an error. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com