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-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of David McMullin Sent: Wednesday, May 19, 2010 4:17 PM To: veritas-bu@mailman.eng.auburn.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 <mia...@gmail.com> >Subject: Re: [Veritas-bu] RMAN crosscheck >To: "Lightner, Jeff" <jlight...@water.com> >Cc: veritas-bu@mailman.eng.auburn.edu, Kevin Corley > <kevin.cor...@apollogrp.edu> >Message-ID: > <aanlktikyylbqqbqakuc6433zt-ltm6hwqixc8bwvh...@mail.gmail.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@mailman.eng.auburn.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@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu