Performing roll-forward recovery

Use the Roll-Forward page of the Restore Database to New notebook to perform roll-forward recovery on the database when you restore the backup image to a new database.

Fields and controls

Authorities and privileges

To perform roll-forward recovery:

1. Open the Restore to New Database notebook.

2. On the Backup Image page, specify the backup image that you want to use to restore the database:

   • To use one of the backup images that are displayed, click on Select an entry from the list, then select the backup image that you want to use.

     If you have already created a backup image of the database from this administrative client, Select an entry from the list is preselected because the recovery history file for the database indicates that a backup image is available.

     If you know that the media type that is displayed for the backup image is not correct, then use the fields that are displayed under Change the media information if necessary to specify the correct media type for the backup image.

   • To use a backup image that is not displayed, click on Manually enter the backup image information. Use the fields that are displayed with Manually enter the backup information to specify the backup image that you want to use.

     If you have not already created a backup image of the database from this administrative client, Manually enter the backup image information is preselected because the recovery history file for the database does not contain any backup history for the database.

3. On the Description page:

   1. Type the name of the database that you want to create in the New database name field.

   2. Type the drive on which the database is to reside in the Default drive field. (For UNIX-based systems, this field is called Default directory.)

   3. Type an alias for the database in the Alias field.

   4. Type a comment for the database in the Comment field.

4. On the Roll-Forward page, click on the Roll-Forward check box to indicate that you want to perform roll-forward recovery, then specify the type of roll-forward recovery that you want:

   • End-of-log recovery. All changes recorded in the logs are reapplied to the database.

   • Point-in-time recovery. Changes in the logs up to and including the date and time indicated are reapplied to the database.

5. On the Roll-Forward page, clear the Leave in roll-forward pending state check box. This makes the database usable immediately after the restore operation. (By default, this check box is on).

6. Click on OK to create the database.

Related information

• Restore Database to New -- Overview