Hello,
My group is looking in to using ADRCI to maintain our trace, incident, alert, etc files to eliminate the batch jobs that we currently have. Using a test environment I changed the shortp_policy to 24 and the longp_policy to 48. Yes, the ADR Home is pointing to this specific region.
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
3151890115 24 48 2019-10-18 06:41:53.490726 -06:00 2019-10-29 08:45:36.469549 -04:00 2019-10-23 06:26:46.082208 -06:00 1 2 107 1 2015-07-10 11:39:47.211765 -06:00
It appears that the trace files are being purged successfully as I only have 2 days worth of files. I would assume this is the same for incident files, but none are really generated on this system.
What I can't figure out is how ADRCI maintaines both versions of the alert logs, the regular one and the xml.log. Both files continue to grow and have over 48 hours worth of data. Can anyone shed some light on how ADRCI manages these files?
We are running Oracle 12.2 on HP-UX. We are current with our patchsets.
Thanks,
Harry