Oracle11g 中使用ADRCI 檢視alert log檔案(xml格式)

Automatic Diagnostic Repository (ADR)

 

存放資料庫診斷日誌、跟蹤檔案的目錄，稱作ADR base，對應初始化引數
diagnostic_dest。 如果設定了ORACLE_BASE環境變數，DIAGNOSTIC_DEST等
於ORACLE_BASE，如果沒有設定ORACLE_BASE，則等於ORACLE_HOME/log 。

SQL> show parameter diagnostic_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest                      string      /u01/product
SQL>

dbtest$ls
alert  cdump  hm  incident  incpkg  ir  lck  metadata  stage  sweep  trace

可以透過  SQL> select name,value from v$diag_info;  檢視相關資訊。 

ADRCI Command-Line Utility  命令列工具

dbtest$which adrci
/u01/product/oracle/bin/adrci 
dbtest$adrci

ADRCI: Release 11.2.0.1.0 - Production on Tue Aug 24 14:12:26 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
ADR base = "/u01/produc
adrci>
備註： 在adrci中命令大小寫不敏感。

在ADRCI中得到幫助：
adrci> help

 HELP [topic]
   Available Topics:
        CREATE REPORT
        ECHO
        EXIT
        HELP
        HOST
        IPS
        PURGE
        RUN
        SET BASE
        SET BROWSER
        SET CONTROL
        SET ECHO
        SET EDITOR
        SET HOMES | HOME | HOMEPATH
        SET TERMOUT
        SHOW ALERT
        SHOW BASE
        SHOW CONTROL
        SHOW HM_RUN
        SHOW HOMES | HOME | HOMEPATH
        SHOW INCDIR
        SHOW INCIDENT
        SHOW PROBLEM
        SHOW REPORT
        SHOW TRACEFILE
        SPOOL

 There are other commands intended to be used directly by Oracle, type
 "HELP EXTENDED" to see the list

adrci>