Veritas-bu

Re: [Veritas-bu] RMAN crosscheck

2010-05-19 16:27:29
Subject: Re: [Veritas-bu] RMAN crosscheck
From: "Lightner, Jeff" <jlightner AT water DOT com>
To: "David McMullin" <David.McMullin AT CBC-Companies DOT com>, <veritas-bu AT mailman.eng.auburn DOT edu>
Date: Wed, 19 May 2010 16:27:25 -0400
Thanks.

As noted in my original question though, I already do see the images
using NBU utilities.   The question is how can we restore those images
if RMAN doesn't know they exist?  

The first reply to my original indicated that one has to use RMAN to
recover and RMAN doesn't know they're there.  The mail you quoted below
had a link that seemed to suggest you could make RMAN know by using
crosscheck to talk to "media manager" which I assumed meant NBU in this
case.   

It seems you're now saying that isn't reliable so I'm back to the
original question above.   Symantec's response you quoted seems to
indicate there is some value knowing where the NBU images are but
doesn't answer the question.

Perhaps there's a flawed assumption?  Does a restore from NBU have to be
done via RMAN if it was backed up via RMAN?   Does it not matter that it
isn't in the RMAN catalog so long as it is in the NBU catalog?

-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of David
McMullin
Sent: Wednesday, May 19, 2010 4:17 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] RMAN crosscheck

I am working with my DBA and Symantec, opened a ticket and found this
issue from the RMAN side:

Here is my note to them:
Please review case # 291-053-107.
Our Oracle DBA are extremely upset that the tools available to them to
troubleshoot in a DR situation are so poor.
They have no reliable way to determine something as simple as which
media to request.
* The Oracle RMAN utility, referencing the control files or RMAN catalog
database, knows what backupsets are needed for a restore.
* Only RMAN knows what backup pieces are needed for a restore.
* While there is an RMAN command that will list the images that a
particular backupset resides on, but this list is incomplete if an image
spans several media.

NOTE THIS PART! but this list is incomplete if an image spans several
media.

Here is Symantec response:
I consulted with my seniors and my peers who work with NOM, and
unfortunately we do not have a report that can show us the backupset
mapping with the media id.  So we'll have to follow the same procedure
to know the media-ids:
 
Oracle DBA tells you the data range information, client name from the
backupset query. 
You can run bpimagelist and bpimmedia commands to know the medias
required for recovery of that backupset.


>Message: 7
>Date: Wed, 19 May 2010 15:04:54 +0200
>From: Michael Graff Andersen <mian71 AT gmail DOT com>
>Subject: Re: [Veritas-bu] RMAN crosscheck
>To: "Lightner, Jeff" <jlightner AT water DOT com>
>Cc: veritas-bu AT mailman.eng.auburn DOT edu,  Kevin Corley
>       <Kevin.Corley AT apollogrp DOT edu>
>Message-ID:
>       <AANLkTikyYlBqQBQAkuc6433Zt-LTm6hwqIxc8bWVhPm1 AT mail.gmail DOT com>
>Content-Type: text/plain; charset="windows-1252"
>
>Think there is, at least according to this page
>http://ss64.com/ora/rman_crosscheck.html
>
>Regards
>Michael

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
 
Proud partner. Susan G. Komen for the Cure.
 
Please consider our environment before printing this e-mail or attachments.
----------------------------------
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential 
information and is for the sole use of the intended recipient(s). If you are 
not the intended recipient, any disclosure, copying, distribution, or use of 
the contents of this information is prohibited and may be unlawful. If you have 
received this electronic transmission in error, please reply immediately to the 
sender that you have received the message in error, and delete it. Thank you.
----------------------------------
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

<Prev in Thread] Current Thread [Next in Thread>