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 on a Windows computer
- Perform a catalog backup.
- Shut down all NetBackup services by typing the following command:
install_path\Veritas\NetBackup\bin\bpdown
- Start the SQL Anywhere service by typing the following command:
install_path\Veritas\NetBackup\bin\bpup -e SQLANYs_VERITAS_NB
- Create the mirrored transaction log:
Enter the following command:
install_path\Veritas\NetBackup\bin\nbdb_move.exe -mloglog_mirror_directory
To move the existing data, index, transaction log files, and create the mirrored transaction log, enter the following command:
install_path\Veritas\NetBackup\bin\nbdb_move.exe -datadata_directory-index index_directory -tlog log_directory-mlog log_mirror_directory
- Start all NetBackup services by typing the following command:
install_path\Veritas\NetBackup\bin\bpup
- Perform a catalog backup.
To create a mirrored transaction log on a UNIX computer
- Perform a catalog backup.
- Shut down all NetBackup daemons by typing the following command:
/usr/openv/netbackup/bin/bp.kill_all
- Start the SQL Anywhere daemon by typing the following command:
/usr/openv/netbackup/bin/nbdbms_start_stop start
- Create the mirrored transaction log:
Enter the following command:
/usr/openv/db/bin/nbdb_move -mlog log_mirror_directory
To move the existing data, index, transaction log files, and create the mirrored transaction log, enter the following command:
/usr/openv/db/bin/nbdb_move -data data_directory-index index_directory -tlog log_directory-mlog log_mirror_directory
- Start all NetBackup daemons by typing the following command:
/usr/openv/netbackup/bin/bp.start_all
- Perform a catalog backup.