You can use the Recovery Wizard to guide you through the entire process of restoring a database instance.
You can start the Recovery Wizard on a Windows-based server to restore data on either a local or remote server.
The Recovery Wizard always proposes the quickest procedure for recovering lost data. Complete data backups are read first and if necessary, incremental data backups and log backups are then read.
To make sure that the data is recovered as quickly as possible, data backups can be read from multiple data carriers at the same time. The number of media in a group of parallel data carriers does not have to be the same as the number of parallel data carriers used for the original backup. Even a backup made to a single data carrier with succeeding data carriers can be restored in parallel. You can reduce the restore times considerably by using up to 32 tape drives.
Log backups cannot be restored in parallel.
In the Database Manager GUI, choose Instance ® Recovery ® Recovery... .
Choose Next to start each of the required recovery steps.
1. You can recover the data of a database instance either locally, or on a remote computer.
Choose the desired database instance or enter the following information directly:
Database Server: Name of the computer on which the database instance is located
Database Name: Database name
User Name: Name of the Database Manager operator (DBM operator)
Password: Password of the Database Manager operator
2. You can switch the database instance to the operational state of your choice. When you recover data, you require the ADMIN operational state.
3. Choose a recovery type:
Restore last backup: Restoring from the Last Backup in the Backup History
Restore a specified backup from history: Restoring a Backup from the Backup History
Restore a medium: Restoring Without a Backup History
Continue restoring increment/log: This setting is displayed if you need to continue an interrupted restore.
4. Restore database until a specified time: If you only want to restore the database up to a specific time, select this setting, and enter a time.
5. The recovery strategy is displayed. The system prompts you to insert the required data carrier.
6. Start the recovery.
7. Close the Recovery Wizard.
The database instance has been recovered to the state you specified.
If the recovery procedure provided by the Recovery Wizard does not produce the required results, you might have to use one of the procedures for restoring after initializing a database instance.
Concepts of the Database System, Restoring the Database Instance