Veritas NetBackup™ Commands Reference Guide
- Introduction
- Appendix A. NetBackup Commands
Name
nbdb_unload — unload NetBackup databases (NBDB) or BMR (BMRDB)
SYNOPSIS
[-dbn database_name] [-t tablelist] [-s] [-staging] destination directory
[-dbn database_name] -rebuild [-verbose]
On UNIX systems, the directory path to this command is /usr/openv/db/bin/
On Windows systems, the directory path to this command is <install_path>\NetBackup\bin\
DESCRIPTION
The nbdb_unload command unloads the specified database. By default the NBDB database is unloaded. The other value for -dbn includes BMRDB for the Bare Metal Restore database.
Note:
The Enterprise Media Manager (EMM) database is a component of the NBDB database.
The nbdb_unload command creates .dat files, one for each table in the database or in the table list. Each .dat file contains comma-separated lines, one for each row in the table. It also creates a reload.sql
file that contains the SQL statements that are required to reload the database. For example:
LOAD TABLE "BmrDba.BMR_Configuration" FROM
UNIX systems:
/temp/data/345.dat
Windows systems:
c:\temp\data\345.dat
Run the reload.sql
file to transfer the destination directory contents to a support computer and use it to create a copy of the customer's database.
OPTIONS
- -dbn database_name
Specifies the database that is to be unloaded.
- -rebuild
Rebuilds the default NetBackup database (NBDB).
- -s
Unloads the schema only - no data is unloaded.
- -staging
Unloads the media table and related tables to a set of flat files. You can use SQL tools to insert the subset of data that is needed into another copy of NBDB.
- -t tablelist
Specifies a comma-separated list of tables to unload instead of all the tables in the database.
- -verbose
Generates more detailed information for the output.
- destination directory
Specifies the directory where the user wants the dump of the data and schema.
EXAMPLES
Example 1 - Unload the NBDB database (including all of EMM), data and schema:
UNIX systems: # nbdb_unload /tmp/nbdb_dump
Windows systems: # nbdb_unload C:\temp\nbdb_dump
Example 2 - Unload only the NBDB schema:
UNIX systems: # nbdb_unload -s /tmp/nbdb_dump
Windows systems: # nbdb_unload -s C:\temp\nbdb_dump
Example 3 - Unload only the EMM_STU table (by using fully qualified table names):
UNIX systems: # nbdb_unload -t EMM_MAIN.EMM_STU /tmp/stu
Windows systems: # nbdb_unload -t EMM_MAIN.EMM_STU C:\temp\stu
Example 4 - Unload the BMR database:
UNIX systems: # nbdb_unload -dbn BMRDB /tmp/bmr_dump
Windows systems: # nbdb_unload -dbn BMRDB C:\temp\bmr_dump