SAPDBA: Check (and Repair) Database 

Different types of errors can interfere with the operation of an ORACLE database recovery. See Types of Database Errors.

The task of the SAPDBA recovery function is to remedy certain media and user errors. When such an error occurs, it usually involves the loss of database files, which can contain many different types of objects: ORACLE Dictionary segments, temporary segments, rollback segments, or user segments (tables and indexes).

SAPDBA supports restoring the database after the loss of the following files:

The menu item Check (and repair) database only enables recovery of the database up to the current time. If you want to restore an older version of the database or perform a point in time recovery, please use the Restore/Recovery function (see SAPDBA: Restore/Recovery).

Also read the corresponding ORACLE documentation.

Requirements

Recovery Options

Automatic Recovery

Recovery Procedure

Checking the Database Files

Finding the Backup Files

Restoring the Backup Files

Changing the Restore Parameters

Finding the Archived Redo Logs

Restoring Archived Redo Logs

Database Recovery