Purging Oracle Database's Alert Log with ADRCI

Purging Oracle Database's Alert Log with ADRCI

Step 1 Set oraenv

Step 2
==============
oracle-<DBNAME>@darvel /u01/app/oracle # adrci

ADRCI: Release 11.2.0.2.0 - Production on Tue Jul 23 15:25:00 2013

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

ADR base = "/u01/app/oracle"
adrci>

step 3

=============

adrci> show homes

ADR Homes:

diag/tnslsnr/darvel/11

diag/tnslsnr/darvel/listener_11

Step 4:

===============

adrci> set homepath diag/tnslsnr/darvel/11

adrci>

Step 5:

=======================

adrci> show alert –tail

Step 6:

=======================

Purge diagnostic data that is over 1 day old (1440 minutes)

adrci> PURGE -age 1440 -type ALERT