Using the Recovery Report (Oracle)
Use
The recovery report provides important information for use in the event of an Oracle database failure requiring database recovery. For more information, see Display of Backup Logs and Status (Oracle).
Procedure
...
1. Choose Administration ® CCMS ® DB Administration ® Backup logs. Alternatively, call transaction DB12.
2. Choose Recovery report.
The system display information about the last successful backup, such as backup type and tape names. This tells you which backup to use for a recovery. The report also checks whether the required redo log files are available (backed up on tape or in the archiving directory). Therefore, you know which files to restore in the event of a recovery.
3. Check the recovery report regularly to detect possible gaps in your backups:
¡ Missing redo log files mean that if an error occurs, the database can no longer be restored to the current point in time. In this case, perform a complete database backup as soon as possible.
¡ If the list of redo log files is too long, a recovery to the current point in time might take too long. In this case, perform a complete database backup as soon as possible.
For more information, see:
·
Restore and Recovery
with BR*Tools
·
Database Recovery with
SQLPLUS