Show TOC

Displaying the Recovery Report (Oracle)Locate this document in the navigation structure

Context

The recovery report provides important information for use in the event of an Oracle database failure requiring database recovery. It displays the backups and redo logs currently required to recover the database .

Procedure

  1. Call the DBA Cockpit and choose Start of the navigation path Jobs Next navigation step Backup Logs Next navigation step Recovery Report End of the navigation path.

    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.

  2. Check the recovery report regularly to detect possible gaps in your backups:

    • Missing redo log files mean that if an error occurs, you can no longer restore the database to the current point in time. In this case, perform a complete database backup as soon as possible.

    • If there are too many redo log files, a recovery to the current point in time might take too long. In this case, perform a complete database backup as soon as possible.

Next Steps

Restore and Recovery

Restore and Recovery with BR*Tools