How to perform a consistency check of the NetBackup EMM and BMR databases using the command line or NetBackup NBDbAdmin(Windows) or dbadm(UNIX/Linux) utilities.
Two methods exist for validating the consistency of the NetBackup EMM (Enterprise Media Manager) and BMR (Bare Metal Restore) Databases. One is performed from a command line interface CLI and the other by using the NetBackup database administration utility which is included in NetBackup 6.5.2 or later.
Note: Before performing a consistency check, stop all NetBackup Services on the EMM server.
The master and EMM servers are usually the same server.
Once all services have stopped, start only the ASA Service.
6.x: <install_path>\Veritas\NetBackup\bin>bpup -e ASANYs_VERITAS_NB
7.x: <install_path>\Veritas\NetBackup\bin>bpup -e SQLANYs_VERITAS_NB
# /usr/openv/netbackup/bin/nbdbms_start_stop start
Method 1: Using the command line interface (CLI):
To perform a consistency check from the CLI, issue the following commands:
<install_path>\NetBackup\bin>nbdb_admin <databasename> -validate -full
# cd /usr/openv/db/bin
# ./nbdb_admin <databasename> -validate -full
If any inconsistencies are found, they will be reported.
For a consistent database, no errors reported will be returned as output.
Method 2: Using the NetBackup Database Administration utility:
To perform the consistency check using the NB DB Admin Utility (provided in NetBackup 6.5.2 or later) do the following:
The NbDbAdmin GUI will load up and ask for the database password. If the password has never been changed, enter the default password nbusql. The tool will present you with the General tab. When the tool starts up, it will implicitly run a consistency check of the database. If no errors are found, the tool will report Database NBDB is alive and well. To check the BMR database, select the BMRDB and run the validation by navigating: General tab > Validation > Validate > Full. Confirm that no errors were reported by checking the final line of the output.
# cd /usr/openv/db/bin
The dbadm MUI (menu user interface) will open and ask for the database password. If the password has never been changed, enter the default nbusql. As with the Windows GUI, the UNIX MUI also implicitly checks the consistency of the EMM database when it is started. If no errors are found, the database consistency will be displayed as OK. To check the BMR database, select the BMRDB, enter choice 4 and run a Full validation.