> CommCell Console > Backup and Restore Agents > Databases > DB2 MultiNode > DB2 MultiNode Agent CommCell Console Restore Operations

Restoring DB2 MultiNode Logs

You can restore log files separately or with the database that you want to restore.

By default, the software restores the log files to the DB2 retrieve path that you specified when you installed the DB2 Agent.

Use archive log restores in the following cases:

  • When there is a database failure and you need to recover the database to the recent state, you restore all the logs along with the database.

  • When the logs from a specific time range were lost due to a hard disk corruption. Perform a point-in-time restore.

  • When you need to restore specific log files that are missing in the database. You can identify the logs by using the log serial numbers or time ranges.

Note

For both DB2 DPF and DB2 pureScale configurations, all nodes must be available in order for a log restore to succeed.

Procedure

  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 General tab, clear the Restore Data check box, and then click Advanced.

    The Advanced Restore Options dialog box appears.

  7. On the Roll-Forward tab, select the Roll-forward (Reapply the Logs) check box.

  8. On the Log Files tab, select the Restore Log Files check box, and then select the restore log option.

    Restore all logs

    Select the All Log Files option.

    Restore logs to a point-in-time

    Select By Point in Time and enter the Start and End time in the boxes.

    Restore by specifying a serial number

    Select the By Log Serial Number option.

    Check the Start or End check boxes and enter the serial numbers.

    The following are the rules for specifying the serial number.

    • The end serial number must be greater than or equal to the start serial number

    • The start and the end serial number cannot be 0

    • The range of serial numbers restore can be from one or more backup jobs or from a part of a job and from one or more cycles

    • When you specify only the start sequence number, logs starting from that sequence number to the current sequence number are restored

  9. Click OK to close the Advanced Restore Options dialog box.

  10. Click OK to close the Restore Options dialog box and start the restore.

Page contents

×

Loading...