Re: RMAN backup of archived log fails

Syed,

That's exactly what I'm afraid of. The backup exists on some tape managed by NetBackup, which may or may not be available at the time of issuing the crosscheck command. If it's not available, and what you say is true (and I understand it the same way), then I effectively lose a perfectly good backup, don't I. Surely there is a more robust way to get this sorted. Anyone?

Cheers,
Tony

Syed Jaffar Hussain wrote:
> Tony,
> >>
>
> Thanks. I did come across that one, but the doco tells me that it will
> verify the physical existence of the backup, doesn't it?
>
> >>
> crosscheck will mark the backup piece as expired status in case if it
> is unreadable or absent.
>
> crosscheck archivelog all command basically remove the reference from
> RMAN repository when objects no longer available on disk.
>
> --
> Best Regards,
> Syed Jaffar Hussain
> Oracle ACE
> 8i,9i & 10g OCP DBA
>
> http://jaffardba.blogspot.com/
> http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
> ----------------------------------------------------------------------------------
> "Winners don't do different things. They do things differently."

-- 
Tony van Lingen



___________________________
Disclaimer

WARNING: This e-mail (including any attachments) has originated from a Queensland Government department and may contain information that is confidential, private, or covered by legal professional privilege, and may be protected by copyright.  

You may use this e-mail only if you are the person(s) it was intended to be sent to and if you use it in an authorised way.  No one is allowed to use, review, alter, transmit, disclose, distribute, print or copy this e-mail without appropriate authority.  If you have received this e-mail in error, please inform the sender immediately by phone or e-mail and delete this e-mail, including any copies, from your computer system network and destroy any hardcopies.

Unless otherwise stated, this e-mail represents the views of the sender and not the views of the Environmental Protection Agency.

Although this e-mail has been checked for the presence of computer viruses, the Environmental Protection Agency provides no warranty that all viruses have been detected and cleaned. Any use of this e-mail could harm your computer system.  It is your responsibility to ensure that this e-mail does not contain and is not affected by computer viruses, defects or interference by third parties or replication problems (including incompatibility with your computer system).

E-mails sent to and from the Environmental Protection Agency will be electronically stored, managed and may be audited, in accordance with the law and Queensland Government Information Standards (IS31, IS38, IS40, IS41 and IS42) to the extent they are consistent with the law.

___________________________

--
http://www.freelists.org/webpage/oracle-l