Monitoring Exadata Storage Cells - Oracle Exadata Recipes: A Problem-Solution Approach - page 366

Next, use the following dcli / cellcli command to display alerts generated after a specific time:
[oracle@cm01dbm01 ~]$ dcli -c cm01cel01 \
"cellcli -e list alerthistory where beginTime \> \'2012-10-17T02:00:42-04:00\'"
cm01cel01: 2_1 2012-10-17T05:00:33-04:00 info "The disk controller battery is executing a
.. Output omitted for brevity
cm01cel01: 2_2 2012-10-17T10:22:13-04:00 clear "All disk drives are in WriteBack caching
... Output omitted for brevity
[oracle@cm01dbm01 ~]$
Not ■ please see recipe 13-5 for additional information about using dcli with escape sequences to handle single
quotes and special characters.
Assigning and Dropping Alerts
In organizations with multiple Exadata DMAs and different administration roles and responsibilities, you can
mark specific Exadata alerts with the examinedBy attribute to a specific administrator using the following alter
alerthistory command. In this command, we will set the examinedBy attribute to john for Alert 1 :
CellCLI> alter alerthistory 1 examinedBy='john'
Alert 1 successfully altered
CellCLI>
You can then query your alert history based on specific examinedBy attributes using the following command:
CellCLI> list alerthistory where examinedBy='john'
1 2012-10-10T14:41:37-04:00 info "Factory defaults restored for Adapter 0"
CellCLI>
After clearing or otherwise handling an alert, you can drop the alert from Exadata's alert history using the drop
alerthistory CellCLI command. In this case, we will drop Alert 1 :
CellCLI> drop alerthistory 1
Alert 1 successfully dropped
CellCLI> list alerthistory where examinedBy='john'
To drop alerts across all storage cells, use dcli / cellcli commands. Following, we will use the list
alerthistory command to display alerts with a severity of info and clear and then use this output to drop
the alerts:
[oracle@cm01dbm01 ~]$ dcli -g ./cell_group cellcli -e list alerthistory where severity='info'
attributes name
cm01cel01: 2_1
cm01cel02: 2_1
cm01cel03: 2_1
[oracle@cm01dbm01 ~]$
[oracle@cm01dbm01 ~]$ dcli -g ./cell_group cellcli -e list alerthistory where severity='clear'
attributes name
cm01cel01: 2_2