Setting the transaction mode for NBDB.log and BMRDB.log

Use the NetBackup Database Administration utility to set the transaction log mode for NBDB.log and BMRDB.log. The transaction mode determines when the transaction log is automatically truncated outside of the catalog backup process.

To set the transaction log mode for NBDB.log and BMRDB.log

  1. Start the NetBackup Database Administration utility that is located in the following directory:

    InstallPath\VERITAS\NetBackup\bin\NbDbAdmin.exe

  2. Enter the database login password and click OK.

    See Using the NetBackup Database Administration utility.

  3. Select the Tools tab.

  4. In the Transaction Log section, click Modify.

  5. In the Transaction Log Mode dialog box, select from one of the following log modes:

    Full (default)

    With Full selected, the transaction log is truncated automatically after a successful online (hot) or offline (cold) catalog backup. All of the database files are included in the backup. (NBDB, NBDB.db, EMM_DATA.db, EMM_INDEX.db, NBDB.log.)

    The differential incremental schedule for the online (hot) catalog backup includes only the transaction log file.

    To recover using a full and an incremental backup, all of the database files are restored and the transaction logs are applied one at a time in order.

    Partial

    With Partial selected, all schedules used for the hot catalog backup policies include backups of all of the relational database files.

    Partial mode forces a deletion of the transaction log whenever a database checkpoint occurs.

    In Partial mode, the online (hot) catalog backup must always be a full backup and all incremental schedules are automatically converted to full schedules by NetBackup. The cold catalog backup is always a full backup.

  6. Click OK. The new log settings go into effect after the NetBackup services are restarted.

More Information

Truncating the transaction log

General tab of the NetBackup Database Administration utility

Tools tab of the NetBackup Database Administration utility