Roll-Forward Database -- Overview

Use the roll-forward notebook to apply the changes that are recorded in the logs for a selected database or database partition. Before you can perform roll-forward recovery, the database object must be in the roll-forward pending state, and you must have the logs.

In a single-partition database environment, you can perform the roll-forward operation on a database, table space, or group of table spaces.

In a partitioned database environment, you can perform the roll-forward operation on a database partition, table space partition, or group of table space partitions. The following considerations apply to the partitioned database environment:

Notes:

1. In a partitioned database environment, the database is located across many database server partitions. In this environment, if you are performing point-in-time roll-forward recovery, all database partitions must be rolled forward to ensure that all partitions are at the same level. If you need to restore a single database partition, you can perform roll-forward recovery to the end of the logs to bring it up to the same level as the other database partitions in the database.

2. If, in the partitioned database environment, some database partitions are in the roll-forward pending state, and, on other nodes, some table spaces are in the roll-forward pending state, you must first roll forward the database partitions, then roll forward the table spaces.

Tasks

• Performing roll-forward recovery
• Leaving the database or database partition in the roll-forward pending state
• Rolling forward selected table spaces

Page Fields and controls

• Roll-Forward page
• Table spaces page
• Options page

Controls

• OK
• Cancel

Related information

• Backing up a database or a database partition
• Restoring a database or a database partition
• Restoring to a new database
• Creating a database from a backup