Performing roll-forward recovery

Use the Roll-Forward page of the roll-forward notebook to perform roll-forward recovery on the table space or table space partition.

Note:

Before you can do forward recovery, the table space or table space partition must already be in the roll-forward pending state, and you must have the database logs.

Typically, table spaces exist in groups. If this is how your database is structured, you should use the Roll-Forward Database notebook to roll-forward the set of related table spaces or table space partitions.

Fields and controls

Authorities and privileges

To perform roll-forward recovery on the table space or table space partition:

1. Open the roll-forward notebook:
   • Open the Roll-Forward Table Space notebook.
   • Open the Roll-Forward Table Space Partition notebook.
2. On the Roll-Forward page, specify the type of roll-forward recovery that you want:
   • Roll-Forward to the end of the logs. All changes recorded in the logs are reapplied to the table space or table space partition.

     Note:

     If you need to restore a table space partition on a specific database partition you can perform roll-forward recovery on it to the end of the logs to bring it up to the same level as the table space partitions on the other nodes.

   • Roll-Forward to a point in time. Changes in the logs up to and including the date and time indicated are reapplied to the table space or table space partition.

     Note:

     In a partitioned database environment, if you want to roll forward a table space to a point in time, you must restore the table space partition at each database partition that contains a portion of the table space, and roll forward each table space partition individually to the same point in time. This ensures that the table space is consistent at each node.

3. Clear the Leave in roll-forward pending state check box. This makes the table space usable immediately after the roll-forward operation. (By default, this check box is on).
4. On the Options page, select one of the Process while radio buttons, either Online or Offline. Offline is the default.
5. Click on OK to begin the roll-forward operation.

Related information

• Roll-Forward Table Space -- Overview