Entering content frameProcess documentation Partial Restore and Complete Recovery with SAPDBA Locate the document in its SAP Library structure

Purpose

This section tells you how to restore and recover your Oracle database with SADPBA. This process normally corrects media errors, such as a disk crash. When such an error occurs, it usually involves the loss of database files, which can contain many different types of objects, such as Oracle Dictionary segments, temporary segments, rollback segments, or user segments (that is, tables and indexes).

For more information on the concepts behind partial restore and complete recovery, see Partial Restore and Complete Recovery.

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

Note

The SAPDBA option Partial Restore and Complete Recovery only enables recovery of the database up to the current time.

For more information if you want to restore an older version of the database or perform a point-in-time recovery, see Performing a Full Restore and Point-In-Time Recovery with SAPDBA.

Prerequisites

You have replaced the defective disk or otherwise corrected the initial problem.

You have also recreated the damaged file system or raw device at operating system level.

Process Flow

  1. If required, you change the options for restore and recovery.
  2. You check the database.
  3. You find the backup files.
  4. You restore the backup files.
  5. If relevant, you find the incremental backups.
  6. If relevant, you restore the incremental backups.
  7. You find the offline redo logs.
  8. You restore the offline redo logs.
  9. You recover the database.

Note

If preferred, you can perform automatic recovery. This automatically performs all the steps listed above. You do not have so much control with this method.

We normally recommend you to perform the steps individually, so that you can more closely monitor the restore and recovery, and intervene if necessary.

For more information, see the Oracle documentation.

Leaving content frame