Re: [Veritas-bu] RMAN and NetBackup Question
NetBackup is ALWAYS the one to get the blame – network, devices, OS, databases, etc.. etc…! M. From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of rusty.ma...@sungard.com Sent: 16 May 2011 10:52 PM To: Patrick Cc: veritas-bu-boun...@mailman.eng.auburn.edu; veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] RMAN and NetBackup Question Patrick, It's ALWAYS someone else's fault. Haven't you learned that by now? Rusty Major, MCSE, BCFP, VCS ▪ Sr. Storage Engineer ▪ SunGard Availability Services ▪ 757 N. Eldridge Suite 200, Houston TX 77079 ▪ 281-584-4693 Keeping People and Information Connected® ▪ http://availability.sungard.com/ P Think before you print CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this e-mail in error, please notify the sender and delete this e-mail from your system. Patrick netbac...@whelan-consulting.co.uk Sent by: veritas-bu-boun...@mailman.eng.auburn.edu 05/13/2011 02:53 PM To 'Justin Piszcz' jpis...@lucidpixels.com cc veritas-bu@mailman.eng.auburn.edu Subject Re: [Veritas-bu] RMAN and NetBackup Question Thank you all for the fast replies. I don't have access to the Oracle servers so I have to rely on the DBAs. They sent an RMAN log file that showed some images were expired. After tracking down the NetBackup equivalent, I looked on the disk where it was stored and the image was there. The bplist -t 4 does indeed agree with the physical image. As to what mechanism they are using to determine the expiration, I don't know, but I will try to ask on Monday. While I really would like to know why the discrepancy, I am also curious as to why the RMAN log now show the images are not expired. One other note: the environment is such that the DBAs always blame NetBackup first, until I can prove to them it is there fault. Is that what most of you run into? Regards, Patrick Whelan VERITAS Certified NetBackup Support Engineer for UNIX. VERITAS Certified NetBackup Support Engineer for Windows. netbac...@whelan-consulting.co.uk -Original Message- From: Justin Piszcz [mailto:jpis...@lucidpixels.com] Sent: 13 May 2011 20:36 To: Patrick Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] RMAN and NetBackup Question Hi, Have you given the DBA(s) the bplist output or show them how to use it on the client/confirmed that the images that they are looking for *are* there, e.g. bplist -t 4? Justin. On Fri, 13 May 2011, Patrick wrote: Hi All, I have a strange question. Has anyone seen a situation where RMAN says the backup image has expired, but NetBackup says they exist? And then later, next day, RMAN says the image does exist. Very strange. Environment: NetBackup 7.0.1 Master and Media servers Solaris 10 on Intel. Oracle servers Solaris 10 SPARC. Backed up to advanced disk, the SLP duped to tape. Both disk and tape have the same retention level, which is more than long enough to cover the period in question. Any help/suggestions welcomed. Regards, Patrick Whelan VERITAS Certified NetBackup Support Engineer for UNIX. VERITAS Certified NetBackup Support Engineer for Windows. mailto:netbac...@whelan-consulting.co.uk netbac...@whelan-consulting.co.uk ___ 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
Re: [Veritas-bu] RMAN and NetBackup Question
Patrick, It's ALWAYS someone else's fault. Haven't you learned that by now? Rusty Major, MCSE, BCFP, VCS ▪ Sr. Storage Engineer ▪ SunGard Availability Services ▪ 757 N. Eldridge Suite 200, Houston TX 77079 ▪ 281-584-4693 Keeping People and Information Connected® ▪ http://availability.sungard.com/ P Think before you print CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this e-mail in error, please notify the sender and delete this e-mail from your system. Patrick netbac...@whelan-consulting.co.uk Sent by: veritas-bu-boun...@mailman.eng.auburn.edu 05/13/2011 02:53 PM To 'Justin Piszcz' jpis...@lucidpixels.com cc veritas-bu@mailman.eng.auburn.edu Subject Re: [Veritas-bu] RMAN and NetBackup Question Thank you all for the fast replies. I don't have access to the Oracle servers so I have to rely on the DBAs. They sent an RMAN log file that showed some images were expired. After tracking down the NetBackup equivalent, I looked on the disk where it was stored and the image was there. The bplist -t 4 does indeed agree with the physical image. As to what mechanism they are using to determine the expiration, I don't know, but I will try to ask on Monday. While I really would like to know why the discrepancy, I am also curious as to why the RMAN log now show the images are not expired. One other note: the environment is such that the DBAs always blame NetBackup first, until I can prove to them it is there fault. Is that what most of you run into? Regards, Patrick Whelan VERITAS Certified NetBackup Support Engineer for UNIX. VERITAS Certified NetBackup Support Engineer for Windows. netbac...@whelan-consulting.co.uk -Original Message- From: Justin Piszcz [mailto:jpis...@lucidpixels.com] Sent: 13 May 2011 20:36 To: Patrick Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] RMAN and NetBackup Question Hi, Have you given the DBA(s) the bplist output or show them how to use it on the client/confirmed that the images that they are looking for *are* there, e.g. bplist -t 4? Justin. On Fri, 13 May 2011, Patrick wrote: Hi All, I have a strange question. Has anyone seen a situation where RMAN says the backup image has expired, but NetBackup says they exist? And then later, next day, RMAN says the image does exist. Very strange. Environment: NetBackup 7.0.1 Master and Media servers Solaris 10 on Intel. Oracle servers Solaris 10 SPARC. Backed up to advanced disk, the SLP duped to tape. Both disk and tape have the same retention level, which is more than long enough to cover the period in question. Any help/suggestions welcomed. Regards, Patrick Whelan VERITAS Certified NetBackup Support Engineer for UNIX. VERITAS Certified NetBackup Support Engineer for Windows. mailto:netbac...@whelan-consulting.co.uk netbac...@whelan-consulting.co.uk ___ 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
Re: [Veritas-bu] RMAN and NetBackup Question
RMAN and NetBackup each has a retention and one can normally restore from a backup that has expired from neither. (One can add back a unexpired NetBackup image into the RMAN catalog, as one can import a tape image back into the NetBackup catalog) RMAN does not know the Netbackup retention nor does NetBackup know the RMAN retention. There are RMAN commands to bring these into (momentary) sync, deleting items in the RMAN catalog or control file and NetBackup. For example, I use (on my tapeless system) these RMAN commands, weekly: - delete noprompt obsolete device type disk; - crosscheck backup; - delete noprompt expired backup device type disk; It should be noted that RMAN retention policies can be more complex than, or different from, Netbackup's simple keep for n days. I have no clue how RMAN could change its mind unless somehow the control file and RMAN catalog were different and one query used the catalog and the other didn't. Cheers, Wayne On Fri, May 13, 2011 at 3:31 PM, Patrick netbac...@whelan-consulting.co.ukwrote, in part: ... I have a strange question. Has anyone seen a situation where RMAN says the backup image has expired, but NetBackup says they exist? And then later, next day, RMAN says the image does exist. Very strange. ... ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] RMAN and NetBackup Question
Hi, Have you given the DBA(s) the bplist output or show them how to use it on the client/confirmed that the images that they are looking for *are* there, e.g. bplist -t 4? Justin. On Fri, 13 May 2011, Patrick wrote: Hi All, I have a strange question. Has anyone seen a situation where RMAN says the backup image has expired, but NetBackup says they exist? And then later, next day, RMAN says the image does exist. Very strange. Environment: NetBackup 7.0.1 Master and Media servers Solaris 10 on Intel. Oracle servers Solaris 10 SPARC. Backed up to advanced disk, the SLP duped to tape. Both disk and tape have the same retention level, which is more than long enough to cover the period in question. Any help/suggestions welcomed. Regards, Patrick Whelan VERITAS Certified NetBackup Support Engineer for UNIX. VERITAS Certified NetBackup Support Engineer for Windows. mailto:netbac...@whelan-consulting.co.uk netbac...@whelan-consulting.co.uk ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] RMAN and NetBackup Question
Hi, The retention set on the master server ultimately decides how long it is on tape, if there is a discrepancy between what the RMAN catalog server thinks and the netbackup master server thinks, then that could be one of the problems. Does/do your DBAs know what retention you use? Justin. On Fri, 13 May 2011, Patrick wrote: Thank you all for the fast replies. I don't have access to the Oracle servers so I have to rely on the DBAs. They sent an RMAN log file that showed some images were expired. After tracking down the NetBackup equivalent, I looked on the disk where it was stored and the image was there. The bplist -t 4 does indeed agree with the physical image. As to what mechanism they are using to determine the expiration, I don't know, but I will try to ask on Monday. While I really would like to know why the discrepancy, I am also curious as to why the RMAN log now show the images are not expired. One other note: the environment is such that the DBAs always blame NetBackup first, until I can prove to them it is there fault. Is that what most of you run into? Regards, Patrick Whelan VERITAS Certified NetBackup Support Engineer for UNIX. VERITAS Certified NetBackup Support Engineer for Windows. netbac...@whelan-consulting.co.uk -Original Message- From: Justin Piszcz [mailto:jpis...@lucidpixels.com] Sent: 13 May 2011 20:36 To: Patrick Cc: veritas-bu@mailman.eng.auburn.edu Subject: Re: [Veritas-bu] RMAN and NetBackup Question Hi, Have you given the DBA(s) the bplist output or show them how to use it on the client/confirmed that the images that they are looking for *are* there, e.g. bplist -t 4? Justin. On Fri, 13 May 2011, Patrick wrote: Hi All, I have a strange question. Has anyone seen a situation where RMAN says the backup image has expired, but NetBackup says they exist? And then later, next day, RMAN says the image does exist. Very strange. Environment: NetBackup 7.0.1 Master and Media servers Solaris 10 on Intel. Oracle servers Solaris 10 SPARC. Backed up to advanced disk, the SLP duped to tape. Both disk and tape have the same retention level, which is more than long enough to cover the period in question. Any help/suggestions welcomed. Regards, Patrick Whelan VERITAS Certified NetBackup Support Engineer for UNIX. VERITAS Certified NetBackup Support Engineer for Windows. mailto:netbac...@whelan-consulting.co.uk netbac...@whelan-consulting.co.uk ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu