Jeff - I am pretty sure that there should be synchronizing of the expiration 
date within RMAN and NetBackup - although the expiration of images within RMAN 
is handled here by our DBA group. Our process is to backup the control file 
right after the RMAN backup and our restore process starts with restoring that 
control file.

I know how to "un-expire" or extend the expiration date of NetBackup images, 
but I do not know how we would accomplish that within the RMAN control file.

We use an 8 week retention period here and have never had issues recovering 
data, beyond the frustrating part of sometimes being unable to determine what 
tapes are needed until we try to restore and it asks for an unexpected tape...




-----Original Message-----
From: Lightner, Jeff [mailto:jlightner AT water DOT com] 
Sent: Wednesday, May 19, 2010 4:27 PM
To: David McMullin; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] RMAN crosscheck

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