Restoring After Initializing a Database Instance

When you restore a database instance, you may need to initialize the database instance to delete the log entries in the log area. You can then restore the required backups to recover the database instance to a specified state.

There are two procedures for restoring after initializing a database instance. The procedure you choose depends on whether you want to change the database and volume settings before you restore the database instance.

You need to carry out a restore operation after initializing a database instance in the following situations:

·        You want to recover a deleted database instance from a backup.

·        You want to use backups from a point in time before you made a recovery with an UNTIL time. (For example, you want to repeat a recovery with an UNTIL time so that you can specify a different time.)

Any backups made before the interruption of the backup history can only be restored with the procedure described here.

This procedure involves the initialization of the database instance. This procedure is very time consuming. For this reason, you should only use it if absolutely necessary.

Procedure

There are two ways of initializing and then restoring a database instance.

·        Restoring after initializing a database instance without the option of changing the database parameters and volume configuration.

·        Restoring after initializing a database instance with the option of changing the database parameters and volume configuration.

Restoring after initializing a database instance without the option of changing the database parameters and volume configuration

Prerequisites

The database instance is in the ADMIN operational state.

Procedure

...

       1.      Choose Instance ® Recovery ® Recovery with Initialization.

       2.      If necessary, transfer the database instance to the ADMIN operational state.

       3.      The Recovery Wizard always proposes the quickest procedure for recovering lost data. You may need to choose a procedure that is adapted to your situation.

       4.      The wizard guides you through the entire process of recovering the database instance. The subsequent recovery steps are described under the relevant recovery procedure.

Restoring after initializing a database instance with the option of changing the database parameters and volume configuration

Prerequisites

The log files dbm.knl and dbm.mdf exist and are not damaged. This means that the backup history is complete. The database instance is in the OFFLINE operational state.

Procedure

       1.      Initialize the database instance . All data from the old version is then lost.

       2.      During the initialization process, choose Create instance for recovery (not Create and start instance), since this is the only option that lets you recover the data.
Once it has been created, the database instance is in the ADMIN operational state. The Database Manager opens the Recovery Wizard automatically.

       3.      The Recovery Wizard always proposes the quickest procedure for recovering lost data. You may need to choose a procedure that is adapted to your situation.

       4.      The wizard guides you through the entire process of recovering the database instance. The subsequent recovery steps are described under the relevant recovery procedure.