SAPDBA: Check (and Repair) Database

Different types of errors can interfere with the operation of an ORACLE database recovery.

The task of the SAPDBA recovery function is to remedy certain media and user errors. When such an error occurs, it usually involves the loss of database files, which can contain many different types of objects: ORACLE Dictionary segments, temporary segments, rollback segments, or user segments (tables and indexes).

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

  • Data files of the SAP tablespaces (PSAPD/I)
  • Files of the system tablespace (SYSTEM)
  • Files of the rollback tablespace (PSAPROLL)
  • Files of the temporary tablespace (PSAPTEMP)
The menu item Check (and repair) database only enables recovery of the database up to the current time. If you want to restore an older version of the database or perform a point in time recovery, please use the Restore/Recovery function (

No comments:

topics