Sunday , June 16 2024

Alert Files

In today’s article, we will be learning about the Alert files that we will write about the errors and changes in the Database.

This file is located in the directory specified in the BACKGROUND_DUMP_DEST parameter with the name alert_<SID>.log.

Or we can find it by querying the v$parameter view.

In the Alert File:

Opening-closing the database,

Add-delete redo log group,

Adding-deleting tablespace,

parameter changes,

ORA errors are found.

Below is a short excerpt from the alert file.

See Latest Logs

The last 1000 records coming to the alert file can be seen as follows.



Leave a Reply

Your email address will not be published. Required fields are marked *