You can browse backed up data to run an out-of-place DB2 database restore operation. You can redirect table spaces and storage groups during the database restore operation.
Procedure
-
From the navigation pane, go to Protect > Databases.
The Instances page appears.
-
Click the instance.
The instance page appears.
-
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.
-
Select the data to restore, and then click Restore.
The Restore options dialog box appears.
-
On the Out of place tab, select the destination host and the destination instance.
-
From the Restore Type list, select a type of restore.
-
From the Destination server list, select a destination server where you want to restore.
-
From the Destination instance list, select a destination instance.
-
In the Target database name box, enter a name for the restored database.
-
To define the path for the target database, in the Target database path box, enter the full path to the location of the target database.
-
Select Restore database checkbox to restore the database.
-
To redirect table spaces for a non-automatic database or to redirect storage groups for an automatic or mixed database, click Redirect.
The Redirect path options dialog box appears.
-
Complete the steps for the type of redirect operation you want:
-
To redirect all table spaces, on the Tablespaces tab click Redirect all tablespaces, and then in the box enter the full path for the location of the table spaces.
-
To redirect only some table spaces, on the Tablespaces tab click Redirect individual tablespaces. To redirect a table space, expand the table space name and in the Datafiles text box change the path to the new location for the table space.
-
To redirect storage groups, on the Storage groups tab expand a storage group name, and then in the Paths text boxes change the paths to the new locations for the storage group.
-
-
Click Save.
-
-
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.
-
To end of backup, select 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.
-
-
To reapply and restore the logs to an alternate log path, select the Alternate Log Path check box, and then enter the name of the directory in the box.
If you enter only the alternate log path, the Commvault software restores all the logs to this location and the location becomes the NEWLOGPATH in the destination DB2 database.
Note
If you set both the overflow directory and the alternate log path, the Commvault software restores the logs to the overflow directory and sets the alternate log path as the NEWLOGPATH parameter in the destination DB2 database.
-
To restore the logs that are in the overflow directory, in the Overflow Directory box, enter the name of the directory.
If you enter only the overflow directory path, the Commvault software restores all the logs to this location and does not set the OVERFLOWLOGPATH parameter in the database that you restored.
-
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.
-
Click Submit.