[20130217]11GR2 adrci的學習.txt
[20130217]11GR2 adrci的學習.txt
春節放假,學習一下adrci的使用.adrci (Automatic Diagnostic Repository Command Interpreter).
ADRCI: Release 11.2.0.1.0 - Production on Tue Aug 21 16:35:06 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle11g"
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> HELP EXTENDED
HELP [topic]
Available Topics:
BEGIN BACKUP
CD
CREATE STAGING XMLSCHEMA
CREATE VIEW
DDE
DEFINE
DELETE
DESCRIBE
DROP VIEW
END BACKUP
INSERT
LIST DEFINE
MERGE ALERT
MERGE FILE
MIGRATE
QUERY
REPAIR
SELECT
SET COLUMN
SHOW CATALOG
SHOW DUMP
SHOW SECTION
SHOW TRACE
SHOW TRACEMAP
SWEEP
UNDEFINE
UPDATE
VIEW
1.定義別名，便於使用上下鍵以及歷史功能以及設定編輯器,不過我感覺使用rlwrap效果更好.
adrci> set editor vim
--set browser mozilla
2.顯示home
adrci> show home
ADR Homes:
diag/tnslsnr/hisdg/listener
diag/rdbms/test/test1
diag/rdbms/test/test
4.設定home：
adrci> set home diag/rdbms/test/test
5.檢視alert.log
adrci> show alert -tail -f
adrci> show alert -tail 100 -f
--顯示alert*.log的最後100行
6.顯示問題problem,show incident
7.顯示incident：
adrci> show incident
incident
n.
(政治性)事故; 事變
偶發事件, 小事件
(劇情的)枝節, (小說的)插話;【律】財產所附帶的權利[義務]
差錯
【數】關聯
without incident
平安無事
--可以使用help show problem ，檢視幫助。記不住這個單詞incident :-)
--僅僅顯示50行,而且最近的看不見.
adrci> help show incident
Usage: SHOW INCIDENT [-p]
[-mode BASIC|BRIEF|DETAIL]
[-last | -all]
[-orderby (field1, field2, ...) [ASC|DSC]]
Purpose: Show the incident information. By default, this command will
only show the last 50 incidents which are not flood controlled.
Options:
[-p]: The predicate string must be double-quoted.
[-mode BASIC|BRIEF|DETAIL]: The different modes of showing incidents.
BASIC will show the basic information of non-flooded controlled
incidents, which is the default mode. In this mode, only the following
fields can be used in the predicate clause:
INCIDENT_ID number
PROBLEM_KEY text(550)
CREATE_TIME timestamp
BRIEF will display incident information from the incident relation.
In this mode, the fields can appear in the predicate are:
INCIDENT_ID number
PROBLEM_ID number
CREATE_TIME timestamp
CLOSE_TIME timestamp
STATUS number
FLAGS number
FLOOD_CONTROLLED number
ERROR_FACILITY text(10)
ERROR_NUMBER number
ERROR_ARG1 text(64)
ERROR_ARG2 text(64)
ERROR_ARG3 text(64)
ERROR_ARG4 text(64)
ERROR_ARG5 text(64)
ERROR_ARG6 text(64)
ERROR_ARG7 text(64)
ERROR_ARG8 text(64)
SIGNALLING_COMPONENT text(64)
SIGNALLING_SUBCOMPONENT text(64)
SUSPECT_COMPONENT text(64)
SUSPECT_SUBCOMPONENT text(64)
ECID text(64)
IMPACT number
DETAIL will display all incident-related information, such as incident
files. The fields can appear in the predicate is the same as the ones
in the brief mode.
[-last | -all]: This option allows users to either select
the last of qualified incidents to show or to show all the
qualified incidents. If this option is not specified, this command
will only show 50 incidents.
[-orderby (field1, field2, ...) [ASC|DSC]]: If specified, the results
will be ordered by the specified fields' values. By default, it will be
in the ascending order unless "DSC" is specified. Note that the field
names that can be specified here are from the "INCIDENT" relation.
Examples:
show incident
show incident -mode detail
show incident -mode detail -p "incident_id=123"
adrci> show incident -mode detail -p "incident_id=321804"
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
INCIDENT_ID 321804
STATUS ready
CREATE_TIME 2012-09-28 09:51:18.676000 +08:00
PROBLEM_ID 9
CLOSE_TIME
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 600
ERROR_ARG1 25027
ERROR_ARG2 4
ERROR_ARG3 1
ERROR_ARG4
ERROR_ARG5
ERROR_ARG6
ERROR_ARG7
ERROR_ARG8
ERROR_ARG9
ERROR_ARG10
ERROR_ARG11
ERROR_ARG12
SIGNALLING_COMPONENT
SIGNALLING_SUBCOMPONENT
SUSPECT_COMPONENT
SUSPECT_SUBCOMPONENT
ECID
IMPACTS 0
PROBLEM_KEY ORA 600 [25027]
FIRST_INCIDENT 321804
FIRSTINC_TIME 2012-09-28 09:51:18.676000 +08:00
LAST_INCIDENT 321886
LASTINC_TIME 2012-09-28 10:32:07.660000 +08:00
IMPACT1 0
IMPACT2 0
IMPACT3 0
IMPACT4 0
KEY_NAME Client ProcId
KEY_VALUE oracle@hisdg (TNS V1-V3).4078_182918269152
KEY_NAME SID
KEY_VALUE 361.40
KEY_NAME ProcId
KEY_VALUE 22.14
KEY_NAME PQ
KEY_VALUE (0, 1348797078)
OWNER_ID 1
INCIDENT_FILE /u01/app/oracle11g/diag/rdbms/test/test/incident/incdir_321804/test_ora_4078_i321804.trc
OWNER_ID 1
INCIDENT_FILE /u01/app/oracle11g/diag/rdbms/test/test/trace/test_ora_4078.trc
1 rows fetched
8. 建立包或者zip檔案，傳送給oracle(Creation of Packages & ZIP files to send to Oracle Support)
例子：
adrci> help ips create package
Usage: IPS CREATE PACKAGE
[INCIDENT | PROBLEM | PROBLEMKEY |
SECONDS | TIME TO ]
[CORRELATE BASIC | TYPICAL | ALL]
Purpose: Create a package, and optionally select contents for the package.
Arguments:
: ID of incident to use for selecting package contents.
: ID of problem to use for selecting package contents.
: Problem key to use for selecting package contents.
: Number of seconds before now for selecting package contents.
: Start of time range to look for incidents in.
: End of time range to look for incidents in.
Options:
CORRELATE BASIC: The package will include the incident dumps, and the
incident process trace files.
Additional incidents can be included automatically,
if they share relevant correlation keys.
CORRELATE TYPICAL: The package will include the incident dumps, and all
trace files that were modified in a time window around
each incident.
Additional incidents can be included automatically,
if they share relevant correlation keys, or occurred
in a time window around the main incidents.
CORRELATE ALL: The package will include the incident dumps, and all
trace files that were modified between the first
selected incident and the last selected incident.
Additional incidents can be included automatically,
if they occurred in the same time range.
Notes:
If no package contents are specified (incident, problem, etc), an empty
package will be created. Files and incidents can be added later.
If no correlation level is specified, the default level is used.
The default is normally TYPICAL, but it can be changed using the command
IPS SET CONFIGURATION.
Example:
ips create package incident 861;
ips create package time '2006-12-31 23:59:59.00 -07:00' to
'2007-01-01 01:01:01.00 -07:00';
ips create package problem 9 correlate all
ips create package incident 321805 correlate all
adrci> ips create package problem 9 correlate all
Created package 4 based on problem id 9, correlation level all
adrci> ips create package incident 321805 correlate all
Created package 5 based on incident id 321805, correlation level all
adrci> ips generate package 4 in "/home/oracle11g"
Generated package 4 in file /home/oracle11g/IPSPKG_20130217152553_COM_1.zip, mode complete
$ unzip -t IPSPKG_20130217152553_COM_1.zip
Archive: IPSPKG_20130217152553_COM_1.zip
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_CONFIGURATION.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_PACKAGE.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_PACKAGE_INCIDENT.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_PACKAGE_FILE.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_PACKAGE_HISTORY.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_FILE_METADATA.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_FILE_COPY_LOG.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_ACTION_DEF.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_ACTION_PARAMETER_DEF.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_ACTION.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_ACTION_PARAMETER.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_INCIDENT_TYPE.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_INCIDENT_ACTION_MAP.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/INCIDENT.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/INCCKEY.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/INCIDENT_FILE.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/PROBLEM.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/HM_RUN.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/EM_USER_ACTIVITY.dmp OK
testing: diag/rdbms/test/test/alert/log.xml OK
testing: diag/rdbms/test/test/trace/alert_test.log OK
testing: diag/rdbms/test/test/trace/test_lgwr_5731.trc OK
testing: diag/rdbms/test/test/trace/test_lgwr_5731.trm OK
testing: diag/rdbms/test/test/trace/test_vktm_5713.trc OK
testing: diag/rdbms/test/test/trace/test_vktm_5713.trm OK
testing: diag/rdbms/test/test/trace/test_ckpt_5733.trc OK
testing: diag/rdbms/test/test/trace/test_ckpt_5733.trm OK
testing: diag/rdbms/test/test/trace/test_mman_5727.trc OK
testing: diag/rdbms/test/test/trace/test_mman_5727.trm OK
testing: diag/rdbms/test/test/trace/test_ora_5763.trc OK
testing: diag/rdbms/test/test/trace/test_ora_5763.trm OK
testing: diag/rdbms/test/test/trace/test_dbrm_5721.trc OK
testing: diag/rdbms/test/test/trace/test_dbrm_5721.trm OK
testing: diag/rdbms/test/test/trace/test_arc0_5765.trc OK
testing: diag/rdbms/test/test/trace/test_arc0_5765.trm OK
testing: diag/rdbms/test/test/trace/test_arc3_5771.trc OK
testing: diag/rdbms/test/test/trace/test_arc3_5771.trm OK
testing: diag/rdbms/test/test/trace/test_ora_5659.trc OK
testing: diag/rdbms/test/test/trace/test_ora_5659.trm OK
testing: diag/rdbms/test/test/trace/test_j003_5795_local.trc OK
testing: diag/rdbms/test/test/trace/test_j003_5795_local.trm OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/crs/crsdiag.log OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/metadata.xml OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/manifest_4_1.xml OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/manifest_4_1.html OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/manifest_4_1.txt OK
testing: metadata.xml OK
No errors detected in compressed data of IPSPKG_20130217152553_COM_1.zip.
9.維護： Managing, especially purging of tracefiles
adrci> show tracefile -rt
17-FEB-13 15:04:10 diag/rdbms/test/test/trace/test_ckpt_5733.trc
17-FEB-13 14:57:53 diag/rdbms/test/test/trace/alert_test.log
17-FEB-13 14:53:00 diag/rdbms/test/test/trace/test_j003_5795_local.trc
17-FEB-13 14:52:53 diag/rdbms/test/test/trace/test_ora_5763.trc
17-FEB-13 14:52:52 diag/rdbms/test/test/trace/test_dbrm_5721.trc
17-FEB-13 14:52:46 diag/rdbms/test/test/trace/test_mman_5727.trc
17-FEB-13 14:52:45 diag/rdbms/test/test/trace/test_ora_5659.trc
17-FEB-13 14:52:45 diag/rdbms/test/test/trace/test_vktm_5713.trc
07-FEB-13 17:33:55 diag/rdbms/test/test/trace/test_vktm_28511.trc
07-FEB-13 17:33:55 diag/rdbms/test/test/trace/test_ora_32041_local.trc
07-FEB-13 17:15:18 diag/rdbms/test/test/trace/test_ckpt_28533.trc
07-FEB-13 17:00:12 diag/rdbms/test/test/trace/test_lgwr_28529.trc
03-DEC-12 10:53:39 diag/rdbms/test/test/incident/incdir_941461/test_ora_25910_i941461.trc
....
adrci> column PROBLEM_KEY format a60
DIA-48415: Syntax error found in string [column PROBLEM_KEY ] at column [21]
adrci> help set column
Usage: SET COLUMN TEXT
Purpose: Set the maximum bytes to display for fields with text type.
Arguments:
: The maximum number of bytes to display.
Examples:
set column text 32
--僅僅定義一個,不能真對特定欄位.
1 Row Deleted
10.還可以使用select,delete 對incident，problem操作。
總結:
其實adrci很好用,並沒有想象的這麼難!
春節放假,學習一下adrci的使用.adrci (Automatic Diagnostic Repository Command Interpreter).
ADRCI: Release 11.2.0.1.0 - Production on Tue Aug 21 16:35:06 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle11g"
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> HELP EXTENDED
HELP [topic]
Available Topics:
BEGIN BACKUP
CD
CREATE STAGING XMLSCHEMA
CREATE VIEW
DDE
DEFINE
DELETE
DESCRIBE
DROP VIEW
END BACKUP
INSERT
LIST DEFINE
MERGE ALERT
MERGE FILE
MIGRATE
QUERY
REPAIR
SELECT
SET COLUMN
SHOW CATALOG
SHOW DUMP
SHOW SECTION
SHOW TRACE
SHOW TRACEMAP
SWEEP
UNDEFINE
UPDATE
VIEW
1.定義別名，便於使用上下鍵以及歷史功能以及設定編輯器,不過我感覺使用rlwrap效果更好.
adrci> set editor vim
--set browser mozilla
2.顯示home
adrci> show home
ADR Homes:
diag/tnslsnr/hisdg/listener
diag/rdbms/test/test1
diag/rdbms/test/test
4.設定home：
adrci> set home diag/rdbms/test/test
5.檢視alert.log
adrci> show alert -tail -f
adrci> show alert -tail 100 -f
--顯示alert*.log的最後100行
6.顯示問題problem,show incident
adrci> show problem
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
19 ORA 600 [qcdlSynonymTranslation] 941461 2012-12-03 10:53:37.458000 +08:00
18 ORA 353 [18432] [3179742363] 923378 2012-11-28 10:08:40.003000 +08:00
17 ORA 353 [52739] [3179751789] 923370 2012-11-28 10:08:38.367000 +08:00
13 ORA 25319 922168 2012-11-28 09:07:32.587000 +08:00
15 ORA 600 [2662] 920959 2012-11-27 16:18:18.991000 +08:00
16 ORA 603 922003 2012-11-27 16:18:01.916000 +08:00
7 ORA 1578 918590 2012-11-27 15:39:00.949000 +08:00
14 ORA 445 912352 2012-11-26 10:52:39.822000 +08:00
12 ORA 7445 [dbgrmqmqpk_query_pick_key()+2033] 825872 2012-11-22 08:06:35.396000 +08:00
11 ORA 600 [2162] 678287 2012-11-05 14:40:20.825000 +08:00
10 ORA 7445 [rpidrv()+670] 563059 2012-10-17 15:51:38.496000 +08:00
8 ORA 600 [18062] 444191 2012-10-10 15:24:46.238000 +08:00
9 ORA 600 [25027] 321886 2012-09-28 10:32:07.660000 +08:00
6 ORA 7445 [qcdlaucn()+201] 112993 2012-09-06 15:59:33.894000 +08:00
5 ORA 7445 [qcstda()+783] 108266 2012-08-21 12:02:25.021000 +08:00
4 ORA 7445 [kkeidc()+8755] 103360 2012-07-30 11:06:01.289000 +08:00
3 ORA 600 [510] 91452 2012-05-13 09:34:22.326000 +08:00
17 rows fetched
7.顯示incident：
adrci> show incident
incident
n.
(政治性)事故; 事變
偶發事件, 小事件
(劇情的)枝節, (小說的)插話;【律】財產所附帶的權利[義務]
差錯
【數】關聯
without incident
平安無事
--可以使用help show problem ，檢視幫助。記不住這個單詞incident :-)
adrci> show incident
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
123878 ORA 1578 2012-09-14 12:07:51.517000 +08:00
123879 ORA 1578 2012-09-14 12:07:55.899000 +08:00
123880 ORA 1578 2012-09-14 12:08:02.896000 +08:00
123881 ORA 1578 2012-09-14 12:08:15.585000 +08:00
123882 ORA 1578 2012-09-14 12:08:28.882000 +08:00
314580 ORA 600 [18062] 2012-09-28 08:53:19.926000 +08:00
321804 ORA 600 [25027] 2012-09-28 09:51:18.676000 +08:00
321805 ORA 600 [25027] 2012-09-28 09:51:45.021000 +08:00
321806 ORA 600 [25027] 2012-09-28 09:53:02.917000 +08:00
321884 ORA 600 [25027] 2012-09-28 10:30:05.316000 +08:00
321885 ORA 600 [25027] 2012-09-28 10:30:43.402000 +08:00
368586 ORA 1578 2012-10-08 09:40:41.261000 +08:00
368587 ORA 1578 2012-10-08 09:40:45.020000 +08:00
368588 ORA 1578 2012-10-08 09:40:52.570000 +08:00
408189 ORA 1578 2012-10-09 15:29:32.280000 +08:00
408190 ORA 1578 2012-10-09 15:29:34.240000 +08:00
422591 ORA 600 [18062] 2012-10-09 15:52:32.680000 +08:00
444191 ORA 600 [18062] 2012-10-10 15:24:46.238000 +08:00
519791 ORA 1578 2012-10-16 16:34:25.789000 +08:00
519792 ORA 1578 2012-10-16 16:34:27.715000 +08:00
527041 ORA 1578 2012-10-16 16:53:27.971000 +08:00
527042 ORA 1578 2012-10-16 16:53:29.987000 +08:00
527043 ORA 1578 2012-10-16 16:55:00.769000 +08:00
537796 ORA 1578 2012-10-17 08:31:25.789000 +08:00
537797 ORA 1578 2012-10-17 08:31:37.265000 +08:00
537798 ORA 1578 2012-10-17 08:31:53.318000 +08:00
537799 ORA 1578 2012-10-17 08:31:54.925000 +08:00
537800 ORA 1578 2012-10-17 08:32:07.053000 +08:00
563059 ORA 7445 [rpidrv()+670] 2012-10-17 15:51:38.496000 +08:00
663924 ORA 600 [2162] 2012-11-05 11:51:46.058000 +08:00
667413 ORA 600 [2162] 2012-11-05 12:00:56.063000 +08:00
671013 ORA 600 [2162] 2012-11-05 12:01:45.227000 +08:00
678286 ORA 600 [2162] 2012-11-05 14:37:13.509000 +08:00
678287 ORA 600 [2162] 2012-11-05 14:40:20.825000 +08:00
825872 ORA 7445 [dbgrmqmqpk_query_pick_key()+2033] 2012-11-22 08:06:35.396000 +08:00
861817 ORA 25319 2012-11-23 12:01:37.610000 +08:00
865418 ORA 25319 2012-11-23 12:03:49.730000 +08:00
869019 ORA 25319 2012-11-23 12:08:48.159000 +08:00
905020 ORA 25319 2012-11-23 15:36:29.440000 +08:00
908621 ORA 25319 2012-11-26 10:13:50.136000 +08:00
912222 ORA 25319 2012-11-26 10:14:57.514000 +08:00
912190 ORA 445 2012-11-26 10:19:52.839000 +08:00
912191 ORA 445 2012-11-26 10:19:55.803000 +08:00
912192 ORA 445 2012-11-26 10:22:54.878000 +08:00
912193 ORA 445 2012-11-26 10:23:54.968000 +08:00
912194 ORA 445 2012-11-26 10:24:54.978000 +08:00
912511 ORA 25319 2012-11-26 10:59:53.853000 +08:00
913712 ORA 25319 2012-11-27 09:11:43.331000 +08:00
914913 ORA 25319 2012-11-27 09:14:46.498000 +08:00
914977 ORA 1578 2012-11-27 09:15:03.140000 +08:00
First 50 rows fetched (*** more available ***)
--僅僅顯示50行,而且最近的看不見.
adrci> help show incident
Usage: SHOW INCIDENT [-p
[-mode BASIC|BRIEF|DETAIL]
[-last
[-orderby (field1, field2, ...) [ASC|DSC]]
Purpose: Show the incident information. By default, this command will
only show the last 50 incidents which are not flood controlled.
Options:
[-p
[-mode BASIC|BRIEF|DETAIL]: The different modes of showing incidents.
BASIC will show the basic information of non-flooded controlled
incidents, which is the default mode. In this mode, only the following
fields can be used in the predicate clause:
INCIDENT_ID number
PROBLEM_KEY text(550)
CREATE_TIME timestamp
BRIEF will display incident information from the incident relation.
In this mode, the fields can appear in the predicate are:
INCIDENT_ID number
PROBLEM_ID number
CREATE_TIME timestamp
CLOSE_TIME timestamp
STATUS number
FLAGS number
FLOOD_CONTROLLED number
ERROR_FACILITY text(10)
ERROR_NUMBER number
ERROR_ARG1 text(64)
ERROR_ARG2 text(64)
ERROR_ARG3 text(64)
ERROR_ARG4 text(64)
ERROR_ARG5 text(64)
ERROR_ARG6 text(64)
ERROR_ARG7 text(64)
ERROR_ARG8 text(64)
SIGNALLING_COMPONENT text(64)
SIGNALLING_SUBCOMPONENT text(64)
SUSPECT_COMPONENT text(64)
SUSPECT_SUBCOMPONENT text(64)
ECID text(64)
IMPACT number
DETAIL will display all incident-related information, such as incident
files. The fields can appear in the predicate is the same as the ones
in the brief mode.
[-last
the last
qualified incidents. If this option is not specified, this command
will only show 50 incidents.
[-orderby (field1, field2, ...) [ASC|DSC]]: If specified, the results
will be ordered by the specified fields' values. By default, it will be
in the ascending order unless "DSC" is specified. Note that the field
names that can be specified here are from the "INCIDENT" relation.
Examples:
show incident
show incident -mode detail
show incident -mode detail -p "incident_id=123"
adrci> show incident -last 10
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
123878 ORA 1578 2012-09-14 12:07:51.517000 +08:00
123879 ORA 1578 2012-09-14 12:07:55.899000 +08:00
123880 ORA 1578 2012-09-14 12:08:02.896000 +08:00
123881 ORA 1578 2012-09-14 12:08:15.585000 +08:00
123882 ORA 1578 2012-09-14 12:08:28.882000 +08:00
314580 ORA 600 [18062] 2012-09-28 08:53:19.926000 +08:00
321804 ORA 600 [25027] 2012-09-28 09:51:18.676000 +08:00
321805 ORA 600 [25027] 2012-09-28 09:51:45.021000 +08:00
321806 ORA 600 [25027] 2012-09-28 09:53:02.917000 +08:00
321884 ORA 600 [25027] 2012-09-28 10:30:05.316000 +08:00
First 10 rows fetched (*** more available ***)
adrci> show incident -mode detail -p "incident_id=321804"
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
**********************************************************
INCIDENT INFO RECORD 1
**********************************************************
INCIDENT_ID 321804
STATUS ready
CREATE_TIME 2012-09-28 09:51:18.676000 +08:00
PROBLEM_ID 9
CLOSE_TIME
FLOOD_CONTROLLED none
ERROR_FACILITY ORA
ERROR_NUMBER 600
ERROR_ARG1 25027
ERROR_ARG2 4
ERROR_ARG3 1
ERROR_ARG4
ERROR_ARG5
ERROR_ARG6
ERROR_ARG7
ERROR_ARG8
ERROR_ARG9
ERROR_ARG10
ERROR_ARG11
ERROR_ARG12
SIGNALLING_COMPONENT
SIGNALLING_SUBCOMPONENT
SUSPECT_COMPONENT
SUSPECT_SUBCOMPONENT
ECID
IMPACTS 0
PROBLEM_KEY ORA 600 [25027]
FIRST_INCIDENT 321804
FIRSTINC_TIME 2012-09-28 09:51:18.676000 +08:00
LAST_INCIDENT 321886
LASTINC_TIME 2012-09-28 10:32:07.660000 +08:00
IMPACT1 0
IMPACT2 0
IMPACT3 0
IMPACT4 0
KEY_NAME Client ProcId
KEY_VALUE oracle@hisdg (TNS V1-V3).4078_182918269152
KEY_NAME SID
KEY_VALUE 361.40
KEY_NAME ProcId
KEY_VALUE 22.14
KEY_NAME PQ
KEY_VALUE (0, 1348797078)
OWNER_ID 1
INCIDENT_FILE /u01/app/oracle11g/diag/rdbms/test/test/incident/incdir_321804/test_ora_4078_i321804.trc
OWNER_ID 1
INCIDENT_FILE /u01/app/oracle11g/diag/rdbms/test/test/trace/test_ora_4078.trc
1 rows fetched
8. 建立包或者zip檔案，傳送給oracle(Creation of Packages & ZIP files to send to Oracle Support)
例子：
adrci> help ips create package
Usage: IPS CREATE PACKAGE
[INCIDENT
SECONDS
[CORRELATE BASIC | TYPICAL | ALL]
Purpose: Create a package, and optionally select contents for the package.
Arguments:
Options:
CORRELATE BASIC: The package will include the incident dumps, and the
incident process trace files.
Additional incidents can be included automatically,
if they share relevant correlation keys.
CORRELATE TYPICAL: The package will include the incident dumps, and all
trace files that were modified in a time window around
each incident.
Additional incidents can be included automatically,
if they share relevant correlation keys, or occurred
in a time window around the main incidents.
CORRELATE ALL: The package will include the incident dumps, and all
trace files that were modified between the first
selected incident and the last selected incident.
Additional incidents can be included automatically,
if they occurred in the same time range.
Notes:
If no package contents are specified (incident, problem, etc), an empty
package will be created. Files and incidents can be added later.
If no correlation level is specified, the default level is used.
The default is normally TYPICAL, but it can be changed using the command
IPS SET CONFIGURATION.
Example:
ips create package incident 861;
ips create package time '2006-12-31 23:59:59.00 -07:00' to
'2007-01-01 01:01:01.00 -07:00';
ips create package problem 9 correlate all
ips create package incident 321805 correlate all
adrci> ips create package problem 9 correlate all
Created package 4 based on problem id 9, correlation level all
adrci> ips create package incident 321805 correlate all
Created package 5 based on incident id 321805, correlation level all
adrci> ips generate package 4 in "/home/oracle11g"
Generated package 4 in file /home/oracle11g/IPSPKG_20130217152553_COM_1.zip, mode complete
$ unzip -t IPSPKG_20130217152553_COM_1.zip
Archive: IPSPKG_20130217152553_COM_1.zip
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_CONFIGURATION.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_PACKAGE.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_PACKAGE_INCIDENT.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_PACKAGE_FILE.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_PACKAGE_HISTORY.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_FILE_METADATA.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/IPS_FILE_COPY_LOG.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_ACTION_DEF.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_ACTION_PARAMETER_DEF.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_ACTION.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_ACTION_PARAMETER.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_INCIDENT_TYPE.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/DDE_USER_INCIDENT_ACTION_MAP.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/INCIDENT.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/INCCKEY.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/INCIDENT_FILE.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/PROBLEM.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/HM_RUN.dmp OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/export/EM_USER_ACTIVITY.dmp OK
testing: diag/rdbms/test/test/alert/log.xml OK
testing: diag/rdbms/test/test/trace/alert_test.log OK
testing: diag/rdbms/test/test/trace/test_lgwr_5731.trc OK
testing: diag/rdbms/test/test/trace/test_lgwr_5731.trm OK
testing: diag/rdbms/test/test/trace/test_vktm_5713.trc OK
testing: diag/rdbms/test/test/trace/test_vktm_5713.trm OK
testing: diag/rdbms/test/test/trace/test_ckpt_5733.trc OK
testing: diag/rdbms/test/test/trace/test_ckpt_5733.trm OK
testing: diag/rdbms/test/test/trace/test_mman_5727.trc OK
testing: diag/rdbms/test/test/trace/test_mman_5727.trm OK
testing: diag/rdbms/test/test/trace/test_ora_5763.trc OK
testing: diag/rdbms/test/test/trace/test_ora_5763.trm OK
testing: diag/rdbms/test/test/trace/test_dbrm_5721.trc OK
testing: diag/rdbms/test/test/trace/test_dbrm_5721.trm OK
testing: diag/rdbms/test/test/trace/test_arc0_5765.trc OK
testing: diag/rdbms/test/test/trace/test_arc0_5765.trm OK
testing: diag/rdbms/test/test/trace/test_arc3_5771.trc OK
testing: diag/rdbms/test/test/trace/test_arc3_5771.trm OK
testing: diag/rdbms/test/test/trace/test_ora_5659.trc OK
testing: diag/rdbms/test/test/trace/test_ora_5659.trm OK
testing: diag/rdbms/test/test/trace/test_j003_5795_local.trc OK
testing: diag/rdbms/test/test/trace/test_j003_5795_local.trm OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/crs/crsdiag.log OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/metadata.xml OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/manifest_4_1.xml OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/manifest_4_1.html OK
testing: diag/rdbms/test/test/incpkg/pkg_4/seq_1/manifest_4_1.txt OK
testing: metadata.xml OK
No errors detected in compressed data of IPSPKG_20130217152553_COM_1.zip.
9.維護： Managing, especially purging of tracefiles
adrci> show tracefile -rt
17-FEB-13 15:04:10 diag/rdbms/test/test/trace/test_ckpt_5733.trc
17-FEB-13 14:57:53 diag/rdbms/test/test/trace/alert_test.log
17-FEB-13 14:53:00 diag/rdbms/test/test/trace/test_j003_5795_local.trc
17-FEB-13 14:52:53 diag/rdbms/test/test/trace/test_ora_5763.trc
17-FEB-13 14:52:52 diag/rdbms/test/test/trace/test_dbrm_5721.trc
17-FEB-13 14:52:46 diag/rdbms/test/test/trace/test_mman_5727.trc
17-FEB-13 14:52:45 diag/rdbms/test/test/trace/test_ora_5659.trc
17-FEB-13 14:52:45 diag/rdbms/test/test/trace/test_vktm_5713.trc
07-FEB-13 17:33:55 diag/rdbms/test/test/trace/test_vktm_28511.trc
07-FEB-13 17:33:55 diag/rdbms/test/test/trace/test_ora_32041_local.trc
07-FEB-13 17:15:18 diag/rdbms/test/test/trace/test_ckpt_28533.trc
07-FEB-13 17:00:12 diag/rdbms/test/test/trace/test_lgwr_28529.trc
03-DEC-12 10:53:39 diag/rdbms/test/test/incident/incdir_941461/test_ora_25910_i941461.trc
....
adrci> show control
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
2768052777 720 8760 2011-11-22 09:59:56.721852 +08:00 2012-11-09 22:13:03.850799 +08:00 2012-09-10 09:29:17.716986 +08:00 1 2 76 1 2011-11-22 09:59:56.721852 +08:00
1 rows fetched
The ordinary tracefiles will stay for 30 days (720 hours), while files like incident files stay one year (8760 hours) by
default. We can change that policy with for example:
adrci> set control (SHORTP_POLICY = 360)
adrci> set control (LONGP_POLICY = 2190)
adrci> show control
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
2768052777 360 2190 2013-02-17 15:29:08.166801 +08:00 2012-11-09 22:13:03.850799 +08:00 2012-09-10 09:29:17.716986 +08:00 1 2 76 1 2011-11-22 09:59:56.721852 +08:00
1 rows fetched
Also, we may want to purge tracefiles manually. Following command will manually purge all tracefiles older than 2 days
(2880 minutes):
adrci> purge -age 1440 -type INCIDENT
adrci> show tracefile -rt
--實際上我們還可以在adric使用sql命令:
adrci> desc problem ;
Name Type NULL?
----------------------------- --------------- -----------
PROBLEM_ID number
PROBLEM_KEY text(550)
FIRST_INCIDENT number
FIRSTINC_TIME timestamp
LAST_INCIDENT number
LASTINC_TIME timestamp
IMPACT1 number
IMPACT2 number
IMPACT3 number
IMPACT4 number
SERVICE_REQUEST text(64)
BUG_NUMBER text(64)
adrci> select PROBLEM_ID,PROBLEM_KEY,LAST_INCIDENT,LASTINC_TIME from problem;
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ---------------------------------------------------------------------------------------------------- -------------------- ----------------------------------------
6 ORA 7445 [qcdlaucn()+201] 112993 2012-09-06 15:59:33.894000 +08:00
7 ORA 1578 918590 2012-11-27 15:39:00.949000 +08:00
3 ORA 600 [510] 91452 2012-05-13 09:34:22.326000 +08:00
4 ORA 7445 [kkeidc()+8755] 103360 2012-07-30 11:06:01.289000 +08:00
5 ORA 7445 [qcstda()+783] 108266 2012-08-21 12:02:25.021000 +08:00
8 ORA 600 [18062] 444191 2012-10-10 15:24:46.238000 +08:00
9 ORA 600 [25027] 321886 2012-09-28 10:32:07.660000 +08:00
10 ORA 7445 [rpidrv()+670] 563059 2012-10-17 15:51:38.496000 +08:00
11 ORA 600 [2162] 678287 2012-11-05 14:40:20.825000 +08:00
12 ORA 7445 [dbgrmqmqpk_query_pick_key()+2033] 825872 2012-11-22 08:06:35.396000 +08:00
13 ORA 25319 922168 2012-11-28 09:07:32.587000 +08:00
14 ORA 445 912352 2012-11-26 10:52:39.822000 +08:00
15 ORA 600 [2662] 920959 2012-11-27 16:18:18.991000 +08:00
16 ORA 603 922003 2012-11-27 16:18:01.916000 +08:00
17 ORA 353 [52739] [3179751789] 923370 2012-11-28 10:08:38.367000 +08:00
18 ORA 353 [18432] [3179742363] 923378 2012-11-28 10:08:40.003000 +08:00
19 ORA 600 [qcdlSynonymTranslation] 941461 2012-12-03 10:53:37.458000 +08:00
17 rows fetched
adrci> show problem
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
19 ORA 600 [qcdlSynonymTranslation] 941461 2012-12-03 10:53:37.458000 +08:00
18 ORA 353 [18432] [3179742363] 923378 2012-11-28 10:08:40.003000 +08:00
17 ORA 353 [52739] [3179751789] 923370 2012-11-28 10:08:38.367000 +08:00
13 ORA 25319 922168 2012-11-28 09:07:32.587000 +08:00
15 ORA 600 [2662] 920959 2012-11-27 16:18:18.991000 +08:00
16 ORA 603 922003 2012-11-27 16:18:01.916000 +08:00
7 ORA 1578 918590 2012-11-27 15:39:00.949000 +08:00
14 ORA 445 912352 2012-11-26 10:52:39.822000 +08:00
12 ORA 7445 [dbgrmqmqpk_query_pick_key()+2033] 825872 2012-11-22 08:06:35.396000 +08:00
11 ORA 600 [2162] 678287 2012-11-05 14:40:20.825000 +08:00
10 ORA 7445 [rpidrv()+670] 563059 2012-10-17 15:51:38.496000 +08:00
8 ORA 600 [18062] 444191 2012-10-10 15:24:46.238000 +08:00
9 ORA 600 [25027] 321886 2012-09-28 10:32:07.660000 +08:00
6 ORA 7445 [qcdlaucn()+201] 112993 2012-09-06 15:59:33.894000 +08:00
5 ORA 7445 [qcstda()+783] 108266 2012-08-21 12:02:25.021000 +08:00
4 ORA 7445 [kkeidc()+8755] 103360 2012-07-30 11:06:01.289000 +08:00
3 ORA 600 [510] 91452 2012-05-13 09:34:22.326000 +08:00
17 rows fetched-- 僅僅顯示的寬度不同.顯示沒有按照PROBLEM_ID排序吧了.
adrci> column PROBLEM_KEY format a60
DIA-48415: Syntax error found in string [column PROBLEM_KEY ] at column [21]
adrci> help set column
Usage: SET COLUMN TEXT
Purpose: Set the maximum bytes to display for fields with text type.
Arguments:
Examples:
set column text 32
--僅僅定義一個,不能真對特定欄位.
adrci> set column text 60
adrci> select PROBLEM_ID,PROBLEM_KEY,LAST_INCIDENT,LASTINC_TIME from problem;
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ------------------------------------------------------------ -------------------- ----------------------------------------
6 ORA 7445 [qcdlaucn()+201] 112993 2012-09-06 15:59:33.894000 +08:00
7 ORA 1578 918590 2012-11-27 15:39:00.949000 +08:00
3 ORA 600 [510] 91452 2012-05-13 09:34:22.326000 +08:00
4 ORA 7445 [kkeidc()+8755] 103360 2012-07-30 11:06:01.289000 +08:00
5 ORA 7445 [qcstda()+783] 108266 2012-08-21 12:02:25.021000 +08:00
8 ORA 600 [18062] 444191 2012-10-10 15:24:46.238000 +08:00
9 ORA 600 [25027] 321886 2012-09-28 10:32:07.660000 +08:00
10 ORA 7445 [rpidrv()+670] 563059 2012-10-17 15:51:38.496000 +08:00
11 ORA 600 [2162] 678287 2012-11-05 14:40:20.825000 +08:00
12 ORA 7445 [dbgrmqmqpk_query_pick_key()+2033] 825872 2012-11-22 08:06:35.396000 +08:00
13 ORA 25319 922168 2012-11-28 09:07:32.587000 +08:00
14 ORA 445 912352 2012-11-26 10:52:39.822000 +08:00
15 ORA 600 [2662] 920959 2012-11-27 16:18:18.991000 +08:00
16 ORA 603 922003 2012-11-27 16:18:01.916000 +08:00
17 ORA 353 [52739] [3179751789] 923370 2012-11-28 10:08:38.367000 +08:00
18 ORA 353 [18432] [3179742363] 923378 2012-11-28 10:08:40.003000 +08:00
19 ORA 600 [qcdlSynonymTranslation] 941461 2012-12-03 10:53:37.458000 +08:00
17 rows fetched
adrci> delete from problem where problem_id=6;
1 Row Deleted
adrci> show problem
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
19 ORA 600 [qcdlSynonymTranslation] 941461 2012-12-03 10:53:37.458000 +08:00
18 ORA 353 [18432] [3179742363] 923378 2012-11-28 10:08:40.003000 +08:00
17 ORA 353 [52739] [3179751789] 923370 2012-11-28 10:08:38.367000 +08:00
13 ORA 25319 922168 2012-11-28 09:07:32.587000 +08:00
15 ORA 600 [2662] 920959 2012-11-27 16:18:18.991000 +08:00
16 ORA 603 922003 2012-11-27 16:18:01.916000 +08:00
7 ORA 1578 918590 2012-11-27 15:39:00.949000 +08:00
14 ORA 445 912352 2012-11-26 10:52:39.822000 +08:00
12 ORA 7445 [dbgrmqmqpk_query_pick_key()+2033] 825872 2012-11-22 08:06:35.396000 +08:00
11 ORA 600 [2162] 678287 2012-11-05 14:40:20.825000 +08:00
10 ORA 7445 [rpidrv()+670] 563059 2012-10-17 15:51:38.496000 +08:00
8 ORA 600 [18062] 444191 2012-10-10 15:24:46.238000 +08:00
9 ORA 600 [25027] 321886 2012-09-28 10:32:07.660000 +08:00
5 ORA 7445 [qcstda()+783] 108266 2012-08-21 12:02:25.021000 +08:00
4 ORA 7445 [kkeidc()+8755] 103360 2012-07-30 11:06:01.289000 +08:00
3 ORA 600 [510] 91452 2012-05-13 09:34:22.326000 +08:00
16 rows fetched
adrci> ips delete package 4;
Deleted package 4
adrci> ips delete package 5;
Deleted package 5
10.還可以使用select,delete 對incident，problem操作。
$ cd /u01/app/oracle11g/diag/rdbms/test/test/metadata/
$ ls -l
total 7560
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 15:29 ADR_CONTROL.ams
-rw-r----- 1 oracle11g oinstall 40960 Nov 22 2011 ADR_INTERNAL.mif
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 ADR_INVALIDATION.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 AMS_XACTION.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 27 16:18 DDE_USER_ACTION.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 DDE_USER_ACTION_DEF.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 27 16:18 DDE_USER_ACTION_PARAMETER.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 DDE_USER_ACTION_PARAMETER_DEF.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 DDE_USER_INCIDENT_ACTION_MAP.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 DDE_USER_INCIDENT_TYPE.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 EM_DIAG_JOB.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 EM_TARGET_INFO.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 EM_USER_ACTIVITY.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 HM_FDG_SET.ams
-rw-r----- 1 oracle11g oinstall 884736 Dec 5 22:02 HM_FINDING.ams
-rw-r----- 1 oracle11g oinstall 884736 Nov 28 10:31 HM_INFO.ams
-rw-r----- 1 oracle11g oinstall 475136 Nov 28 10:31 HM_MESSAGE.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 9 22:13 HM_RECOMMENDATION.ams
-rw-r----- 1 oracle11g oinstall 1294336 Jan 23 15:32 HM_RUN.ams
-rw-r----- 1 oracle11g oinstall 475136 Dec 3 10:53 INCCKEY.ams
-rw-r----- 1 oracle11g oinstall 475136 Feb 17 14:52 INCIDENT.ams
-rw-r----- 1 oracle11g oinstall 475136 Dec 3 10:53 INCIDENT_FILE.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 14:52 INC_METER_CONFIG.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 INC_METER_IMPT_DEF.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 14:52 INC_METER_INFO.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 INC_METER_PK_IMPTS.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 14:52 INC_METER_SUMMARY.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 IPS_CONFIGURATION.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 IPS_FILE_COPY_LOG.ams
-rw-r----- 1 oracle11g oinstall 475136 Feb 17 15:27 IPS_FILE_METADATA.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 15:40 IPS_PACKAGE.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 15:40 IPS_PACKAGE_FILE.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 15:40 IPS_PACKAGE_HISTORY.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 15:40 IPS_PACKAGE_INCIDENT.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 IPS_PACKAGE_UNPACK_HISTORY.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 IPS_REMOTE_PACKAGE.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 PICKLEERR.ams
-rw-r----- 1 oracle11g oinstall 65536 Feb 17 15:39 PROBLEM.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 SWEEPERR.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 VIEW.ams
-rw-r----- 1 oracle11g oinstall 65536 Nov 22 2011 VIEWCOL.ams
--這些基本都可以按照sql命令來操作,例子:
adrci> select * from INCCKEY where rownum<=10;
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
INCIDENT_ID FLAGS KEY_NAME KEY_VALUE
-------------------- -------------------- ------------------------------------------------------------ ------------------------------------------------------------
123878 3 SID 13.378
123878 3 ProcId 32.183
123878 7 PQ (16777228, 1347595670)
123878 0 Client ProcId oracle@hisdg (TNS V1-V3).4467_182918269152
123879 3 SID 13.378
123879 3 ProcId 32.183
123879 7 PQ (16777216, 1347595675)
123879 0 Client ProcId oracle@hisdg (TNS V1-V3).4467_182918269152
123883 3 SID 13.378
123883 3 ProcId 32.183
10 rows fetched
--另外你還可以建立自己的檢視,例子:
adrci> create view my_control as select SHORTP_POLICY,LONGP_POLICY,LAST_AUTOPRG_TIME,LAST_MANUPRG_TIME from ADR_CONTROL;
View MY_CONTROL Created
adrci> set column text 40
adrci> select * from view;
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
OBJ_ID NAME TEXT CREATION_TIME SCOPE VERSION
-------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- --------------------
1 MY_CONTROL select SHORTP_POLICY,LONGP_POLICY,LAST_A 2013-02-17 15:46:32.664944 +08:00 0 1
1 rows fetched
adrci> select * from my_control;
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
SHORTP_POLICY LONGP_POLICY LAST_AUTOPRG_TIME LAST_MANUPRG_TIME
-------------------- -------------------- ---------------------------------------- ----------------------------------------
360 2190 2012-11-09 22:13:03.850799 +08:00 2012-09-10 09:29:17.716986 +08:00
1 rows fetched
adrci> drop view my_control ;
View my_control Dropped
11.剩下這些
SHOW HM_RUN
SHOW INCDIR
SHOW REPORT
adrci> set home diag/rdbms/test/test
adrci> show incdir
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
diag/rdbms/test/test/incident/incdir_663924/test_ora_17680_i663924.trc
diag/rdbms/test/test/incident/incdir_422591/test_ora_2186_i422591.trc
diag/rdbms/test/test/incident/incdir_519791/test_ora_20154_i519791.trc
diag/rdbms/test/test/incident/incdir_519791/test_m000_20166_i519791_a.trc
diag/rdbms/test/test/incident/incdir_908621/test_ora_19397_i908621.trc
diag/rdbms/test/test/incident/incdir_321805/test_ora_4078_i321805.trc
diag/rdbms/test/test/incident/incdir_920790/test_ora_26196_i920790.trc
diag/rdbms/test/test/incident/incdir_914979/test_ora_2116_i914979.trc
adrci> SHOW HM_RUN
....
**********************************************************
HM RUN RECORD 3870
**********************************************************
RUN_ID 80541
RUN_NAME HM_RUN_80541
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2013-01-23 15:32:44.400621 +08:00
RESUME_TIME
END_TIME 2013-01-23 15:32:44.475197 +08:00
MODIFIED_TIME 2013-01-23 15:32:44.475197 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE
3870 rows fetched
adrci> set browser mozilla
adrci> SHOW REPORT hm_run HM_RUN_80541
--沒有輸出,也沒有呼叫mozilla,不知道為什麼,也許是 REPORT_FILE=的原因.要使用create repoer建立報告先.
adrci> create report hm_run HM_RUN_80541
adrci> show report hm_run HM_RUN_80541
HM Report: HM_RUN_80541
DB Structure Integrity Check
80541
HM_RUN_80541
REACTIVE
COMPLETED
0
0
0
2013-01-23 15:32:44.400621 +08:00
2013-01-23 15:32:44.475197 +08:00
adrci> show hm_run
...
**********************************************************
HM RUN RECORD 3870
**********************************************************
RUN_ID 80541
RUN_NAME HM_RUN_80541
CHECK_NAME DB Structure Integrity Check
NAME_ID 2
MODE 2
START_TIME 2013-01-23 15:32:44.400621 +08:00
RESUME_TIME
END_TIME 2013-01-23 15:32:44.475197 +08:00
MODIFIED_TIME 2013-02-17 16:06:08.290391 +08:00
TIMEOUT 0
FLAGS 0
STATUS 5
SRC_INCIDENT_ID 0
NUM_INCIDENTS 0
ERR_NUMBER 0
REPORT_FILE /u01/app/oracle11g/diag/rdbms/test/test/hm/HMREPORT_HM_RUN_80541.hm
3870 rows fetched
--ok現在REPORT_FILE=/u01/app/oracle11g/diag/rdbms/test/test/hm/HMREPORT_HM_RUN_80541.hm
adrci> set home diag/rdbms/test/test
adrci> select * from hm_run where check_name<>'DB Structure Integrity Check';
DIA-48415: Syntax error found in string [check_name<>] at column [12]
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
0 rows fetched
--居然不能這樣使用.
adrci> set column text 20
adrci> select * from hm_run where check_name!='DB Structure Integrity Check';
ADR Home = /u01/app/oracle11g/diag/rdbms/test/test:
*************************************************************************
RUN_ID RUN_NAME CHECK_NAME NAME_ID MODE START_TIME RESUME_TIME END_TIME MODIFIED_TIME TIMEOUT FLAGS STATUS SRC_INCIDENT_ID NUM_INCIDENTS ERR_NUMBER REPORT_FILE
-------------------- -------------------- -------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -----------
33561 HM_RUN_33561 Data Block Integrity 3 2 2012-09-14 12:07:56.205270 +08:00 2012-09-14 12:07:59.201758 +08:00 2012-09-14 12:07:59.201758 +08:00 0 0 5 123878 0 0
35281 HM_RUN_35281 Data Block Integrity 3 2 2012-10-08 09:40:45.144143 +08:00 2012-10-08 09:40:49.222838 +08:00 2012-10-08 09:40:49.222838 +08:00 0 0 5 368586 0 0
35321 HM_RUN_35321 Data Block Integrity 3 2 2012-10-09 15:29:34.406506 +08:00 2012-10-09 15:29:34.917051 +08:00 2012-10-09 15:29:34.917051 +08:00 0 0 5 408189 0 0
35521 HM_RUN_35521 Data Block Integrity 3 2 2012-10-16 16:34:27.859199 +08:00 2012-10-16 16:34:28.447665 +08:00 2012-10-16 16:34:28.447665 +08:00 0 0 5 519791 0 0
35561 HM_RUN_35561 Data Block Integrity 3 2 2012-10-16 16:53:30.266296 +08:00 2012-10-16 16:53:31.040454 +08:00 2012-10-16 16:53:31.040454 +08:00 0 0 5 527041 0 0
35621 HM_RUN_35621 Data Block Integrity 3 2 2012-10-17 08:31:28.018704 +08:00 2012-10-17 08:31:28.559434 +08:00 2012-10-17 08:31:28.559434 +08:00 0 0 5 537796 0 0
70001 HM_RUN_70001 Data Block Integrity 3 2 2012-11-27 09:15:05.167150 +08:00 2012-11-27 09:15:06.075830 +08:00 2012-11-27 09:15:06.075830 +08:00 0 0 5 914977 0 0
70761 HM_RUN_70761 Data Block Integrity 3 2 2012-11-27 09:58:13.823390 +08:00 2012-11-27 09:58:14.504569 +08:00 2012-11-27 09:58:14.504569 +08:00 0 0 5 916123 0 0
77281 HM_RUN_77281 Data Block Integrity 3 2 2012-11-27 15:39:02.685035 +08:00 2012-11-27 15:39:03.289742 +08:00 2012-11-27 15:39:03.289742 +08:00 0 0 5 918590 0 0
80201 HM_RUN_80201 Redo Integrity Check 4 2 2012-11-28 10:06:45.080614 +08:00 2012-11-28 10:06:46.586871 +08:00 2012-11-28 10:06:46.586871 +08:00 0 0 5 923369 0 0
80221 HM_RUN_80221 Redo Integrity Check 4 2 2012-11-28 10:08:39.827099 +08:00 2012-11-28 10:08:41.225542 +08:00 2012-11-28 10:08:41.225542 +08:00 0 0 5 923370 0 0
11 rows fetched
總結:
其實adrci很好用,並沒有想象的這麼難!
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-754183/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ADRCI命令
- adrci 命令
- 學習筆記：robots.txt檔案筆記
- Oracle工具——ADRCI（三）Oracle
- Oracle工具——ADRCI（二）Oracle
- Oracle工具——ADRCI（一）Oracle
- [20210723]adrci show 'No ADR base is set' 解決辦法.txt
- [20120810]11GR2的flashback database.txtDatabase
- ADRCI基礎知識
- [20150425]tmux學習心得2.txtUX
- 用oracle的ADRCI功能檢視日誌Oracle
- oracle 11g adrci使用Oracle
- [20120830]11G SPM的學習6.txt--第3方優化.txt優化
- [20120805]11G SPM的學習2.txt
- [20190422]學習linux fuser.txtLinux
- [20141225]學習使用tmux心得.txtUX
- [20120808]學習物化檢視.txt
- 使用11G 的ADRCI 清除trace檔案
- 【ADRCI】使用ADRCI (ADR Command Interpreter) 工具檢視Oracle alert警告日誌Oracle
- Oracle 11g ADRCI工具使用Oracle
- [20120324]IOT索引組織表相關資訊的學習(二).txt索引
- [20120806]11G SPM的學習4.txt
- [20120806]11G SPM的學習3.txt
- [20141203]學習使用pidstat.txt
- ADRCI工具的SHOW ALERT TAIL返回過多的結果AI
- [20190213]學習bbed-恢復刪除的資料.txt
- [20120509]IOT索引組織表相關資訊的學習(三).txt索引
- [20120509]IOT索引組織表相關資訊的學習(四).txt索引
- 11g ADRCI清理trace檔案
- [20200208]awk學習例子.txt
- [20121015]探索索引-學習bbed.txt索引
- [20120809]學習物化檢視(補充).txt
- [20121009]學習bbed-恢復刪除的資料.txt
- [20121010]global_name為空的恢復-bbed學習.txt
- [20191128]11GR2 asm例項audit檔案.txtASM
- [20171116]11GR2控制檔案自動備份.txt
- [20130626]11GR2 SQL Tuning Advisor.txtSQL
- [20200224]windows命令學習筆記.txtWindows筆記