Database Restore and Recovery with SAPDBA (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Database Restore and Recovery with SAPDBA

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 functions are based on the backup tools BRBACKUP, BRARCHIVE, and BRRESTORE. In a recovery, the backups created with BRBACKUP and BRARCHIVE are restored with BRRESTORE. The operating system logs of BRBACKUP and BRARCHIVE are very important for the recovery, because they contain all the information about the backups, such as directories, volumes, and timestamps. You might need to restore these logs from existing backups.

Note

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

This graphic is explained in the accompanying text

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

Note

For more information on the concepts behind restore and recovery, see Approach to Restore and Recovery.

Prerequisites

For a successful recovery of the database, you must check that:

The BRBACKUP and BRARCHIVE logs are 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 are available.

Note

You might also need to be meet other prerequisites, depending on the context of the recovery.

Features

SAPDBA offers the following for recovering the database in particular situations:

Partial Restore and Complete Recovery with SAPDBA

Performing a Full Restore and Point-in-Time Recovery with SAPDBA

Reset Database

Restore One Tablespace

Restore Individual File(s)

Note

Familiarize yourself with the differences between these functions before you start the recovery of the database. If you choose the wrong function, you might not be able to recover the database, or you might increase downtime.