Hot catalog backup fails with "status code 2" during validation of NBAZDB

Problem

During a hot catalog the automatic validation of the NBAZDB may fail, causing a status code 2 for the backup.  BMRDB and NBDB both got validated successfully.

If validation is manually disabled, the validation during a catalog backup is successful.

Error Message

The job details when this occur will be similar to the following:

08.07.2011 12:01:30 - Info bpdbm (pid=8528) staging relational database files for catalog backup
08.07.2011 12:01:30 - Info bpdbm (pid=8528) staging BMRDB backup to D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging
08.07.2011 12:01:31 - Info bpdbm (pid=8528) done staging BMRDB backup to D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging
08.07.2011 12:01:31 - Info bpdbm (pid=8528) done staging NBAZDB backup to D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging
08.07.2011 12:01:31 - Info bpdbm (pid=8528) staging NBDB backup to D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging
08.07.2011 12:01:38 - Info bpdbm (pid=8528) done staging NBDB backup to D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging
08.07.2011 12:02:30 - Info bpdbm (pid=8528) validating BMRDB backup in D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging
08.07.2011 12:02:34 - Info bpdbm (pid=8528) done validating BMRDB backup in D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging
08.07.2011 12:02:34 - Info bpdbm (pid=8528) validating NBAZDB backup in D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging
08.07.2011 12:02:34 - Error bpdbm (pid=8528) error validating NBAZDB backup in D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging
08.07.2011 12:02:34 - Info bpdbm (pid=8528) validating NBDB backup in D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging
08.07.2011 12:02:36 - Info bpdbm (pid=8528) done validating NBDB backup in D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging none of the requested files were backed up (2)


The bpdbm log will show the following error:


12:02:34.068 [8528.1512] <4> validate_database: Executing D:\Applications\Basic\prg\VERITAS\NetBackupDB\Win64\dbvalid -q -fx -c "UID=dba;PWD=******;ENG=validation_eng;LINKS=shmem;START=D:\Applications\Basic\prg\VERITAS\NetBackupDB\Win64\dbeng11 -c 25M -ch 500M -cl 25M \"D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging\NBAZDB.db\" -ds \"D:\Applications\Basic\prg\VERITAS\NetBackupDB\staging\""
12:02:34.645 [8528.1512] <16> validate_database: Database validation failed for database NBAZDB
12:02:34.645 [8528.1512] <4> db_error_add_to_file: Database validation failed for database NBAZDB.
12:02:34.645 [8528.1512] <4> validate_database: Exiting. rc = 11

Cause

The can be caused if the AZ_DB_PASSWORD information is missing or corrupt in the <install_path>\Veritas\NetBackupdb\data\vxdbms.conf file.

 

Solution

From Install_path\Veritas\Netbackup\bin

1)  Run:
nbdb_admin -dba nbusql
***This should create the missing AZ_DB_PASSWORD password line in vxdbms.conf

2) Run:
nbdb_admin -validate BMRDB; nbdb_admin -validate NBAZDB; nbdb_admin -validate

***This will manually validate all databases.

3)  If the validation in #2 succeeds run a hot catalog backup. It should complete successfully for all databases available.

 

 

Applies To

Windows 2003 or 2008 Master servers.

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)