Restoring Individual Tablespaces (Partial DB)

You can restore individual tablespaces.

By default, you can restore an entire database in Offline mode (default option - Offline restore). However, you need to perform an online restore to restore individual tablespaces. When you select individual tablespaces, either from browse or from the DB2 Restore Options dialog box, the restore is automatically switched to Online Restore.

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 Latest Backup and click View Content.

4. Select the database and click Recover All Selected.

   The Restore Options dialog box is displayed.

5. On the General tab, do the following:

   1. Select the Restore Data check box.

   2. Select the Database Subset option.

   3. Select the tablespaces from the Latest Database View list.

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

7. On the Restore Arguments tab, view that the restore option is automatically switched to Online Restore for individual tablespaces/partial database.

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