Restoring a DB2 MultiNode Database from a Point-in-Time

You can restore a database from a point-in-time. This is useful if you want to restore certain configurations/contents in the database that are not reflected in the latest backup. For example, you can use this option to restore an IntelliSnap backup if your latest backup was a traditional backup.

The Commvault software waits 2 minutes for the IntelliSnap operation to complete. If the job does not complete when this time expires, the Commvault software marks the job as failed and brings the database out of the quiesced state. You can set this to a higher value to allow more time for the job to complete. For more information, see Configuring the time the Commvault Software Waits for the IntelliSnap Operation.

Procedure

1. From the CommCell Browser, expand Client Computers > client > DB2 MultiNode > instance.

2. Right-click the backup_set, point to All Tasks,and then click Browse and Restore.

   The Browse and Restore dialog box appears.

3. Select Latest Backup, and then click Time Range.

4. Select the Absolute Time option, and then enter a date and a time in End Time.

   The default time zone is the client time zone. For all other agents, the default time zone is the CommServe computer time zone.

5. On the Browse view, select the data to restore in the right pane, and then click Recover All Selected.

   The Restore Options dialog box appears.

6. On the Recover Database tab, select the following options:

   1. Select the Recover DB check box.

   2. Select the Point-in-Time option, and then enter the date and time.

7. Click Advanced.

   The Advanced Restore Options dialog box appears.

8. On the Roll-Forward tab, select the Roll-forward (Reapply the logs) check box and select To a Point in Time. Then, enter the date and time to reapply the logs for the IntelliSnap backup to restore.

   Note

   Make sure to select a date and time that is more recent than the date and time selected on the Recover Database tab.

9. Optional: Restore from a copy precedence. On the Copy Precedence tab, select the Restore from copy precedence check box. From Copy Precedence list, select the number.

10. Click OK.

11. Click OK.