nbdb_unload

nbdb_unload — unload NetBackup databases (NBDB) or BMR (BMRDB)

SYNOPSIS

<nbu_dir_path>nbdb_unload [-dbn database_name] [-t tablelist] [-s] destination directory

<nbu_dir_path>nbdb_unload [-dbn database_name] -rebuild [-verbose]

On Windows systems, <nbu_dir_path> 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 considered a component of the NBDB database. In the future other components will be added to the NBDB such as IRM and POLICY.

This 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. A reload.sql file is also generated. This file contains the SQL statements that are required to reload the database. For example:

LOAD TABLE "BmrDba.BMR_Configuration" FROM

Windows systems: c:\temp\data\345.dat

To transfer the destination directory contents to a support machine and use it to create a copy of the customer's database, run the reload.sql file.

OPTIONS

-dbn database_name

Specifies the database that is to be unloaded.

-rebuild

Rebuilds the NetBackup database (the default NBDB).

-s

Unloads the schema only - no data is unloaded.

-t tablelist

Specifies a comma-separated list of tables to unload instead of all the tables in the database.

-verbose

Generates more detailed information to the output.

destination directory

The directory where a user wants the dump of the data and schema to go.

EXAMPLES

EXAMPLE 1

To unload the NBDB database (including all of EMM), data and schema:

Windows systems: # nbdb_unload C:\temp\nbdb_dump

EXAMPLE 2

To unload only the NBDB schema:

Windows systems: # nbdb_unload -s C:\temp\nbdb_dump

EXAMPLE 3

To unload only the EMM_STU table (by using fully qualified table names):

Windows systems: # nbdb_unload -t EMM_MAIN.EMM_STU C:\temp\stu

EXAMPLE 4

To unload the BMR database:

Windows systems: # nbdb_unload -dbn BMRDB C:\temp\bmr_dump