Entering content frameProcedure documentation Recovering the Database Automatically Locate the document in its SAP Library structure

Use

You can recover the database automatically when using SAPDBA to perform a partial restore and complete recovery of your Oracle database. If a data file is lost or damaged, this procedure automatically selects the last valid backup of the relevant data file and the appropriate redo logs.

Caution

Automatic recovery does not support a recovery with incremental backups.

Recommendation

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

Procedure

  1. Choose Restore/recovery ® Partial restore and complete recovery ® Automatic Recovery in SAPDBA to recover the database automatically.

    2. After each step, SAPDBA asks whether you want to continue the recovery.

  2. Respond to the SAPDBA prompts.
  3. If you use backups to tape for the recovery, mount the tapes with the correct labels when SAPDBA prompts you.

Note

If the automatic recovery terminates, the SAPDBA menu Partial Restore and Complete Recovery appears again. The status display tells you which steps ran successfully (status finished). You must perform any unsuccessful steps (that is, with Status set to not finished) manually after you have solved the problem that led to the termination.

Result

When the recovery has finished, SAPDBA opens the database again and sets the Status of Recover database to finished.

Leaving content frame