Resetting the Database
Select Full restore (incl. redo logs and control files).
This option is intended without recovery and must be based on offline backups because only these have a consistent state and contain all the objects, including the online redo logs.
SAPDBA calls the SAP utility BRRESTORE. BRRESTORE restores all the data files, the control file, and the online redo logs from a valid (completed with return code 0 or 1) offline backup of the entire database. The control file and the redo log files are copied to the appropriate places in the system, so that the original mirrors of these files are available again. Depending on the restore type you select, you can then subsequently recover the database or not.
Restore and open the database. No recovery is possible. The database now has the status from the time of the offline backup from which it was loaded. Also see
Restore the database. The database is then mounted, and you can perform a recovery using SAPDBA.
The SQLPLUS command for recovering the data is as follows (be sure to read the corresponding Oracle documentation):
SQLPLUS> recover database [until cancel] [using backup controlfile];
This SAPDBA function will probably be seldom used since normally the SAPDBA functionality for restore and recovery of the database can be used.
The log file written by SAPDBA is contained in file
<SAPDATA_HOME>/sapreorg/<timestamp>.rst. To access the file, select the SAPDBA function Show/Cleanup ® Show log files/profiles.See SAPDBA Log Files and Their Contents.