ADRCI命令简介

第一：进入adrci

[oracle@rac1 ~]$ adrci

ADRCI: Release 11.2.0.4.0 - Production on Sat Jan 7 22:44:18 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u02/app/oracle"
adrci> 

第二：查询 adr home 

adrci> show home
ADR Homes: 
diag/clients/user_oracle/host_1874443374_80// 这个目录用的不多，我不是很清楚。
diag/rdbms/orcl/orcl1//故障排除，查看alert等都在这个目录，需要被设置成唯一目录。

第三设置唯一的adr home 

adrci> set home diag/rdbms/orcl/orcl1
adrci> show home
ADR Homes: 
diag/rdbms/orcl/orcl1

第四：查询alert日志

adrci> show alert -tail 10  查询最后十条。
2017-01-07 08:47:18.816000 -05:00
NOTE: force a map free for map id 7
2017-01-07 08:47:19.949000 -05:00
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
NOTE: Shutting down MARK background process
Stopping background process VKTM
NOTE: force a map free for map id 47
NOTE: force a map free for map id 46
NOTE: force a map free for map id 45
2017-01-07 08:47:25.015000 -05:00
freeing rdom 0
2017-01-07 08:47:28.627000 -05:00
Instance shutdown complete

或者 实时跟踪alert：

adrci> show alert -tail 10
2017-01-07 08:47:18.816000 -05:00
NOTE: force a map free for map id 7
2017-01-07 08:47:19.949000 -05:00
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
NOTE: Shutting down MARK background process
Stopping background process VKTM

或者：show alert - p "MESSAGE_TEXT like '%ORA-%'"

查询ORA错误，从alert日志里把ORA错误提取出来。

第五：查询incident：

adrci> show incident


ADR Home = /u02/app/oracle/diag/rdbms/orcl/orcl1:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME                              
-------------------- ----------------------------------------------------------- ---------------------------------------- 
156121               ORA 445                                                     2016-12-09 18:02:58.877000 -05:00       
1 rows fetched

incident简介：

Incidents – the occurrence of each serious error (e.g. ORA-600, ORA-1578) causes an incident to be created. 

Each incident is assignedan ID, and is described by a set of structured metadata.

诸如ORA-600错误的发生导致 incident被创建

每个incident  是个指定的ID，被一串 结构化的元数据描述。

第六：show problem

adrci> show problem

ADR Home = /u02/app/oracle/diag/rdbms/orcl/orcl1:
*************************************************************************
PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT        LASTINC_TIME                             
-------------------- ----------------------------------------------------------- -------------------- ---------------------------------------- 
1                    ORA 445                                                     156121               2016-12-09 18:02:58.877000 -05:00       
1 rows fetched

Oracle将每次错误信息作为一个INCIDENT，通过SHOW INCIDENT可以很方便的了解alert文件中包含所有的错误信息，以及发生的时间点。
而SHOW PROBLEM的结果更加清晰，它会根据Oracle的错误号，将相同的错误信息合并到一起(重复的incident)。通过这个结果，可以了解数据库出现了哪些不同的错误信息。SHOW ALERT/INCIDENT/PROBLEM都支持条件筛选。

例如：

adrci> show incident -mode detail -p "PROBLEM_ID=1"

ADR Home = /u02/app/oracle/diag/rdbms/orcl/orcl1:
*************************************************************************

**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
   INCIDENT_ID                   156121
   STATUS                        ready
   CREATE_TIME                   2016-12-09 18:02:58.877000 -05:00
   PROBLEM_ID                    1
   CLOSE_TIME                    <NULL>
   FLOOD_CONTROLLED              none
   ERROR_FACILITY                ORA
   ERROR_NUMBER                  445
   ERROR_ARG1                    GCR0
   ERROR_ARG2                    120
   ERROR_ARG3                    <NULL>
   ERROR_ARG4                    <NULL>
   ERROR_ARG5                    <NULL>
   ERROR_ARG6                    <NULL>
   ERROR_ARG7                    <NULL>
   ERROR_ARG8                    <NULL>
   ERROR_ARG9                    <NULL>
   ERROR_ARG10                   <NULL>
   ERROR_ARG11                   <NULL>
   ERROR_ARG12                   <NULL>
   SIGNALLING_COMPONENT          background_proc
   SIGNALLING_SUBCOMPONENT       <NULL>
   SUSPECT_COMPONENT             <NULL>
   SUSPECT_SUBCOMPONENT          <NULL>
   ECID                          <NULL>
   IMPACTS                       0
   PROBLEM_KEY                   ORA 445
   FIRST_INCIDENT                156121
   FIRSTINC_TIME                 2016-12-09 18:02:58.877000 -05:00
   LAST_INCIDENT                 156121
   LASTINC_TIME                  2016-12-09 18:02:58.877000 -05:00
   IMPACT1                       0
   IMPACT2                       0
   IMPACT3                       0
   IMPACT4                       0
   KEY_NAME                      ProcId
   KEY_VALUE                     15.1
   KEY_NAME                      Client ProcId
   KEY_VALUE                     oracle@rac1.17510_140715711727360
   KEY_NAME                      SID
   KEY_VALUE                     1145.1
   OWNER_ID                      1
   INCIDENT_FILE                 /u02/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lmhb_17510.trc
   OWNER_ID                      1
   INCIDENT_FILE                 /u02/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_156121/orcl1_lmhb_17510_i156121.trc
1 rows fetched