Adding a mirrored transaction log on Windows

Article:HOWTO34675  |  Created: 2010-10-29  |  Updated: 2011-03-11  |  Article URL http://www.symantec.com/docs/HOWTO34675
Article Type
How To


Environment

Subject


Adding a mirrored transaction log on Windows

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 all NetBackup services by typing the following command:

    Install_path\VERITAS\NetBackup\bin\bpup

  6. Perform a catalog backup.

See About online, hot catalog backups on Windows

See Moving NBDB database files after installation on Windows


Legacy ID



v41725377_v46435090


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


Terms of use for this information are found in Legal Notices