Restoring a Backup from the Backup History 

Prerequisites

The log files of the Database Manager dbm.knl and dbm.mdf in the run directory of the database instance have not been corrupted, and the backup history is therefore complete. If you are performing a restore using external backup tools, the log file dbm.ebf must also have remained uncorrupted.

The database instance is in the ADMIN operational state.

Procedure

...

       1.      Choose Instance ® Recovery ® Database.

       2.      Select the option
Restore a specified backup from history.
If you select the option
Restore until a specific time
on the same screen, you can define a time to which the system should perform the restore. The system default is the current time. If you do not change this system default, the backups are restored completely and with all the changes they contain.

       3.      Choose Database ® Next Step.
The system displays the backup history of complete data backups.

       4.      Select the desired complete data backup.
Choose Database ® Next Step.
The system displays the selected complete data backup and the associated incremental data and log backups. You can deselect in the list any incremental data backups that are not available or that have been damaged. The Database Manager GUI then shows the appropriate log backups in place of the page backups.

       5.      Choose Database ® Next Step. The system prompts you to insert the specified backup medium.

       6.      Choose Database ® Start.
If you are performing a restore using external backup tools, the external backup IDs are displayed at this point.
The complete data backup is restored.
If you then need to restore any incremental data backups, the Database Manager prompts you to confirm each one.
If you then need to make log backups, the Database Manager prompts you to confirm that you want to restore all displayed backups.

Once the restore  is complete, the database instance is in the ONLINE operational state.

When the consecutive backups are restored, the Database Manager GUI prompts you to insert the next backup medium each time, unless you are restoring from an automatic tape loader.

You can if you wish stop the restore process and resume it later on (see Continuing an Interrupted Restore).