How to create a blank NBDB database for recovery of a NetBackup NBDB database from an online catalog backup in case of corruption or failure

Description

This article describes how to create a blank NetBackup NBDB database for the recovery of the NetBackup NBDB database from an online catalog backup in case of corruption or failure.

If the NetBackup NBDB database does not start, use the following method to create a blank database for catalog recovery.  

Note: This procedure erases the current NetBackup NBDB database.

1. Stop NetBackup by running the following command:

UNIX:
   /usr/openv/netbackup/bin/goodies/netbackup stop
Windows:
   <install_path>\NetBackup\bin\bpdown  

2. Change the databases.conf file so Sybase ASA does not attempt to automatically start NBDB when the server is started.

UNIX:
  /usr/openv/db/bin/nbdb_admin -auto_start NONE
Windows:
  <install_path>\NetBackup\bin\nbdb_admin -auto_start NONE
 

3. Copy all existing database files to a new location. That includes the following files:

8.x:  NBDB.db, NBDB.log, EMM_INDEX.db, EMM_DATA.db, vxdbms.conf
The following additional database files added since 7.x , also are available in 8.x DBM_DATA.db, DBM_INDEX.db, DARS_DATA.db, DARS_INDEX.db

If a mirrored transaction log is used, copy NBDB.m.log as well.

By default, the database files are located in the following directory:

UNIX:
  /usr/openv/db/data/
Windows:
  <install_path>\NetBackupDB\data

If the database was moved to a different location, find the VXDBMS_NB_DATA value:

UNIX:
   Review the /usr/openv/netbackup/bp.conf file
Windows:
   HKEY_LOCAL_MACHINE\SOFTWARE\VERITAS\NetBackup\CurrentVersion\Config registry location

4. Delete the database files in the data directory, including vxdbms.conf.

5. Start the Sybase ASA server by running the following command:

UNIX:
(in a BASH shell) source /usr/openv/db/vxdbms_env.sh
  /usr/openv/netbackup/bin/nbdbms_start_stop start
Windows (NBU 6.X):
  <install_path>\NetBackup\bin\bpup -e ASANYs_VERITAS_NB
Windows (NBU 7.X, 8.X):
   <install_path>\NetBackup\bin\bpup -e SQLANYs_VERITAS_NB

6. Re-create an empty database by running the command below that corresponds to your NetBackup version and OS:  

UNIX (NetBackup 6.0, 6.5, and 7.x, 8.x):
   /usr/openv/db/bin/create_nbdb 

Windows (NetBackup  installed in default C:\Program Files directory):
   <install_path>\NetBackup\bin\create_nbdb -db_server <VERITAS_NB_servername>
Where VERITAS_NB_servername is located in <install_path>\NetBackupDB\conf\server.conf

Windows (NetBackup  installed in a directory other than C:\Program Files):
  <install_path>\NetBackup\bin\create_nbdb -db_server VERITAS_NB_servername -db_home "<install_path>\NetBackupDB"

Windows (NetBackup 6.5 and 7.x, 8.x):
  <install_path>\NetBackup\bin\create_nbdb
 

NOTE: This step creates a temporary database in the default location. 

 If the database has been moved or the environment is clustered, add -staging  staging_dir   to the end of the create_nbdb command line.

 If the database has been moved or if the environment is clustered,  and space constraints or other issues force you to create this temporary database in the final location 

  then this temporary database needs to be created in the final location,  by using the following commands:

  notice; the catalog recovery performed in step 13 creates the database in the correct location, and deletes this temporary database. 

UNIX (NetBackup 7.x , 8.x):
  /usr/openv/db/bin/create_nbdb -data <data_directory> -index <index_directory> -tlog <tlog_directory> -staging <staging_directory>

Windows (NetBackup  installed in default C:\Program Files directory):
   <install_path>\NetBackup\bin\create_nbdb -db_server VERITAS_NB_servername -data <data_directory> -index <index_directory> -tlog <tlog_directory> -staging <staging_directory>


Windows (NetBackup  installed in a directory other than C:\Program Files):
   <install_path>\NetBackup\bin\create_nbdb -db_server VERITAS_NB_servername -data <data_directory> -index <index_directory> -tlog <tlog_directory> -staging <staging_directory> -db_home "<install_path>\NetBackupDB"

Windows (NetBackup 6.5 and 7.x, 8.x):
   <install_path>\NetBackup\bin\create_nbdb -data <data_directory> -index <index_directory> -tlog <tlog_directory> -staging <staging_directory>

NOTE: The <data_directory>, <index_directory>,  <tlog_directory> and  <staging_directory> values are defined in the vxdbms.conf file as VXDBMS_NB_DATA, VXDBMS_NB_INDEX, VXDBMS_NB_TLOG and VXDBMS_NB_STAGING

7. Stop and restart NetBackup by running the following commands:

UNIX:
   /usr/openv/netbackup/bin/goodies/netbackup stop
   /usr/openv/netbackup/bin/goodies/netbackup start
Windows:
   <install_path>\NetBackup\bin\bpdown
   <install_path>\NetBackup\bin\bpup

8. Run tpext:

UNIX :
   /usr/openv/volmgr/bin/tpext
UNIX :
   /usr/openv/volmgr/bin/tpext -loadEMM
Windows :
   <install_path>\Volmgr\bin\tpext
Windows :
   <install_path>\Volmgr\bin\tpext -loadEMM

9. If the nbdb_move command was used to relocate NetBackup database files, re-create the directories where the files were located at the time of the catalog backup.  The default location is:

UNIX:
   /usr/openv/db/data
Windows:
   <install_path>\NetBackupDB\data

10. Start the device manager by running the following command:

UNIX:
   /usr/openv/volmgr/bin/ltid -v
Windows:
   Start the Device Manager service.

11. Configure the necessary recovery device in NetBackup.  If problems are encountered configuring devices, please see the Related Documents section below for information on the EMM server failing to process the request.

12. Make available to NetBackup the media that contains the catalog backup. Inventory the robot or add the media for standalone drives.

13. For online catalog recovery, run the following command on the master server:

UNIX:
   /usr/openv/netbackup/bin/admincmd/bprecover -r -nbdb
Windows:
   Start the Device Manager service. <install_path>\NetBackup\bin\admincmd\bprecover -r -nbdb

14. Stop and restart NetBackup by running the following command:

UNIX:
   /usr/openv/netbackup/bin/goodies/netbackup stop /usr/openv/netbackup/bin/goodies/netbackup start
Windows:
   <install_path>\NetBackup\bin\bpdown
   <install_path>\NetBackup\bin\bpup

If a remote EMM server is being used, start NetBackup on the remote EMM server before starting NetBackup on the master server.

Applies To

The information in this article pertains to versions of NetBackup up to and including 7.x and 8.x.