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 backup media.

Prerequisites

·        You have backed up data.

·        You have backed up log entries.

Process Flow

You use the Database Manager for restoring.

...

       1.      You import a complete data backup. To reduce the restore time, you can import data backups from a group of parallel backup media.

See:

¡        Database Manager GUI, Restoring

¡        Database Manager CLI, Backing Up and Restoring Database Instances

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

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

       3.      If necessary, restore any damaged indexes. See:

¡        Database Manager GUI, Restoring Indexes After Database Restore

¡        Database Manager CLI, Restoring a Damaged Index

¡        Database Administration in CCMS: MaxDB, Index Analysis

¡        Database Administration in CCMS: SAP liveCache, Bad Indexes

Example

Example: Backing Up and Restoring

Backing Up and Restoring