Moving NBDB database files after installation
In the case of large databases, you can change the location of the database files or split the database files into multiple directories to improve performance.
Note:
Due to performance issues, NetBackup supports database files only on locally attached drives.
Note:
Run a catalog backup to back up NBDB and BMRDB both before and after moving the database files.
To move the NBDB and the BMRDB database files on Windows
- 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
- Use one of the following methods to move the existing data, index, and transaction log files:
Use the NetBackup Database Administration utility.
Enter the following command:
install_path\Veritas\NetBackup\bin\nbdb_move.exe
-data data_directory
-index index_directory -tlog log_directory
You can run the nbdb_move command at any time because it does not drop the database and recreate it. Thus, all data is preserved.
If a mirrored transaction log is in use, enter the following command:
install_path\Veritas\NetBackup\bin\nbdb_move.exe -data data_directory
-index index_directory -tlog log_directory
-mlog log_mirror_directory
Note:
NetBackup does not require that the database directories are world-writable. Make sure that the new database directories (data_directory, index_directory, log_directory, and log_mirror_directory) have appropriate permissions so that the directories are not world-writable.
- Start all services by typing the following command:
install_path\Veritas\NetBackup\bin\bpup
- Perform a catalog backup.
To move the NBDB and the BMRDB database files on UNIX
- 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
- Use one of the following methods to move the existing data, index, and transaction log files:
Use the NetBackup Database Administration utility.
Enter the following command:
/usr/openv/db/bin/nbdb_move
-data data_directory
-index index_directory -tlog log_directory
You can run the nbdb_move command at any time because it does not drop the database and recreate it. Thus, all data is preserved.
If a mirrored transaction log is in use, enter the following command:
/usr/openv/db/bin/nbdb_move -data data_directory
-index index_directory -tlog log_directory
-mlog log_mirror_directory
Note:
NetBackup does not require that the database directories are world-writable. Make sure that the new database directories (data_directory, index_directory, log_directory, and log_mirror_directory) have appropriate permissions so that the directories are not world-writable.
- Start all NetBackup daemons by typing the following command:
/usr/openv/netbackup/bin/bp.start_all
- Perform a catalog backup.
More Information
About NetBackup master server installed directories and files