SAPDBA Database Recovery (SAP Library - Database Administration (Oracle) with SAPDBA)

SAPDBA Database Recovery

Use

SAPDBA supports the recovery of the database after:

physical failures, caused by hardware errors (for example, a hard disk fault)

design failures, caused by software errors (for example, faulty software)

failures caused by user errors

The SAPDBA restore and recovery fucntions are based on use of the backup tools BRBACKUP, BRARCHIVE and BRRESTORE. In a recovery, the backups created with BRBACKUP/BRARCHIVE are restored with BRRESTORE . The operating system logs of BRBACKUP and BRARCHIVE are highly important for the recovery since they contain all the information about the backups (such as directories, volumes and timestamps). You may need to restore these logs from existing backups.

The recovery with SAPDBA function is not based on BRBACKUP or BRARCHIVE logs in database tables, since these tables are not available when you recover the database.

You can recover the database from the SAPDBA Restore/Recovery menu.

Only experienced database administrators working in expert mode ( SAPDBA: Expert Mode) can use the SAPDBA Restore/Recovery function.

Prerequisites

The following prerequisites must be met for a successful recovery of the database:

The BRBACKUP and BRARCHIVE logs must be available. SAPDBA can use the logs to find out where the backups of the data files and the offline redo log files are located.
The backups of the missing or faulty data files made with BRBACKUP or BRARCHIVE must be available.

Other prerequisites may also need to be met, depending on the particular context of the recovery.

Features

SAPDBA offers various functions for recovering the database that are adjusted to particular situations:

Partial Restore and Complete Recovery

Full Restore and Recovery

Reset Database

Restore One Tablespace

Restore Individual File(s)

	Restore/Recovery
a	- Partial restore and complete recovery
b	- Full restore and recovery
c	- Reset database
d	- Restore one tablespace
e	- Restore individual file(s)
q	- Return

Familiarize yourself with the differences between these functions before you start the recovery of the database. If you choose a function that does not suit your situation, you may not be able to recover the database, or you may lengthen its downtime.