Procedure documentationChecking the Status of Database Files - I

 

You check the database status when using BRRECOVER to perform complete database recovery.

This procedure checks the database for critical errors that might prevent production operation.

Prerequisites

BRRECOVER remounts – that is, closes and again mounts – the database to refresh the views V$DATAFILE and V$RECOVER_FILE. It then checks the availability of the following files:

  • Control files

  • Redo log files

  • Data files

BRRECOVER checks whether there are any data files not online. If so, it recommends to set them online.

Procedure

  1. Check the display and continue with the database recovery.

    Note Note

    If there are no files that need to be recovered, BRRECOVER stops the recovery automatically.

    End of the note.

  2. Check the results in the BRRECOVER detail log, v<encoded timestamp>.<ext>.

    For more information on how to view the logs, see Showing Profiles and Logs with BR*Tools.