第一:进入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