How do I reset the Oracle alert log?
search cancel

How do I reset the Oracle alert log?


Article ID: 160105


Updated On:


Data Loss Prevention Enforce


How to reset the Oracle alert log.


Relevant versions:  Oracle 19.x and above

If the alert log is getting too big, you can perform one of the following actions to remediate (listed in order of preference):

  1. Move the alert log to a different directory.
  2. Compress the alert log
  3. Delete the alert log

The next time the Oracle database needs to write a message into the log it will recreate the file.