Veritas NetBackup™ for DB2 Administrator's Guide
- Introduction to NetBackup for DB2
- Installing NetBackup for DB2
- Configuring NetBackup for DB2
- About configuring a backup policy for DB2
- About adding backup selections to a DB2 policy
- About backing up archive log files with the user exit program
- Configuring the run-time environment
- Creating a db2.conf file for use with the user exit program
- Creating a db2.conf file (vendor method)
- Configuring bp.conf files in a cluster environment
- About NetBackup for DB2 templates and shell scripts
- Performing backups and restores of DB2
- About user-directed backups
- Performing a database restore
- About an alternate restore
- Using Snapshot Client with NetBackup for DB2
- About NetBackup for DB2 with Snapshot Client operations
- Restoring NetBackup for DB2 from a snapshot backup
- About configuring NetBackup for DB2 block-level incremental backups on UNIX
- Configuring policies for BLI backups with NetBackup for DB2
- About Snapshot Client effects
- Troubleshooting NetBackup for DB2
- About the NetBackup for DB2 log files
- Appendix A. Configuration for a DB2 EEE (DPF) environment
- Appendix B. Using NetBackup for DB2 with SAP®
- Appendix C. Register authorized locations
Using bpdbsbdb2 for a database restore
The bpdbsbdb2 command lets you run a recovery template that the NetBackup Recovery wizard creates.
At the command line, type the following:
Windows: install_path\netbackup\bin\bpdbsbdb2 -restore -r -t templ_name -i instance_name
UNIX: /usr/openv/netbackup/bin/bpdbsbdb2 -restore -r -t template_name -i instance_name
The -r runs a template, and the -t identifies the template.
For example:
Windows: bpdbsbdb2 -restore -r -t \db2\restore_templates\full_restore.tpl -i DB2INST
UNIX: /usr/openv/netbackup/bin/bpdbsbdb2 -restore -r \ -t /db2/restore_templates/full_restore.tpl -i DB2INST
Restore templates do not reside in a predetermined location on the master server. They are considered to be temporary in nature and should reside on the client. If the full path is not specified as part of the restore template name, the file might not be found.
You can create a script from a template with bpdbsbdb2.