Cleanup Oracle Incident using ADRCI


Login ADRCI


[oracle@nomtdb1 NOMT1 incident]$ adrci

ADRCI: Release 11.2.0.3.0 – Production on Fri Sep 28 17:57:06 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

ADR base = “/san/NOMT1/admin”
adrci>

Show registered incidents


adrci> show incidents

ADR Home = /san/NOMT1/admin/diag/rdbms/nomt1/NOMT1:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
——————– ———————————————————– —————————————-
677260 ORA 600 [kwqitnmphe:ltbagi] 2012-09-28 10:58:33.540000 +02:00
677268 ORA 600 [kwqitnmphe:ltbagi] 2012-09-28 11:04:03.369000 +02:00
677284 ORA 600 [kwqitnmphe:ltbagi] 2012-09-28 11:04:44.918000 +02:00
677252 ORA 600 [kwqitnmphe:ltbagi] 2012-09-28 11:06:11.540000 +02:00
681316 ORA 600 [kwqitnmphe:ltbagi] 2012-09-28 11:06:41.763000 +02:00
677004 ORA 600 [kwqitnmphe:ltbagi] 2012-09-28 14:05:48.441000 +02:00
6 rows fetched

Cleanup older then 60 day incidents / events


adrci> purge -age 60 -type incident
adrci> show incidents

ADR Home = /san/NOMT1/admin/diag/rdbms/nomt1/NOMT1:
*************************************************************************
0 rows fetched

adrci>

DIA-48448: This command does not support multiple ADR homes


adrci> purge -age 60 -type incident
DIA-48448: This command does not support multiple ADR homes

adrci> show homes
ADR Homes:
diag/rdbms/nomt1/NOMT1
diag/tnslsnr/nomtdb1/nomt1

adrci> set home diag/rdbms/nomt1/NOMT1
adrci> purge -age 60 -type incident
adrci>