Restoring an Existing Database Instance 

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.

The database instance is in the ADMIN operational state.

Procedure

Select Instance ® Install to launch the Database Wizard. This Database Wizard guides you through the entire procedure for restoring an existing database instance.

1.       Specify under which name the existing database instance is registered in the Database Manager GUI.

2.       Choose Next.
The Database Manager GUI displays a message saying that a database instance with this name already exists.

       1.      Choose Reinstall. This particular database instance is then restored. The Database Manager uses the database parameters of the old version of the database instance as the default values for the new version. All data from the old version is lost.

       2.      Enter the first Database Manager operator and the first database user (SYSDBA) for this database instance, enter their passwords, and choose Next.
The Database Manager GUI provides the Use current parameters option for creating the initial parameter file.

       3.      Choose Next.
The system automatically proposes the parameter values from the old version of the database instance. You can adjust these values to your requirements. Select the required parameter and then choose Edit.
It now appears in the bottom part of the window. Next to the parameter you will see an explanation of what the parameter does and, in some cases, how it is calculated.

Enter the new value for the parameter in the New Value field.
Save your entries.
The new value appears in the New Value column. It is stored in the internal data structures and becomes effective once the database instance is started/restarted.

       4.      Choose Next.
When you exit the input screen, the parameters are checked following the rules stored on the DBM Server. You may be asked to make and confirm changes before you can leave the input screen.
For the log volumes and the data volumes, the system automatically proposes the configuration of the old version of the database instance. You can adjust these values to your requirements. Bear in mind the parameters set in the previous step. Select a volume and then choose Edit. Enter the size and ID or the absolute path of the volume and confirm your entries. Repeat this process for each volume.

       5.      Choose Next and Restore instance.

3.       Choose Install.
A new database instance is installed with the parameters set in step 5 using a complete data backup.
The system prompts you to give the database instance a new registration name in the Database Manager GUI. This name must be unique within the Database Manager.

4.       Confirm your entries.

5.       Select Close to close the Database Wizard.
This takes you back to the initial screen of the Database Manager GUI (Screen).

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

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