Netbackup relational database service failed to start because NBDB database transaction log (NBDB.log) may become too large or corrupt for proper NetBackup operation on Windows Master server

Article:TECH162344  |  Created: 2011-06-14  |  Updated: 2013-06-05  |  Article URL http://www.symantec.com/docs/TECH162344
Article Type
Technical Solution

Product(s)


Issue



Problem occurs when Netbackup relational database service failed to start. When performing following command Database shows unavailable.

C:\Program Files\Veritas\NetBackup\bin>nbdb_ping
Database [NBDB] is not available.


Error



Server.log file(Location :- :\Program Files\Veritas\\NetBackupDB\log) shows error :-

Transaction log: C:\Program Files\Veritas\\NetBackupDB\data\NBDB.log...
Error: Cannot open transaction log file -- The system cannot find the file specified.

Database server shutdown due to startup error
Cannot open transaction log file -- The system cannot find the file specified.


Environment



Problem occurs when transaction log for the ASA database that runs under NetBackup to become corrupt or too large for proper operation. For example, in a file system that limits file size to 2GB, the transaction log will be truncated and corrupt once it reaches the 2Gb limit. The transaction log is truncated during online catalog backup, but it might be possible that catalog backups did not take place to prevent the log from growing too large.

The ASA database failing due to transaction log problems can include these errors:
- Catalog backups and regular backups can hang.
- Operator is unable to cancel queued jobs.

- The EMM database does not come back up after restarting NetBackup


Solution



Rebuild the transaction log via the following steps:

1. Stop NetBackup if it is not already stopped:

C:\Program Files\Veritas\NetBackup\bin\bpdown -v

2. Verify that all NetBackup processes are stopped:

C:\Program Files\Veritas\NetBackup\bin\bpps

Manually kill any remaining NetBackup processes.

3. Remove NBDB and BMRDB from auto_start option

C:\Program Files\Veritas\NetBackup\bin>nbdb_admin -auto_start NONE
Successfully removed NBDB from databases.conf
Successfully removed BMRDB from databases.conf

4. Start the ASA database engine

C:\Program Files\Veritas\NetBackup\bin>bpup -e SQLANYs_VERITAS_NB

NetBackup 7.0 -- Startup Utility

NetBackup services are about to be started.
Do you wish to proceed? (y/n) y
Starting services

Start up completed successfully.

5. Remove or rename the bad transaction log:

NBDB.log NBDB.log.bad

If BMR is used, also rename the BMR transaction log:

BMRDB.log BMRDB.log.bad

6. To force database recovery, run the command (please note, the NBDB.log will not be created until step 10):

C:\Program Files\Veritas\NetBackupDB\win64>dbsrv11 "C:\Program Files\Veritas\NetBackupDB\data\NBDB.db" -f

If BMR is used , force recovery of the BMR database:

C:\Program Files\Veritas\NetBackupDB\win64>dbsrv11 "C:\Program Files\Veritas\NetBackupDB\data\BMRDB.db" -f

7. Stop the database by running the command: 

C:\Program Files\Veritas\NetBackup\bin>bpdown -e SQLANYs_VERITAS_NB

NetBackup 7.0 -- Shutdown Utility

NetBackup software will be shutdown.  This may cause backups to fail.
Do you wish to proceed? (y/n) y
Shutting down services

Shutdown completed successfully.

8. Add NBDB and BMRDB to auto_start option (Add BMRDB only if using BMR)

C:\Program Files\Veritas\NetBackup\bin>nbdb_admin -auto_start NBDB
Successfully added NBDB to databases.conf.

C:\Program Files\Veritas\NetBackup\bin>nbdb_admin -auto_start BMRDB
Successfully added BMRDB to databases.conf.

9. To start the database, run the command: 

C:\Program Files\Veritas\NetBackup\bin>bpup -e SQLANYs_VERITAS_NB

NetBackup 7.0 -- Startup Utility

NetBackup services are about to be started.
Do you wish to proceed? (y/n) y
Starting services

Start up completed successfully.


10. To test if the database is operational, run the command:

C:\Program Files\Veritas\NetBackup\bin>nbdb_ping

which should return something similar to the following:

Database [NBDB] is alive and well on server [NB_master1].

11. Start Netbackup services by running following command :-

C:\Program Files\Veritas\NetBackup\bin>bpup -v




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


Terms of use for this information are found in Legal Notices