Re: [Veritas-bu] Has anyone run a database consistency check recently?
This took way too long (over 24 hours) in our environment. It was never an option for us, unfortunately. Preston, Douglas L wrote: In windows you can run this command. "C:\Program Files\VERITAS\netbackup\bin\bpdbm" -consistency f:\catalog.consistency.txt On a *nix machine it should still be the same command While it checks the catalog it will move corrupt entries to C:\Program Files\VERITAS\netbackup\db.corrupt and your catalog backups will complete. Using this command to do the consistency check and fix it does not delete the corrupt entries so if a fix for the corrupt entries ever happen you still have them. On our catalog it takes approxamately 2 hours to run. Our catalog is 60+ gigs. Doug Preston Systems Engineer Land America Tax and Flood Services Phone 626-339-5221 Ext 1104 Email [EMAIL PROTECTED] NOTICE: This electronic mail transmission may constitute a communication that is legally privileged. It is not intended for transmission to, or receipt by, any unauthorized persons. If you have received this electronic mail transmission in error, please delete it from your system without copying it, and notify the sender by reply e-mail, so that our address record can be corrected. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 23, 2007 9:05 PM To: veritas-bu@mailman.eng.auburn.edu Subject: [Veritas-bu] Has anyone run a database consistency check recently? Hi all, We have been having issues with our catalog (running NBU 6.0 MP4) and have found that our catalog is very inconsistent. We have been running a utility from Symantec called consistency_gather.pl, which basically grabs image, media and vol DB information. We send that through to Symantec to produce a report, which we receive back. We have two NetBackup 6.0 environment, and both are reporting that we have inconsistencies in our catalog. Has anyone else run this utility and obtained a report from Symantec. In one of our report, it stats that of the 375000 images that we have, about 4700 of them could be lost due to being overwritten. We also have multiple tapes that appear to be assigned to multiple media servers, and the list goes on. Anyone else run into this type of issue? Regards Ian. National Australia Bank Ltd - ABN 12 004 044 937 This email may contain confidential information. If you are not the intended recipient, please immediately notify us at [EMAIL PROTECTED] or by replying to the sender, and then destroy all copies of this email. Except where this email indicates otherwise, views expressed in this email are those of the sender and not of National Australia Bank Ltd. Advice in this email does not take account of your objectives, financial situation, or needs. It is important for you to consider these matters and, if the e-mail refers to a product(s), you should read the relevant Product Disclosure Statement(s)/other disclosure document(s) before making any decisions. If you do not want email marketing from us in future, forward this email with "unsubscribe" in the subject line to [EMAIL PROTECTED] in order to stop marketing emails from this sender. National Australia Bank Ltd does not represent that this email is free of errors, viruses or interference. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu -- === Steven L. Sesar Lead Operating Systems Programmer/Analyst UNIX Application Services R101 The MITRE Corporation 202 Burlington Road - MS K101 Bedford, MA 01730 tel: (781) 271-7702 fax: (781) 271-2600 mobile: (617) 519-8933 email: [EMAIL PROTECTED] === ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Has anyone run a database consistency check recently?
In windows you can run this command. "C:\Program Files\VERITAS\netbackup\bin\bpdbm" -consistency >>f:\catalog.consistency.txt On a *nix machine it should still be the same command While it checks the catalog it will move corrupt entries to C:\Program Files\VERITAS\netbackup\db.corrupt and your catalog backups will complete. Using this command to do the consistency check and fix it does not delete the corrupt entries so if a fix for the corrupt entries ever happen you still have them. On our catalog it takes approxamately 2 hours to run. Our catalog is 60+ gigs. Doug Preston Systems Engineer Land America Tax and Flood Services Phone 626-339-5221 Ext 1104 Email [EMAIL PROTECTED] NOTICE: This electronic mail transmission may constitute a communication that is legally privileged. It is not intended for transmission to, or receipt by, any unauthorized persons. If you have received this electronic mail transmission in error, please delete it from your system without copying it, and notify the sender by reply e-mail, so that our address record can be corrected. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 23, 2007 9:05 PM To: veritas-bu@mailman.eng.auburn.edu Subject: [Veritas-bu] Has anyone run a database consistency check recently? Hi all, We have been having issues with our catalog (running NBU 6.0 MP4) and have found that our catalog is very inconsistent. We have been running a utility from Symantec called consistency_gather.pl, which basically grabs image, media and vol DB information. We send that through to Symantec to produce a report, which we receive back. We have two NetBackup 6.0 environment, and both are reporting that we have inconsistencies in our catalog. Has anyone else run this utility and obtained a report from Symantec. In one of our report, it stats that of the 375000 images that we have, about 4700 of them could be lost due to being overwritten. We also have multiple tapes that appear to be assigned to multiple media servers, and the list goes on. Anyone else run into this type of issue? Regards Ian. National Australia Bank Ltd - ABN 12 004 044 937 This email may contain confidential information. If you are not the intended recipient, please immediately notify us at [EMAIL PROTECTED] or by replying to the sender, and then destroy all copies of this email. Except where this email indicates otherwise, views expressed in this email are those of the sender and not of National Australia Bank Ltd. Advice in this email does not take account of your objectives, financial situation, or needs. It is important for you to consider these matters and, if the e-mail refers to a product(s), you should read the relevant Product Disclosure Statement(s)/other disclosure document(s) before making any decisions. If you do not want email marketing from us in future, forward this email with "unsubscribe" in the subject line to [EMAIL PROTECTED] in order to stop marketing emails from this sender. National Australia Bank Ltd does not represent that this email is free of errors, viruses or interference. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Has anyone run a database consistency check recently?
Yes, many times. This was a huge exposure for us at the time. The issue was that we couldn't run a consistency check on our own, mainly due to the size of our catalog. We were relegated, as you are, to sending Symantec dumps of the catalog/databases, opening up a case and waiting for them to produce a report. The critical problem with that, is that by the time we actually got the report and acted on it, the next backup run was in flight, making the report largely obsolete because the catalog/databases were now being written to again. Typically, it took a few days to clear up our inconsistencies. Also, typically, we ran this bi-weekly to keep this problem in check. This has been a serious issue with NBU for years. Because the possibility exists, as you have found out, that NBU could mark media with live images on it as scratch media, customers are always subject to losing data. Symantec knows this. At least in our environment, we, nor Symantec we never able to determine what we could do to keep these inconsistencies from occurring in the first place. At the time, the utility that Symantec used to determine inconsistencies was kept from customers. It was/is called NBCC. My understanding is that it may be available to end users now, but for a long time, customers were, in essence, unable to help themselves in this regard. So, yes, I am suggesting that inherently, NBU *is* subject to data loss, silently and at any time, due to the fact that their catalog/databases cannot remain consistent. === Steven L. Sesar Lead Operating Systems Programmer/Analyst UNIX Application Services R101 The MITRE Corporation 202 Burlington Road - MS K101 Bedford, MA 01730 tel: (781) 271-7702 fax: (781) 271-2600 mobile: (617) 519-8933 email: [EMAIL PROTECTED] === -Original Message- From: [EMAIL PROTECTED] on behalf of [EMAIL PROTECTED] Sent: Fri 8/24/2007 12:04 AM To: veritas-bu@mailman.eng.auburn.edu Subject: [Veritas-bu] Has anyone run a database consistency check recently? Hi all, We have been having issues with our catalog (running NBU 6.0 MP4) and have found that our catalog is very inconsistent. We have been running a utility from Symantec called consistency_gather.pl, which basically grabs image, media and vol DB information. We send that through to Symantec to produce a report, which we receive back. We have two NetBackup 6.0 environment, and both are reporting that we have inconsistencies in our catalog. Has anyone else run this utility and obtained a report from Symantec. In one of our report, it stats that of the 375000 images that we have, about 4700 of them could be lost due to being overwritten. We also have multiple tapes that appear to be assigned to multiple media servers, and the list goes on. Anyone else run into this type of issue? Regards Ian. National Australia Bank Ltd - ABN 12 004 044 937 This email may contain confidential information. If you are not the intended recipient, please immediately notify us at [EMAIL PROTECTED] or by replying to the sender, and then destroy all copies of this email. Except where this email indicates otherwise, views expressed in this email are those of the sender and not of National Australia Bank Ltd. Advice in this email does not take account of your objectives, financial situation, or needs. It is important for you to consider these matters and, if the e-mail refers to a product(s), you should read the relevant Product Disclosure Statement(s)/other disclosure document(s) before making any decisions. If you do not want email marketing from us in future, forward this email with "unsubscribe" in the subject line to [EMAIL PROTECTED] in order to stop marketing emails from this sender. National Australia Bank Ltd does not represent that this email is free of errors, viruses or interference. ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
[Veritas-bu] Has anyone run a database consistency check recently?
Hi all, We have been having issues with our catalog (running NBU 6.0 MP4) and have found that our catalog is very inconsistent. We have been running a utility from Symantec called consistency_gather.pl, which basically grabs image, media and vol DB information. We send that through to Symantec to produce a report, which we receive back. We have two NetBackup 6.0 environment, and both are reporting that we have inconsistencies in our catalog. Has anyone else run this utility and obtained a report from Symantec. In one of our report, it stats that of the 375000 images that we have, about 4700 of them could be lost due to being overwritten. We also have multiple tapes that appear to be assigned to multiple media servers, and the list goes on. Anyone else run into this type of issue? Regards Ian. National Australia Bank Ltd - ABN 12 004 044 937 This email may contain confidential information. If you are not the intended recipient, please immediately notify us at [EMAIL PROTECTED] or by replying to the sender, and then destroy all copies of this email. Except where this email indicates otherwise, views expressed in this email are those of the sender and not of National Australia Bank Ltd. Advice in this email does not take account of your objectives, financial situation, or needs. It is important for you to consider these matters and, if the e-mail refers to a product(s), you should read the relevant Product Disclosure Statement(s)/other disclosure document(s) before making any decisions. If you do not want email marketing from us in future, forward this email with "unsubscribe" in the subject line to [EMAIL PROTECTED] in order to stop marketing emails from this sender. National Australia Bank Ltd does not represent that this email is free of errors, viruses or interference.___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu