Commands for backing up and recovering the relational databases
The recommended method to protect the relational databases is to use the catalog backup and recovery interfaces.
A temporary backup of the NBDB and BMRDB databases can be made for extra protection before database administration activities such moving or reorganizing the database files.
Table: Commands used to back up and recover relational databases
Command | Description |
|---|---|
nbdb_backup or nbdb_backup.exe | Use nbdb_backup or nbdb_backup.exe to make a copy of the NBDB database files and the BMRDB database files in a directory. The nbdb_backup command does not truncate the transaction log. Transaction logs are managed only by using the catalog backup. On Windows: install_path\NetBackup\bin\nbdb_backup.exe [-dbn database_name] -online destination_directory [tlog_only] [-truncate_tlog] On UNIX: /usr/openv/db/bin/nbdb_backup [-dbn database_name] -online destination_directory [tlog_only] [-truncate_tlog] -dbn database_name only backs up the specified database (NBDB or BMRDB). -online destination_directory is the location for the copied files. -tlog_only generates only the database transaction log along with the configuration files for the backup. -truncate_tlog truncates the database transaction log after the backup completes the backup. Note: Using this command (or the NetBackup Database Administration utility) to back up the NetBackup database can potentially break the consistency between the NetBackup catalog and the database. This loss of consistency can lead to loss of data. Use this command (or the NetBackup Database Administration utility) to back up the NetBackup catalog only as a precautionary measure. |
nbdb_restore or nbdb_restore.exe | Use nbdb_restore to recover from a database backup that was made using nbdb_backup. On Windows: install_path\NetBackup\bin\nbdb_restore.exe -recover source_directory -dbn database_name [-ignore_tlog] On UNIX: /usr/openv/db/bin/nbdb_restore -recover source_directory -dbn database_name [-ignore_tlog] Logs are recorded in the /admin or \admin directory. nbdb_restore restores from the staging directory to recover only the NetBackup database (NBDB). The default is to apply the current transaction log to make the database as consistent as possible with the current db\images or /db/images directory. -ignore_tlog does not apply the current transaction log to the NBDB recovery operation. Note: Using this command (or the NetBackup Database Administration utility) to restore the NetBackup database can potentially break the consistency between the NetBackup catalog and the database. This loss of consistency can lead to loss of data. Use this command (or the NetBackup Database Administration utility) to restore the NetBackup catalog only as a precautionary measure. |