Restoring the Database Instance

Purpose

After a breakdown or errors, you can restore a database instance or revert it to an earlier state by importing data backups and log backups from data carriers.

Prerequisites

?     You have the data and log backups for the database instance. See Backing Up Data und Backing Up Log Entries.

?     Only for Microsoft Windows: If you want to restore the database instance using backups from data carriers on a remote computer, carry out the steps described in Backing Up and Restoring Data with Remote Computers.

?     Initially, the database system attempts to import redo log entries still present in the log area when it does the restoring. To prevent this and force the deletion of all redo log entries in the log area, initialize the log area before the restore.

See Database Manager GUI, Restoring After Initializing a Database Instance and Database Manager CLI, db_activate RECOVER.

Process Flow

You use the Database Manager for restoring.

...

       1.      You import a complete data backup.

See

0     Database Manager GUI, Restoring

0     Database Manager CLI, Backing Up and Restoring Database Instances

       2.      If necessary, import incremental data backups and log backups as well.

       3.      If necessary, restore any damaged indexes.

See

0     Database Manager GUI, Restoring Indexes After Database Restore

0     Database Manager CLI, sql_recreateindex

0     Database Administration in CCMS: MaxDB, Index Analysis

0     Database Administration in CCMS: SAP liveCache Technology, Bad Indexes

See also:

Backing Up and Restoring

Example: Backing Up and Restoring

Database Administration Tutorial, Restoring the Database Instance