How to rebuild the NetBackup Database (NBDB)

Description

This is intended to supplement the Veritas NetBackup™ Commands Reference Guide for nbdb_unload and nbdb_admin.

Prerequisite: Perform an online backup of NBDB prior to initiating the rebuild process.

• UNIX/Linux: /usr/openv/db/bin/nbdb_backup -dbn NBDB -online /{destination with sufficient space for NBDB}
• Windows: C:\Program Files\Veritas\NetBackup\bin\nbdb_backup -dbn NBDB -online {drive letter:\{destination with sufficient space for NBDB}}

Starting with Netbackup 9.1 a service user account is capable of running services.  Please run with that user if different than root for validation to succeed. 

1. Identify service user with /usr/openv/netbackup/bin/admincmd/bpgetconfig SERVICE_USER

2.  Switch to that user to run the commands.  su <user>

Start the rebuilding process:

1. Stop NetBackup services:
   • UNIX/Linux: /usr/openv/netbackup/bin/bp.kill_all FORCEKILL
   • Windows: C:\Program Files\Veritas\NetBackup\bin\bpdown -f -v
2. Start only the database server:
   • UNIX/Linux: /usr/openv/netbackup/bin/nbdbms_start_stop start
   • Windows:
     • NBU version 10.2 and above: C:\Program Files\Veritas\NetBackup\bin\bpup -e vrtsdbsvc_psql
     • NBU version 7.x to 10.1.x: C:\Program Files\Veritas\NetBackup\bin\bpup -e SQLANYs_VERITAS_NB
     • NBU version 6.x: C:\Program Files\Veritas\NetBackup\bin\bpup -e ASANYs_VERITAS_NB
3. Verify the DB is online:
   • UNIX/Linux: /usr/openv/db/bin/nbdb_ping
   • Windows: C:\Program Files\Veritas\NetBackup\bin\nbdb_ping
4. Start Rebuild:
   • UNIX/Linux: /usr/openv/db/bin/nbdb_unload -rebuild -verbose
   • Windows: C:\Program Files\Veritas\NetBackup\bin\nbdb_unload -rebuild -verbose
5. Start Reorganize:
   • UNIX/Linux: /usr/openv/db/bin/nbdb_admin -reorganize -verbose
   • Windows: C:\Program Files\Veritas\NetBackup\bin\nbdb_admin -reorganize -verbose
6. (Optional) Rebuild Again:
   • UNIX/Linux: /usr/openv/db/bin/nbdb_unload -rebuild -verbose
   • Windows: C:\Program Files\Veritas\NetBackup\bin\nbdb_unload -rebuild -verbose
7. Validate the DB again and advise of the outcome:
   • UNIX/Linux: /usr/openv/db/bin/nbdb_admin -validate
   • Windows: C:\Program Files\Veritas\NetBackup\bin\nbdb_admin -validate
8. Start the NetBackup services:
   • UNIX/Linux: /usr/openv/netbackup/bin/goodies/netbackup start
   • Windows: C:\Program Files\Veritas\NetBackup\bin\bpup -f -v