We did still have NBU images of the backups that initiated the RMAN backups but once RMAN had expired its own images, these were essentially useless. I don't believe that RMAN is able to query NBU's catalog as part of the crosscheck anyway.
Mark Glazerman Desk: 314-889-8282 Cell: 618-520-3401 P please don't print this e-mail unless you really need to From: Lightner, Jeff [mailto:jlight...@water.com] Sent: Wednesday, May 19, 2010 8:55 AM To: Mark Glazerman; Michael Graff Andersen Cc: Kevin Corley; veritas-bu@mailman.eng.auburn.edu Subject: RE: [Veritas-bu] RMAN crosscheck Thanks. I thought I'd understood you earlier to say you had extant NBU images that you couldn't restore because RMAN said they were expired. If you have no backup images anywhere then nothing's going to recover them even if they aren't marked expired even if it's a "standard" backup. ________________________________ From: Mark Glazerman [mailto:mark.glazer...@spartech.com] Sent: Wednesday, May 19, 2010 9:50 AM To: Lightner, Jeff; Michael Graff Andersen Cc: Kevin Corley; veritas-bu@mailman.eng.auburn.edu Subject: RE: [Veritas-bu] RMAN crosscheck I'm not sure if our DBA's tried this exact method but in our environment, where we back up only to Data Domain, we don't have another repository (eg. Vaulted Tape) to look for any RMAN backup pieces. Once RMAN had expired the images we needed and they had been cleared off the data domain, there was nowhere else where we could look for components to put together a successful restore via RMAN. Mark Glazerman Desk: 314-889-8282 Cell: 618-520-3401 P please don't print this e-mail unless you really need to From: Lightner, Jeff [mailto:jlight...@water.com] Sent: Wednesday, May 19, 2010 8:43 AM To: Michael Graff Andersen Cc: Mark Glazerman; Kevin Corley; veritas-bu@mailman.eng.auburn.edu Subject: RE: [Veritas-bu] RMAN crosscheck That looks promising. Have you used it successfully? Mark - did you try this when you had your issue? ________________________________ From: Michael Graff Andersen [mailto:mia...@gmail.com] Sent: Wednesday, May 19, 2010 9:05 AM To: Lightner, Jeff Cc: Mark Glazerman; Kevin Corley; veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] RMAN crosscheck Think there is, at least according to this page http://ss64.com/ora/rman_crosscheck.html Regards Michael 2010/5/17 Lightner, Jeff <jlight...@water.com> That's unfortunate. It seems that there ought to be a way to have RMAN rebuild its catalog from NBU much the same the way that NBU can recover images into its catalog from NBU expired but not yet overwritten tapes. ________________________________ From: Mark Glazerman [mailto:mark.glazer...@spartech.com] Sent: Monday, May 17, 2010 12:30 PM To: Lightner, Jeff; Kevin Corley Cc: veritas-bu@mailman.eng.auburn.edu Subject: RE: [Veritas-bu] RMAN crosscheck Autobackup is an RMAN setting. We use autobackup and had recovered the controlfile for the attempted restore I talked about earlier. However, because RMAN had already expired the required images from its own catalog, we were unable to recover the data, even with backup images still residing in the Netbackup catalog. Mark Glazerman Desk: 314-889-8282 Cell: 618-520-3401 P please don't print this e-mail unless you really need to From: Lightner, Jeff [mailto:jlight...@water.com] Sent: Monday, May 17, 2010 11:27 AM To: Kevin Corley; Mark Glazerman Cc: veritas-bu@mailman.eng.auburn.edu Subject: RE: [Veritas-bu] RMAN crosscheck Thanks guys. Is autobackup a setting in RMAN or in NBU? ________________________________ From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Kevin Corley Sent: Monday, May 17, 2010 12:23 PM To: Mark Glazerman; Lightner, Jeff Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] RMAN crosscheck As long as you have autobackup enabled, you shouldn't need the rman repository. If netbackup has the images in the catalog, restore the control file from autobackup, which has the rman pieces info and will poll netbackup for the images associated with them. From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Mark Glazerman Sent: Monday, May 17, 2010 8:58 AM To: Lightner, Jeff Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] RMAN crosscheck Jeff, I can only really comment on your last question about using expired RMAN images for restores if they are not expired in NetBackup. We had a similar issue a few weeks back where Netbackup could still see images in its catalog of oracle backups (which initiate a RMAN backup via the oracle_backup.sh script) but RMAN had already expired them inside its own catalog. These files were not recoverable by RMAN. We had the DBA's set their retention inside RMAN to match the retention specified inside NBU so that we don't see this mis-match again. Ultimately, RMAN controls the expiration of the images inside its catalog meaning that regardless of the expiration you set for oracle backups inside NBU, RMAN will keep or expire those images, regardless of what Netbackup is trying to tell it. I don't know how you'd configure RMAN to handle your vaulting needs. Would setting the expiration of these images in RMAN to the longest required length of time (4 months for example) mean that the vaulted images would still be good for the max time they'd need to be held on either the Data Domain or tape ? The Netbackup catalog doesn't need to know about the RMAN images for them to still be recoverable by RMAN so you could set a different, shorter expiration inside NBU although this would still leave you with different retentions in the two different catalogs FYI The solaris client we were trying to restore these RMAN images to is running 6.5.4 with a 7.0 master and media server. Mark Glazerman Desk: 314-889-8282 Cell: 618-520-3401 P please don't print this e-mail unless you really need to From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Lightner, Jeff Sent: Friday, May 14, 2010 7:12 AM To: veritas-bu@mailman.eng.auburn.edu Subject: [Veritas-bu] RMAN crosscheck My DBAs are starting to question me about an RMAN crosscheck they are running. Essentially I gather that when they ran it the crosscheck seemed to report even backups run in the last 2 days as expired. On checking the Data Domain unit I can see the images are still there and on running NetBackup commands I see these are NOT expired from NBU's perspective. On doing a search I did find a document at Symantec that talked about RMAN expirations but it only went up through 6.0 so I'm not sure if it is still valid for 6.5. It says essentially that on the NBU side we should set very long retentions (e.g. INFINITY) for all RMAN backup policies then let RMAN keep track of retentions itself. The downside I see to this is we do vaulting of the images on data domain to tape - we set retention on data domain to 1 month then the vault copies get longer retentions (e.g. 3 months for a daily backup). How would we get RMAN to set and keep track of such retention differences? The DBAs have opened a TAR with Oracle to see why the crosscheck is reporting the images as expired but I suspect from the NBU document that the answer will be something like "it is expired so far as RMAN is concerned". This also begs the question as to whether RMAN could be used to restore the backups even if they aren't expired so far as NBU is concerned. Does anyone know the answer to that? 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. ---------------------------------- ________________________________ This message is private and confidential. If you have received it in error, please notify the sender and remove it from your system. _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu