Re: RMAN-08138: WARNING

  • From: Ian Cary <ian.cary@xxxxxxxxxxxxxx>
  • To: mschmitt@xxxxxxxxxxxx
  • Date: Wed, 18 Aug 2010 16:19:01 +0100

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


Other related posts: