ADRCI - changing the retention time for trace/alert files from the defaults

To implement a new purging policy for trace files etc

 [oracle@server]:DB:[~]# adrci
ADRCI: Release 11.2.0.3.0 - Production on Fri May 10 13:40:25 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
ADR base = "/oracle"
adrci> set home diag/rdbms/emza3/DB
adrci> select SHORTP_POLICY,LONGP_POLICY from ADR_CONTROL;

ADR Home = /oracle/diag/rdbms/emza3/EMZA3:
*************************************************************************
SHORTP_POLICY        LONGP_POLICY
-------------------- --------------------
720                  8760
1 rows fetched

So currently retention is default 720 hours for short policy and 8760 hours for long policy – definitions of which file types are attached to which policy are defined here:

http://docs.oracle.com/cd/E11882_01/server.112/e22490/adrci.htm#BGBGFEJE

To change the retention policy we run the following:

adrci>
adrci> set control (SHORTP_POLICY=168);

We then manually purge to not have to wait for the auto purge to kick in

adrci> purge

The automatic purging currently runs on this schedule (which currently cannot be changed), initially is 2 days after instance startup and then every 7 days after that. Purging is done by the mmon process.


Comments

  1. Paul Alsemgeest23 July 2013 at 01:51

    Hi,
    Where did you find that the schedule is started after 2 days??
    Thanks.

    ReplyDelete
    Replies
    1. DBAHarrison23 July 2013 at 02:13

      Hi Paul,
      I couldn't find the original document i found this in - it's disappeared somewhere into the ether - but I did find an oracle support reference which discusses this:

      1446242.1


      Cheers,
      Rich

      Delete

Post a Comment