Oracle 警告日誌 (alert log) 中包含哪些內容 ？

tolywang發表於2009-05-07
Oracle
 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部落格 ” ，連結：http://blog.itpub.net/35489/viewspace-594387/，如需轉載，請註明出處，否則將追究法律責任。

相關文章