it would be something like the following: delete archivelog until time 'sysdate - 7' backed up 1 times to device type disk; [or "device type sbt" in case of tape] Rui Amaral Database Administrator ITS - SSG TD Bank Financial Group 220 Bay St., 11th Floor Toronto, ON, CA, M5K1A2 (bb) (647) 204-9106 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of CRISLER, JON A (ATTCORP) Sent: Wednesday, May 18, 2011 3:12 PM To: oracle-l@xxxxxxxxxxxxx Subject: 11g RMAN backup archive logs, delete options 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. NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal for instructions. AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au www.td.com/francais/avis_juridique pour des instructions.