Automatically purging
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.
- Type show homes to see current homes supported by ADRCI and set homepath.
adrci> show homes ADR Homes: diag/rdbms/test/test diag/rdbms/test/test diag/rdbms/test/test diag/tnslsnr/Standby/listener diag/clients/user_oracle/host_24366794132_82 adrci> set homepath diag/rdbms/test/test
- The automatic purging runs on schedule defined in retention policy .To check current policy for home, we can use two methods :
adrci> show control ADR Home = /u01/app/oracle/diag/rdbms/test/test: ************************************************************************* ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME -------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ---------------------------------------- 3514698554 720 8760 2016-05-31 00:54:57.566484 +05:00 2016-07-07 23:27:37.789953 +05:00 1 2 82 1 2016-05-31 00:54:57.566484 +05:00 1 rows fetched
or
adrci> select SHORTP_POLICY,LONGP_POLICY from ADR_CONTROL; ADR Home = /u01/app/oracle/diag/rdbms/test/test: ************************************************************************* SHORTP_POLICY LONGP_POLICY -------------------- -------------------- 720 8760 1 rows fetched
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) - To change the retention policy :
adrci> set control (SHORTP_POLICY=120); -- 5 days adrci> set control (LONGP_POLICY=720); -- 30 days --check changes adrci> select SHORTP_POLICY,LONGP_POLICY,LAST_AUTOPRG_TIME,LAST_MANUPRG_TIME from ADR_CONTROL; ADR Home = /u01/app/oracle/diag/rdbms/test/test: ************************************************************************* 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>
Initially automatic purging runs 2 days after instance startup, then by policy defined interval.
Manual purging
- Type show homes to see current homes supported by ADRCI and set homepath.
[oracle@MAINDB ~]$ adrci ADRCI: Release 12.1.0.2.0 - Production on Tue Feb 23 19:18:42 2016 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> show homes ADR Homes: diag/tnslsnr/test/listener diag/rdbms/cdb1/cdb1 adrci> set homepath diag/rdbms/cdb1/cdb1
- To purge diagnostic data that is older than the amount of time (minutes) given in the purge command. For ex to purge diagnostic data that is over 1 day old (1440 minutes).
adrci> PURGE -age 1440 -type ALERT --You can also pruge TRACE files with same method: adrci> PURGE -age 1440 -type TRACE
- To remove all data older than one minute use:
adrci> PURGE -age 1 -type ALERT adrci> SHOW ALERT ADR Home = /u01/app/oracle/diag/rdbms/cdb1/cdb1: ************************************************************************* No alert log in selected home adrci> exit