Veritas NetBackup™ for DB2 Administrator's Guide
- Introduction to NetBackup for DB2
- Installing NetBackup for DB2
- Verifying the operating system and platform compatibility
- About log archiving
- 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
- Creating DB2 scripts manually
- 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
Performing a snapshot rollback restore from the command line
This topic describes how to perform a snapshot rollback restore with the bpdb2proxy command.
To specify a snapshot rollback restore from the command line
- If the file .SQLCRT.FLG exists, delete it.
DB2 creates the .SQLCRT.FLG file when it creates a directory (usually during tablespace creation). For volume level rollback restores this file cannot be present. The directory structure must be present at the time DB2 creates a tablespace or you must delete this file after DB2 creates the directory during tablespace creation.
- Use the bpdb2proxy command in the following format:
UNIX: /usr/openv/netbackup/bin/bpdb2proxy -rollbkrestore -d <DBALIAS> [-u <user> -p <password>] [-s <sessions>] [-n <node number>] [-t <mm/dd/yyyy [HH:MM:SS]>] [-S <ServerName>] [-options <options string>]
Windows: install_path\NetBackup\bpdb2proxy -rollbkrestore -d <DBALIAS> [-u <user> -p <password>] [-s <sessions>] [-n <node number>] [-t <mm/dd/yyyy [HH:MM:SS]>] [-S <ServerName>] [-options <options string>]
Specifies that this restore is from a snapshot rollback.
User name of the DB2 user.
Password for the DB2 user.
The number of sessions. Optional.
The node number. The default is 0. Optional.
-t mm/dd/yyyy [HH:MM:SS]
(Optional) The time of the backup.
The values are as follows:
For mm, type the month.
For dd, type the day of the month.
For yyyy, type the year.
For HH, type the hour of the day. Optional.
For MM, type the minute of the hour. Optional.
For SS, type the second of the minute. Optional.
The name of the server the restore is performed on.
-options <options string>
Specifies the options that are to be used for the restore operation. Currently, the only option is DB2_RESTORE_PRIORITY. By default, the preset priority for restore jobs is 90000, which is the highest preset job priority of any other NetBackup job. The available range is 0 - 99999. The higher the number, the greater the job priority.
You must use an = sign to specify the value of the option. Example:
bpdb2proxy -options "DB2_RESTORE_PRIORITY=100"