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 ADMIN mode.

1. Choose Instance ® Recovery ® Database.
2. Select the option Restore a specified backup from history.
   In this screen, you can specify the time by which the restoration should be completed by selecting the option Restore by a specific time. The system default is the current time. If you do not change the time proposed by the system, the backups are restored completely and with all the changes they contain.
3. Choose RecoveryDatabase ® Next Step.
   The system displays the backup history of complete data backups .
4. Select the complete data backup you want.
   Choose RecoveryDatabase ® Next Step.
   The system displays the selected backup and the associated page 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 RecoveryDatabase ® Next Step. The system tells you when insert the backup medium specified.
6. Choose RecoveryDatabase ® 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 GUI prompts you to confirm each one.
   If you then need to make log backups, the Database Manager GUI prompts you to confirm that you want to restore all displayed backups.

Once the restore has finished, the database instance is in ONLINE mode.