Restoring the Last Complete Data Backup 

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 last backup.
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 the time proposed by the system, the backups are restored completely and with all the changes they contain.

       3.      Choose Database ® Next Step.
The system displays the last complete data backup in accordance with the time you specified earlier; that is including any incremental data backups and log backups if required. 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.

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

       5.      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 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.
Choose Database ® Restart to restart the database instance.

When the consecutive backups are restored, the Database Manager 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).