7.7.12.3 LIST ALERTHISTORY
Purpose
The LIST ALERTHISTORY
command displays all alerts that occurred on the cell.
Syntax
LIST ALERTHISTORY [ name | attribute_filters ] [attribute_list] [DETAIL]
Usage Notes
-
You can use the DESCRIBE ALERTHISTORY command to view the complete list of
ALERTHISTORY
attributes. -
A
WHERE
clause can include theageInMInutes
attribute to specify that the output is limited to those alerts that have the specified age. For example, the following command would show the alerts created in the previous 15 minutes:
CellCLI> LIST ALERTHISTORY WHERE ageInMinutes < 15
Examples
Example 7-148 shows the LIST
command with the ALERTHISTORY
object.
Example 7-149 shows open stateful and stateless alerts.
Example 7-150 shows only open stateful alerts. The closed stateful alerts are filtered out.
Example 7-151 shows alerts that have not been cleared.
Example 7-148 Listing ALERTHISTORY Attributes
CellCLI> LIST ALERTHISTORY 1671443714 DETAIL
name: 1671443714
alertSequenceID: 1671443714
sequenceBeginTime: 1179185707672
beginTime: "Sat May 18 10:14:16 PDT 2009"
endTime: "Sat May 25 10:14:16 PDT 2009"
severity: critical
alertMessage: "Errors in file svtrc_2840_10.trc (incident=13):"
alertShortName: ADR
alertNotified: 0
examinedBy: johndoe
alertType: stateless
CellCLI> LIST ALERTHISTORY WHERE begintime > 'Jun 1, 2009 11:37:00 AM PDT'
39 2009-10-02T12:26:53-07:00 "ORA-07445: exception
encountered: core dump [__kerne l_vsyscall()+5] [6]
[0x408C] [] [] []"
40 2009-10-06T23:28:06-07:00 "RS-7445 [unknown_function]
[signum: 6] [] [] [] [] [ ] []"
41 2009-10-07T00:50:42-07:00 "RS-7445 [Serv MS not responding]
[It will be restart ed] [] [] [] [] [] []"
42 2009-10-07T02:21:19-07:00 "RS-7445 [unknown_function]
[signum: 6] [] [] [] [] [ ] []"
CellCLI> LIST ALERTHISTORY 7 DETAIL
name: 7
alertMessage: "Flash cache mode is set to WriteBack because
there is dirty data in the flash cache."
alertSequenceID: 7
alertShortName: Software
alertType: Stateless
beginTime: 2012-09-10T13:22:38-07:00
examinedBy:
metricObjectName: FlashCache
notificationState: 0
sequenceBeginTime: 2012-09-10T13:22:38-07:00
severity: info
alertAction: "If the newly-assigned mode for flash cache is
not wanted, then change it using the ALTER CELL
command as described in the Oracle Exadata user's
guide."
Example 7-149 Listing Open Stateful and Stateless Alerts
CellCLI> LIST ALERTHISTORY ATTRIBUTES alertsequenceid,name,alerttype \
WHERE endtime=null
1 1 Stateless
3 3 Stateless
11 11_1 Stateful
Example 7-150 Listing Open Stateful Alerts
CellCLI> LIST ALERTHISTORY WHERE endtime=null AND alerttype=stateful
Example 7-151 Listing Alerts That Have Not Cleared
CellCLI> LIST ALERTHISTORY WHERE endtime=null
1 2014-11-11T11:08:15-08:00 info "Factory defaults restored for
Adapter 0"
3 2014-11-11T11:27:06-08:00 critical "RS-700 [No IP found in Exadata
config file] [Check cellinit.ora]
[] [] [] [] [] [] [] [] [] []"
11_1 2014-12-19T12:01:06-08:00 critical "The HDD disk controller battery
has failed. All disk drives have been placed in WriteThrough caching mode. Disk
write performance may be reduced. The flash drives are not affected. Battery
Serial Number : 1142 Battery Type : ibbu08 Battery Temperature : 39
C Full Charge Capacity : 773 mAh Relative Charge : 83% Ambient
Temperature : 32 C"
Parent topic: LIST