I had the same problem so just changed the delete to delete FORCE noprompt archivelog all backed up 3 times to DEVICE type SBT_TAPE; Cheers, Ian |---------+-----------------------------> | | mschmitt@uchicago.| | | edu | | | Sent by: | | | oracle-l-bounce@fr| | | eelists.org | | | | | | | | | 17/08/2010 19:40 | | | Please respond to | | | mschmitt | | | | |---------+-----------------------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| | | | To: Oracle-L@xxxxxxxxxxxxx | | cc: | | Subject: RMAN-08138: WARNING | >--------------------------------------------------------------------------------------------------------------------------------------------------| Hi All, I am trying to edit our RMAN scripts to delete archives that have been sent to tape 3 times. I am using the following command delete noprompt archivelog all backed up 3 times to DEVICE type SBT_TAPE; This works fine in 9i,10g, but in 11g RMAN throws the following error for any logs that have not been backed up 3 times yet RMAN-08138: WARNING: archived log not deleted - must create more backups archived log file name=/backup/SID/arch/SIDlog_2394_713128766_1.ARC thread=1 sequence=2394 It is not that big of a deal, but it causes our script to send out an email since it thinks it is an actual error. Does anyone know of a work around that will cause Oracle to act like 10g and not throw the warning message? Otherwise I will just edit the error handling of our backup script Thanks in advance This email was received from the INTERNET and scanned by the Government Secure Intranet anti-virus service supplied by Cable&Wireless Worldwide in partnership with MessageLabs. (CCTM Certificate Number 2009/09/0052.) In case of problems, please call your organisation?x02019;s IT Helpdesk. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes. For the latest data on the economy and society consult National Statistics at http://www.ons.gov.uk ********************************************************************************* Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications ********************************************************************************* Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics ********************************************************************************* The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless Worldwide in partnership with MessageLabs. (CCTM Certificate Number 2009/09/0052.) On leaving the GSi this email was certified virus free. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes. -- //www.freelists.org/webpage/oracle-l