首页 > Linux操作系统 > Linux操作系统 > Oracle 警告日志 (alert log) 中包含哪些内容 ?

Oracle 警告日志 (alert log) 中包含哪些内容 ?

原创 Linux操作系统 作者:tolywang 时间:2009-05-07 09:46:29 0 删除 编辑
 Alert File

The alert file, or alert log, is a special 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 as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
  • 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博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。


  • 博文量
  • 访问量