What is the use of ALERT log file? Where can you find the ALERT log file?

@ : Home > > Interview Room

Alert log file is a log file that records database-wide events which is used for trouble shooting.
We can find the Log file in BACKGROUND_DUMP_DEST parameter.

Following events are recorded in ALERT log file:

  • Database shutdown and startup information.
  • All non-default parameters.
  • Oracle internal (ORA-600) errors.
  • Information about a modified control file.
  • Log switch change.
Alert me