Automatically and Manual Purging Alert Log and Trace files with Automatic Diagnostic Repository Command Interpreter (ADRCI)

Sometimes we are facing with space related issues due to the huge number of trace file generation. Automatic purging can help us in this situations if set short retention time for trace files.

adrci> show homes
ADR Homes:
diag/tnslsnr/GMCLIMODA01N2PLP/listener_scan2
diag/tnslsnr/GMCLIMODA01N2PLP/asmnet1lsnr_asm
diag/tnslsnr/GMCLIMODA01N2PLP/mgmtlsnr
diag/tnslsnr/GMCLIMODA01N2PLP/asmnet2lsnr_asm
diag/tnslsnr/GMCLIMODA01N2PLP/listener_scan1
diag/tnslsnr/GMCLIMODA01N2PLP/listener
diag/apx/+apx/+APX2
diag/crs/gmclimoda01n2plp/crs
diag/crs/172/crs
diag/asm/+asm/+ASM2
diag/rdbms/_mgmtdb/-MGMTDB

adrci>

adrci> set homepath diag/tnslsnr/GMCLIMODA01N2PLP/asmnet1lsnr_asm

adrci> show control

ADR Home = /u01/app/grid/diag/tnslsnr/GMCLIMODA01N2PLP/asmnet1lsnr_asm:

*************************************************************************

ADRID                SHORTP_POLICY        LONGP_POLICY         LAST_MOD_TIME                            LAST_AUTOPRG_TIME                        LAST_MANUPRG_TIME                        ADRDIR_VERSION       ADRSCHM_VERSION      ADRSCHMV_SUMMARY     ADRALERT_VERSION     CREATE_TIME

-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------

2978292604           720                  8760                 2015-08-13 16:48:09.227855 +02:00                                                 2017-12-24 05:00:02.312601 +01:00        1                    2                    82                   1                    2015-08-13 16:48:09.227855 +02:00

1 rows fetched

adrci>

adrci> select SHORTP_POLICY,LONGP_POLICY from ADR_CONTROL;

ADR Home = /u01/app/oracle/diag/rdbms/db12c_stby/db12c_stby:
*************************************************************************
SHORTP_POLICY        LONGP_POLICY         
-------------------- -------------------- 
720                  8760                
1 rows fetched

1. By default retention is 720 hours for short policy and 8760 hours for long policy.
   Short policy include the following files :(Trace files, Core dump files, Packaging information)
   Long policy include the following files:(Incident information, Incident dumps, Alert logs)
2. To change the retention policy :

adrci> set control (SHORTP_POLICY=120); -- 5 days

adrci> set control (LONGP_POLICY=720); -- 1 week


--check changes

adrci> select SHORTP_POLICY,LONGP_POLICY,LAST_AUTOPRG_TIME,LAST_MANUPRG_TIME from ADR_CONTROL; 

ADR Home = /u01/app/oracle/diag/rdbms/db12c_stby/db12c_stby:
*************************************************************************
SHORTP_POLICY LONGP_POLICY LAST_AUTOPRG_TIME LAST_MANUPRG_TIME 
-------------------- -------------------- ---------------------------------------- ---------------------------------------- 
120 720 2016-07-07 23:27:37.789953 +05:00 2016-07-16 22:37:52.700123 +05:00 
1 rows fetched

adrci> 

purger l'alert log d'une base on line :
dans l'exemple ici la taille de l'alert log est de 4G :
cat alert_oibko121.log |gzip > alert_oibko121.log.20180129.gz; echo > alert_oibko121.log

résultat :

4.0K    alert_oibko121.log

53M     alert_oibko121.log.20180129.gz

24K     oibko121_cjq0_11163.trc