XVI | DB2 Backup/Recovery Notes (OSS Note 83000) |
NOTE: The procedures described here are applicable to DB2 Version 8. Version 8 provides two new utilities for backup and point in time recovery that provides a more robust solution that is less prone to errors, and reduces recovery time and labor time. These new utilities are described later in this section.
DB2 Backup
-DB2 Image Copy
-Volume Level (hardware assisted such as FlashCopy or DSS DASD Dump/Restore)
Database Recovery
-to current end of log
-to prior point in time represented by a log RBA
-determined by business needs
DB2 Image Copy
-Offline - not useful with R/3 in general
-Online - used by almost all customers, used for recover to current
Volume Level
-DB2 Suspend Log
-FlashCopy/SnapShot/EMC TimeFinder
-DB2 Resume Log
-used as a base for prior point in time recovery
*Need to perform both types of backup, image copy:
-allows recovery of individual tablespaces
-allows management of the size of SYSLGRNX by deleting old image copies
Unit Of Recovery
-DB2 : does not span R/3 dialog steps, resolved at DB2 startup
-SAP: spans multiple dialog steps, uses VBLOG, resolved using transaction SM13 and parameter rdisp/vbreorg
Recover to Current
-Standard DB2 Recovery
-Recover damaged objects
-RECOVER TABLESPACE/RECOVER INDEXSPACE
-Image Copy + Apply Logs
Copyright 2006 IBM Solutions Technical Sales (STS) | 12/18/2007Page 43 of 51 |
12/18/2007 |
|
