adrci> help show alert
Usage: SHOW ALERT [-p
] [-term] [ [-tail [num] [-f]] | [-file
] ] Purpose: Show alert messages.
Options:
[-p
]: The predicate string must be double quoted. The fields in the predicate are the fields:
ORIGINATING_TIMESTAMP timestamp
NORMALIZED_TIMESTAMP timestamp
ORGANIZATION_ID text(65)
COMPONENT_ID text(65)
HOST_ID text(65)
HOST_ADDRESS text(17)
MESSAGE_TYPE number
MESSAGE_LEVEL number
MESSAGE_ID text(65)
MESSAGE_GROUP text(65)
CLIENT_ID text(65)
MODULE_ID text(65)
PROCESS_ID text(33)
THREAD_ID text(65)
USER_ID text(65)
INSTANCE_ID text(65)
DETAILED_LOCATION text(161)
UPSTREAM_COMP_ID text(101)
DOWNSTREAM_COMP_ID text(101)
EXECUTION_CONTEXT_ID text(101)
EXECUTION_CONTEXT_SEQUENCE number
ERROR_INSTANCE_ID number
ERROR_INSTANCE_SEQUENCE number
MESSAGE_TEXT text(2049)
MESSAGE_ARGUMENTS text(129)
SUPPLEMENTAL_ATTRIBUTES text(129)
SUPPLEMENTAL_DETAILS text(129)
PROBLEM_KEY text(65)
[-tail [num] [-f]]: Output last part of the alert messages and
output latest messages as the alert log grows. If num is not specified,
the last 10 messages are displayed. If "-f" is specified, new data
will append at the end as new alert messages are generated.
[-term]: Direct results to terminal. If this option is not specified,
the results will be open in an editor.
By default, it will open in emacs, but "set editor" can be used
to set other editors.
[-file
]: Allow users to specify an alert file which may not be in ADR.
must be specified with full path. Note that this option cannot be used with the -tail option
Examples:
show alert
show alert -p "message_text like '%incident%'"
show alert -tail 20
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> show alert
● 列出跟踪文件
adrci> show tracefile
● 查看意外事件(列出ORA事件)
adrci> show incident
想深入查看某个事件,
adrci> show incident -mode detail -p "incident_id=113769"
adrci> set homepath diag/rdbms/orcl/ORCL
adrci> describe incident
Name Type NULL?
----------------------------- --------------- -----------
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
ERROR_ARG9 text(64)
ERROR_ARG10 text(64)
ERROR_ARG11 text(64)
ERROR_ARG12 text(64)
在创建一个意外事件包时,可以在包中添加一个或多个问题,然后,Support Workbench将自动添加这些问题的跟踪文件和转储文件。
默认情况下,每个意外事件包只包含每个问题的前3个或后3个意外事件。
(1) ips create package命令建立一个新逻辑包,表示不用指定意外事件或时间间隔
adrci> ips create package
Created package 1 without any contents, correlation level typical
(2) 添加诊断信息
adrci> ips add incident 113769 package 1;
adrci> ips add incident 113769 package 1;
DIA-49431: No such incident [113769]
(3) 生成物理包
adrci> ips generate package 1 in /u01/app/oracle/adrci/support
上面的命令生成ZIP文件,可以发送给Oracle Support用于诊断支持
IPS命令的变化
ips create package 创建一个空包
ips create package problem 基于某个问题ID创建一个包
ips create package problem key 创建一个基于问题键的包
ips create package incident 基于某个意外事件ID创建一个包
ips create package time 创建特定时间范围的一个包
可利用adrci工具配置各种内容,如配置意外事件的元数据保留期等。
adrci> ips show configuration
PARAMETER INFORMATION:
PARAMETER_ID 1
NAME CUTOFF_TIME
DESCRIPTION Maximum age for an incident to be considered for inclusion
UNIT Days
VALUE 90
DEFAULT_VALUE 90
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 2
NAME NUM_EARLY_INCIDENTS
DESCRIPTION How many incidents to get in the early part of the range
UNIT Number
VALUE 3
DEFAULT_VALUE 3
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 3
NAME NUM_LATE_INCIDENTS
DESCRIPTION How many incidents to get in the late part of the range
UNIT Number
VALUE 3
DEFAULT_VALUE 3
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 4
NAME INCIDENT_TIME_WINDOW
DESCRIPTION Incidents this close to each other are considered correlated
UNIT Minutes
VALUE 5
DEFAULT_VALUE 5
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 5
NAME PACKAGE_TIME_WINDOW
DESCRIPTION Time window for content inclusion is from x hours before first included incident to x hours after last incident
UNIT Hours
VALUE 24
DEFAULT_VALUE 24
MINIMUM 1
MAXIMUM 4294967295
FLAGS 0
PARAMETER INFORMATION:
PARAMETER_ID 6
NAME DEFAULT_CORRELATION_LEVEL
DESCRIPTION Default correlation level for packages
UNIT Number
VALUE 2
DEFAULT_VALUE 2
MINIMUM 1
MAXIMUM 4
FLAGS 0
阅读(1200) | 评论(1) | 转发(0) |