Restoring a DB2 Non-recoverable Database with an Offline Backup

Updated

You can restore a non-recoverable DB2 database.

Procedure

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

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

  3. On the Browse and Restore dialog box, select Time Range and Absolute Time with the Start Time and End Time and then click View Content.

  4. Select the databases and click Recover All Selected.

    The Restore Options dialog box appears.

  5. On the General tab, select the Restore Data check box.

  6. To specify the items to restore, select Entire Database.

  7. On the Recover Database tab, clear the Recover DB check box.

  8. On the Restore Arguments tab, in the Backup Images area, choose an option for selecting backup images:

    • To let the Commvault software select the latest backup images or the latest point-in-time backup images, based on the choice you made on the Time Range tab on the Browse and Restore dialog box, choose Auto Pick Backup Images.

    • To manually select a cycle of backup images, choose Select Backup Images. Select the images from the Available Images box, and then click > to move the selected images to the Selection box.

  9. Click Advanced.

    The Advanced Restore Options dialog box appears.

  10. On the Roll-Forward tab, clear the Roll-forward (Reapply the logs) check box, and then click OK.

  11. Click OK.

  12. Click OK.