Restoring DB2 MultiNode Logs

You can restore log files separately or together with the database you want to restore.

By default, the software restores the log files to the DB2 retrieve path specified during the installation of the DB2 Agent.

Use archive log restores in the following cases:

• When the database fails and needs to be recovered to its most recent state, restore all the logs along with the database.

• When logs from a specific time range are lost due to a hard disk corruption, perform a point-in-time restore.

• When you need to restore specific log files that are missing in the database, you can identify the logs using time ranges.

In-Place Restore

Procedure

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

   The database Overview page appears.

2. Go to the Instances tab.

3. In the row for the database instance to restore, click the Action button , and then click Restore.

   Alternatively, click the instance, and from the Recovery points tiles, select Restore option.

   The Backup content page appears.

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

   The Restore options dialog box appears.

5. Select In place option.

   Note

   The In place option is selected by default.

6. Select the Redirect option to direct the restore to other database location.

7. Select the Restore database checkbox.

8. Select the Roll forward checkbox to roll forward the logs as part of the restore operation.

   From the Roll forward to type list, make the following selections:

   • 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.

   • To roll forward to end the backup, click To end of backup.

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

9. Select the Alternate log path checkbox and enter log path.

10. Select the Overflow Directory checkbox and enter the workflow directory path.

11. You can proceed the restore without selecting Advance option.

12. If you move the Advanced options toggle key to right, proceed as follows:

    1. Select the Restore logs checkbox, and then specify the time period of the logs to restore.

    2. Select the Restore logs from backup image (use LOGTARGET) checkbox to restore logs from backup image.

    3. From the MediaAgent drop-down list, select a media agent server name.

13. Click Submit.

Out-of-place Restore

Procedure

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

   The Overview page appears.

2. On the Instances tab, in the row for the database instance to restore, click the Action button , and then click Restore.

   Alternatively, click the instance, and from the Recovery points tiles, select Restore option.

   The Backup content page appears.

3. Select the databases to restore, and then click Restore.

   The Restore options dialog box appears.

4. Select Out of place option.

5. From the Restore type drop-down list, you can select the following options:

   1. Cross Instance Restore

   2. Restore to Disk

6. You can proceed the restore without Advanced options.

7. If you move the Advanced options toggle key to right, proceed as follows:

   1. Select the Restore logs checkbox, and then specify the time period of the logs to restore.

   2. Select the Restore logs from backup image (use LOGTARGET) checkbox to restore logs from backup image.

   3. From the MediaAgent drop-down list, select a media agent server name.

8. Click Submit.