V11 SP8

Performing DB2 HADR Restores

Perform an out-of-place restore for DB2 HADR scenarios.

Note: The destination target database path (Restore Options dialog box, General tab, Target Database path) and the destination storage path (Advanced Restore Options dialog box, Storage Path tab, Paths) must match the values that you used on the source.

Before You Begin

  • Configure the standby database to be in roll-forward pending state.

    On the standby database, edit the /etc/CommVaultRegistry/Galaxy/Instance001/Db2Agent/.properties file and add the following line, substituting the Db2_instance_name parameter with the standby instance name and the STANDBY_DB_NAME parameter with the standby database name.

    Note: The Db2_instance_name parameter must be in lower case and the STANDBY_DB_NAME parameter must be in upper case.

    <Db2_instance_name>_<STANDBY_DB_NAME>_ sDb2RFPendingReqd Y


  1. From the CommCell Browser, navigate to Client Computers > client > DB2 > instance.
  2. Right-click the backup_set, point to All Tasks and then click Browse and Restore.

    The Browse and Restore dialog box appears.

  3. On the Time Range tab, select Latest Backup and click View Content.
  4. Select the databases to restore and click Recover All Selected.

    The Restore Options dialog box appears.

  5. On the Recover Database tab, clear the Recover DB check box.
  6. On the Restore Arguments tab, from the Available Images box, select the backup images to restore.
  7. On the General tab, specify the destination information.
    1. From the Destination Computer list, select the standby database server client.
    2. From the Destination Instance list, select the standby database instance name.
    3. In the Target Database Name box, type the standby database name
    4. In the Target Database path, type the location of the standby database.
    5. Click Advanced.

      The Advanced Restore Options dialog box is displayed.

  8. Specify the storage path if you have an automatic database, or the redirect information if you have a non-automatic database.
    Database Type Procedure
    Automatic Database On the Storage Path tab:
    1. Select the Storage Paths check box.
    2. Click Browse to navigate to the target database paths, or click Add Paths to manually enter them.
    Non-Automatic Databases On the Redirect tab:
    1. Select the Redirect All Table Spaces/Database to check box
    2. Enter the path to redirect the tablespaces and database.
  9. Click OK to close the Advanced Restore Options dialog box.
  10. Click OK to close the Restore Options dialog box.