Veritas NetBackup™ Commands Reference Guide
- Introduction
- Appendix A. NetBackup Commands
- acsd
- add_media_server_on_clients
- backupdbtrace
- backuptrace
- bmrc
- bmrconfig
- bmrepadm
- bmrprep
- bmrs
- bmrsrtadm
- bp
- bparchive
- bpbackup
- bpbackupdb
- bpcatarc
- bpcatlist
- bpcatres
- bpcatrm
- bpcd
- bpchangeprimary
- bpclient
- bpclimagelist
- bpclntcmd
- bpclusterutil
- bpcompatd
- bpconfig
- bpdbjobs
- bpdbm
- bpdgclone
- bpdown
- bpduplicate
- bperror
- bpexpdate
- bpfis
- bpflist
- bpgetconfig
- bpgetdebuglog
- bpimage
- bpimagelist
- bpimmedia
- bpimport
- bpinst
- bpkeyfile
- bpkeyutil
- bplabel
- bplist
- bpmedia
- bpmedialist
- bpminlicense
- bpnbat
- bpnbaz
- bppficorr
- bpplcatdrinfo
- bpplclients
- bppldelete
- bpplinclude
- bpplinfo
- bppllist
- bpplsched
- bpplschedrep
- bppolicynew
- bpps
- bprd
- bprecover
- bprestore
- bpretlevel
- bpschedule
- bpschedulerep
- bpsetconfig
- bpstsinfo
- bpstuadd
- bpstudel
- bpstulist
- bpsturep
- bptestbpcd
- bptestnetconn
- bptpcinfo
- bpup
- bpverify
- cat_convert
- cat_export
- cat_import
- configurePorts
- create_nbdb
- csconfig cldinstance
- csconfig cldprovider
- csconfig meter
- csconfig throttle
- duplicatetrace
- importtrace
- jbpSA
- jnbSA
- ltid
- manageClientCerts
- mklogdir
- nbauditreport
- nbcatsync
- NBCC
- NBCCR
- nbcertcmd
- nbcertupdater
- nbcldutil
- nbcomponentupdate
- nbcplogs
- nbdb_admin
- nbdb_backup
- nbdb_move
- nbdb_ping
- nbdb_restore
- nbdb_unload
- nbdbms_start_server
- nbdbms_start_stop
- nbdc
- nbdecommission
- nbdelete
- nbdeployutil
- nbdevconfig
- nbdevquery
- nbdiscover
- nbdna
- nbemm
- nbemmcmd
- nbexecute
- nbfindfile
- nbfirescan
- nbftadm
- nbftconfig
- nbgetconfig
- nbhba
- nbholdutil
- nbhostidentity
- nbhostmgmt
- nbhypervtool
- nbjm
- nbkmsutil
- nboraadm
- nborair
- nbpem
- nbpemreq
- nbperfchk
- nbplupgrade
- nbrb
- nbrbutil
- nbregopsc
- nbreplicate
- nbrestorevm
- nbseccmd
- nbsetconfig
- nbsnapimport
- nbsnapreplicate
- nbsqladm
- nbstl
- nbstlutil
- nbstop
- nbsu
- nbsvrgrp
- resilient_clients
- restoretrace
- stopltid
- tl4d
- tl8d
- tl8cd
- tldd
- tldcd
- tlhd
- tlhcd
- tlmd
- tpautoconf
- tpclean
- tpconfig
- tpext
- tpreq
- tpunmount
- verifytrace
- vltadm
- vltcontainers
- vlteject
- vltinject
- vltoffsitemedia
- vltopmenu
- vltrun
- vmadd
- vmchange
- vmcheckxxx
- vmd
- vmdelete
- vmoprcmd
- vmphyinv
- vmpool
- vmquery
- vmrule
- vmupdate
- vnetd
- vwcp_manage
- vxlogcfg
- vxlogmgr
- vxlogview
- W2KOption
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