# Full System Recovery of DB2 Database: Restoring the DB2 Database

Restore and bring up each dropped database from its database backup image in the event of a disaster.

Note

DB2 point-in-time (PIT) roll forward restore is supported with log caching enabled.

## Before You Begin

Rebuild the operating system

## Procedure

1. From the Command Center navigation pane, go to Protect > Databases.

   The Instances page appears.

2. Click the instance.

   The instance page appears.

3. On the Overview tab, in the upper-right corner of the Recovery points section, select the database from the list, and then click Restore.

   The Backup content page appears.

4. Select the data to restore, and then click Restore.

   The Restore options dialog box appears.

5. To restore the database, on the In place tab, select the Restore database checkbox.

6. To roll forward the logs as part of the restore operation, select the Roll forward checkbox.

   - To roll forward to the end of all the logs, click To end of the logs.

   - To roll forward to a point in time, click Point in time, and then enter the point in time.

   If you don't roll forward the logs the target database will be in the "rollforward pending" state after the restore.

   Note

   Point-in-time restores are still possible even if Disk Caching is enabled for the transaction log backups.

7. To restore the logs, in the Advanced options section select the Restore logs checkbox, and then specify the time period of the logs to restore.

8. Click Submit.

## What to Do Next

After the database is restored, verify that the restored database and log files are available in the original location.

×

Loading...