Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Share this Page URL
Help

Database recovery > Dropped database recovery - Pg. 11

2.2 Database recovery This section lists the assets that are involved in database recovery. 2.2.1 Database point-in-time recovery Table 2-1 lists the assets that are required for a database point-in-time recovery. Table 2-1 Database point-in-time recovery assets Recovery Asset Database backup Database log records Fast Backup image Comment Full offline database backup required. Backup as frequently as your current recovery strategy. Must be available if rolling forward beyond backup. The database can be recovered using a volume restore or database object restore from a Fast Backup image. 2.2.2 Dropped database recovery Table 2-2 lists the assets that are required for a dropped database recovery. Table 2-2 Dropped database recovery assets Recovery Asset Database backup Comment Full offline database backup required. Backup as frequently as your current recovery strategy. Online backup is not suitable because DB2 RE does not allow roll forward in this situation. Must be available if rolling forward beyond backup. If an object has been dropped, you cannot use Fast Backup image. Database log records Fast Backup image Chapter 2. Planning for recovery 11