Adding a mirrored transaction log

The transaction logs NBDB.log and BMRDB.log are critical files used to recover the SQL Anywhere databases.

For extra protection, use a mirrored transaction log. Create this mirrored log in a different directory from the original log.

To create a mirrored transaction log

  1. Perform a catalog backup.

  2. Shut down all NetBackup services by typing the following command:

    Install_path\VERITAS\NetBackup\bin\bpdown

  3. Start the SQL Anywhere service by typing the following command:

    Install_path\VERITAS\NetBackup\bin\bpup -e SQLANYs_VERITAS_NB

  4. Use one of the following methods to create the mirrored transaction log:

    • Use the NetBackup Database Administration utility.

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

      See Truncating the transaction log.

    • Type the following command:

      Install_path\NetBackup\bin\nbdb_move.exe -mloglog_mirror_directory

      To move the existing data, index, transaction log files, and create the mirrored transaction log, type the following command:

      Install_path\NetBackup\bin\nbdb_move.exe -datadata_directory-index index_directory -tlog log_directory-mlog log_mirror_directory

  5. Start up all NetBackup services by typing the following command:

    Install_path\VERITAS\NetBackup\bin\bpup

  6. Perform a catalog backup.