Performing a DB2 Application-Free Restore

You can restore the backup images of data and logs or multiple backup jobs at the same time directly to a location on a disk without the intervention of the DB2 application. This is useful for restoring multiplexed data on the same media. The data from different backup jobs are passed back to the client so that all of the interleaved backup jobs can be restored in parallel. You can restore the data associated with a specific backup job, such as a full job, in parallel streams. You can also submit multiple restore jobs from full and incremental backups. Later, you can restore the DB2 database from the DB2 command line using the backup image on disk without using the load Commvault library.

Procedure

1. From the Command Center navigation pane, go to Protect > Databases.

   The Overview page appears.

2. Click the Instances tab.

   The Instances page appears.

3. Click the action button for the instance that you want to restore, and then click Restore.

   The Restore dialog box appears.

4. Select the database to restore, then click Select Content.

   The Backup content page appears.

5. Select the backup content, then click Restore.

   The Restore options dialog box appears.

6. In the Out of place section, enter the following details:

   1. From the Restore type list, select Restore to disk.

   2. From the Destination client* list, select the client where you want to restore the DB2 backup image.

   3. Using the calender, you can select a duration for which you want the system to show the jobs.

   4. From the Job(s) list, select the backup jobs you want to back up.

   5. In the Destination folder, enter the path specify the location on the disk to restore the application data.

7. Move the Impersonate User toggle key to right if you want to use a different account with the required privileges. In the User Name box, type the user name. The user should have the necessary privileges to restore the application data.

8. Click Submit.

   The backup images will be restored to the disk location specified in the Restore Options for All Selected Items dialog box.

   The DB2 agent will create a new folder with the current restore job ID on the destination directory which has been specified during the restore operation. This folder contains the backup images and DB2 archive logs.

   Log Files

   restore_destination_path/restore_job_id/LOGS/DB2/Node Number/Chain number/Log_files

   Data

   restore_destination_path/restore_job_id/Backup_images

   You can run a disk restore using the backup image at the following location:

   db2 restore database db_name taken at $[backup_image_timestamp]

   You can also use the following command to restore the backup image.

   db2 restore database db_name from restore_destination_path/restore_job_id taken at backup_image_timestamp

   You can recover the database by reapplying the log files (roll forward). Make sure that the Commvault services are running on this client.

   db2 rollforward database db_name to end of logs and stop overflow log path "(restore_destination_path/Restore_Jobid)"

If you are trying to restore one cycle of backup images which includes full, incremental, and deltas, you should use the last backup image timestamp (incremental or delta) with the incremental automatic key word to restore the database:

db2 restore database db_name incremental automatic from restore_destination_path/restore_job_id taken at late_incremental or delta_backup_image_timestamp

The multi-streams backup job will have multiple backup images as a number of streams after restoring to disk.