Thealert file, oralert log, is aspecial trace file. The alert file of a database is a chronological log of messages and errors, which includes the following:
- All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur
- Administrative operations, such asCREATE,ALTER, andDROPstatements andSTARTUP,SHUTDOWN, andARCHIVELOGstatements
- Several messages and errors relating to the functions of shared server and dispatcher processes
- Errors occurring during the automatic refresh of a materialized view
- The values of all initialization parameters at the time the database and instance start
Oracle uses the alert file to keep a log of these special operations as an alternative to displaying such information on an operator's console (although many systems display information on the console). If an operation is successful, a "completed" message is written in the alert file, along with a timestamp.
Alert log警告日志是一个特殊的trace文件，它是按照时间排序的一些log或error信息，具体内容包括：
1. 所有internal error (ora-600), block corruption errors (ora-1578) , 以及死锁错误(ora-60)
2. 管理性操作，比如create , alert , drop 以及startup , shutdown 和archivelog 语句等。
3. 相关shared server 及 dispatcher 进程等功能相关的信息和错误。
4. Materialized view 自动刷新时候的错误
5. 数据库实例启动的时候初始化参数值
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/21805468/viewspace-619615/ ，如需转载，请注明出处，否则将追究法律责任。
