BUG REPORT: NetBackup database validation may fail after an upgrade to NetBackup 7.0.

Article:TECH127720  |  Created: 2010-01-17  |  Updated: 2010-01-22  |  Article URL http://www.symantec.com/docs/TECH127720
Article Type
Technical Solution


Environment

Issue



BUG REPORT: NetBackup database validation may fail after an upgrade to NetBackup 7.0.

Error



SQL error (-300) -- Run time SQL error -- Database validation failed for database file "/usr/openv/db/data/EMM_DATA.db"

Solution



Bug: 1997378

Detail/Symptom(s):
Performing a command line validation fails.

Example:
# /usr/openv/db/bin/nbdb_admin -validate -full
SQL error (-300) -- Run time SQL error -- Database validation failed for database file "/usr/openv/db/data/EMM_DATA.db"
SQL Anywhere Validation Utility Version 11.0.1.2222
VALIDATE DATABASE
Database validation failed for page 51c8d000 of database file "/usr/openv/db/data/EMM_DATA.db"
VALIDATE TABLE "DARS_MAIN"."DARS_Oracle_ArchiveLog"
VALIDATE TABLE "DBM_MAIN"."DBM_ImageChangeLog"
VALIDATE TABLE "EMM_MAIN"."EMM_AllocationStatus"
VALIDATE TABLE "RB_MAIN"."RB_Allocation"
VALIDATE TABLE "SYS"."ISYSARTICLE"
VALIDATE TABLE "dbo"."EXCLUDEOBJECT"
VALIDATE TABLE "rs_systabgroup"."rs_lastcommit"
1 error reported
Database [NBDB] validation failed.

Log Files: None

Workaround:
Use the validation procedure in TechNote 340464 (linked below) after ensuring that all NetBackup services on the master have been stopped, followed by a manual restart of ONLY the database service.

Note: Validating a table or an entire database should be performed while no connections are making changes to the database; otherwise, errors may be reported indicating some form of database corruption even though no corruption actually exists.

ETA of Fix:
Symantec has acknowledged that the above-mentioned issue (Etrack 1997378) is present in the current version(s) of the product(s) mentioned at the end of this article. Symantec is committed to product quality and satisfied customers.

Symantec currently plans to address this issue by way of a patch or hotfix to the current version of the software. Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here. A link to the patch or hotfix download will be added to this document when it becomes available. Please note that Symantec reserves the right to remove any fix from the targeted release if it does not pass quality assurance tests. Symantec's plans are subject to change and an action taken by you based on the above information or your reliance upon the above information is made at your own risk.



Supplemental Materials

SourceETrack
Value1997378
DescriptionFull EMM Database Validation fails after Upgrade from v6.5.4 to v7.0

SourceETrack
Value1997084
Description( EEB's Available under this Etrack ) Full EMM Database Validation fails after Upgrade from v6.5.4 to v7.0


Legacy ID



347462


Article URL http://www.symantec.com/docs/TECH127720


Terms of use for this information are found in Legal Notices