Using the Recovery Report: Oracle (SAP Library - Computing Center Management System (BC-CCM))

Using the Recovery Report: Oracle

Choose Recovery report in transaction DB12 (see Display Backup Logs and Status: Oracle).

The system display information about the last successful backup (kind of backup, tape names); this tells you which backup you could use if a database error occurs making a recovery necessary. The report also checks whether the required redo log files are available (archived on tape or in the archiving directory). You thus know which files to restore in the event of a recovery.

Check the recovery report regularly in order to detect possible gaps in your backup mode. Note the following:

Missing redo log files mean that if an error occurs, the database can no longer be restored to the current time point. In this case, you should perform a full database backup as soon as possible.

If the list of redo log files is too long, a recovery to the current time point may take a long time. In this case, you should perform a full database backup as soon as possible.

For more information, see:

SAPDBA Database Recovery

SQLDBA Database Recovery

Backup mode