Wednesday, May 07, 2014

Adrci Show Alert Hung

Sometimes alert log of DB is too large.  We may mv , rm  or vi them to make it smaller
However it may affect format the alert logs, adrci  show alert may hung due to bad format
We can use purge commend of adrci to fix it.  It's side effect of the purge command.

ADR Homes:
diag/rdbms/cmru/test1
adrci> set home diag/rdbms/test/test1
adrci> PURGE -age 1440 -type ALERT