Alert 日志文件是一种特殊的trace文件。alert日志文件里按照时间顺序记录数据库的信息和错误,主要包括如下内容:
l 所有的内部错误(ORA-600),锁失败错误(ORA-1578),和死锁错误(ORA-60)
l 管理操作,如创建、修改和DROP命令,以及启动、关闭和归档日志命令
l Message and errors relating to the functions of shared server and dispatcher processes
l Errors occurring during the automatic refresh of a materialized view
l 数据库和实例启动时,记录所有非默认的初始化参数的值
Oracle 数据库使用alert日志文件记录的信息一般不会在用户的控制台上显示(不过有些系统在控制台上会显示这些信息)。如果操作是成功的,在alert日志文件上就会显示“完成”,并且同时会有一个时间戳。
初始化参数决定着如下trace文件的位置和大小:
l BACKGROUND_DUMP_DEST
l USER_DUMP_DEST
l MAX_DUMP_FILE_SIZ
The alert log is a special trace file. The alert log of a database is a chronological log of messages and errors, and includes the following items:
l All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur
l Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
l Messages and errors relating to the functions of shared server and dispatcher processes
l Errors occurring during the automatic refresh of a materialized view
l The values of all initialization parameters that had nondefault values at the time the database and instance start
Oracle Database uses the alert log to record these operations as an alternative to displaying the information on an operator’s console (although some systems also display information on the console). If an operation is successful, a "completed" message is written in the alert log, along with a timestamp.
Initialization parameters controlling the location and size of trace files are:
l BACKGROUND_DUMP_DEST
l USER_DUMP_DEST
l MAX_DUMP_FILE_SIZE