Recovering the Database (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Recovering the Database

Use

You recover the database when using SAPDBA to perform a partial restore and complete recovery of your Oracle database.

Prerequisites

You have restored the offline redo log files.

You have configured and started SAPDBA. Refer to Getting Started with SAPDBA.

Procedure

Choose Restore/recovery ® Partial restore and complete recovery ® Recover database in SAPDBA to recover the database.

SAPDBA tells you:

When the recovery started
Whether the database can be recovered in one step
Which scripts were created to start the recovery

If there was not enough disk space available when you restored the offline redo logs, they must be loaded later. SAPDBA automatically deletes the redo logs that have been retrieved from tape and processed in order to make space available. The next redo logs are then restored and the recovery process is continued. You can monitor this process by watching the screen displays.

Result

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

The partial restore and complete recovery is now complete.

Note

After the recovery, you can use the SAPDBA function Show/Cleanup ® Show log files/profiles to check the SAPDBA log file <timestamp>.rcv in directory <SAPDATA_HOME>/sapreorg. For more information, see SAPDBA Log Files and Their Contents.