You can recover the database by reapplying the log files containing transactions that are not part of any database backup image. The roll-forward capability is applied after a database or table space image is restored.
Whenever log files are restored with the roll-forward capability, DB2 searches for the following target restore paths:
-
DB2's own directory path for log file restores
-
The retrieve Path that was specified during the installation of the DB2 Agent
-
The archive Path that was specified during the installation of the DB2 Agent
-
The path identified (if any) in the Overflow Directory field within the Roll-Forward.
If it is unable to find any of these paths, the appropriate error is reported in a file within the DB2 Audit Error Path that was specified during installation of the DB2 Agent.
Procedure
-
From the CommCell Browser, expand Client Computers > client > DB2 MultiNode >instance.
-
Right-click the backup_set, point to All Tasks and select Browse and Restore.
-
From the Browse window, select the tables to restore and click Recover All Selected.
The Restore Options dialog box is displayed.
-
On the Recover Database tab, clear the Recover DB check box.
-
Click Advanced.
The Advanced Restore Options dialog box is displayed.
-
On the Roll-Forward tab, do the following:
-
Select the Roll-forward (Reapply the Logs) check box.
-
Select the rollforward options that you want to use.
Option
Steps
To the End of the logs
-
Select To the End of the logs.
-
If the client is in a different time zone from the CommServe computer, select the destination time zone from the Time Zone list.
To a Point in Time
-
Select To a Point in Time.
-
Select the date and time to reapply the logs to.
-
If the client is in a different time zone from the CommServe computer, select the destination time zone from the Time Zone list.
To End of Backup
Select To End of Backup.
-
-
To leave the database in a pending state until all the logs are applied, select the Leave in Roll-forward Pending State check box.
-
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 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.
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.
-
Click OK.
-
-
Click OK.