SnapProtect - Restore - DB2 MultiNode

As restoring your SnapProtect backup data is very crucial, it is recommended that you perform a restore operation immediately after your first full backup to understand the process. The following section explain the steps for restoring a backup:

  1. From the CommCell Browser, navigate to Client Computers | <DB2 MultiNode Client> | <Instance>. Right-click the <Backup Set>, point to All Tasks, and then click Browse and Restore.
  2. On the Restore Options dialog, click View Content.
  3. In the right pane of the Browse window, click the <Backup Set> and select all the entities. Click Recover All Selected.
  4. On the Restore Options dialog, check the Restore Data check box. Navigate to the Recover Database tab, check the Recover DB check box and click OK.
  5. This restore operation always picks the latest backup image. If latest backup image is SNAP, then it restores from a SNAP Backup Image. Otherwise, it picks the regular backup image. You can also select To a Point in Time and choose a SNAP Backup Image date and Time, which can be obtained from the Backup History.

  6. You can monitor the progress of the restore job in the Job Controller.
  7. Once the restore job has completed, navigate to Client Computers | <DB2 MultiNode Client> | <Instance>. Right-click the <Backup Set>, point to All Tasks, and then click Restore History.
  8. On the Restore History Filter dialog, click OK.
  9. You can right-click the job and view the following details:
    • View Restore Items

      You can view them as Successful, Failed, Skipped or All.

    • View Job Details
    • View Events of the restore job
    • View Log files of the restore job

Once the database is restored, verify that the restored database and log files are available in the original location.

Configuring the Copy Precedence for performing an SnapProtect restore operation:

From the CommCell Console, navigate to Policies | Storage Policies.

Right-click the <storage policy> and click Properties.

Click the Copy Precedence tab.

By default, the snapshot copy is set to 1 and is used for the restore operation. You can also use a different copy for performing the operation. For the copy that you want to use, set the copy precedence as 1.

Click OK.

Congratulations - You have successfully completed your first backup and restore.

If you want to further explore this Agent's features read the Advanced sections of this documentation.