Customized, retention and auto-purging of files.
Dear Experts, could you please share your insights on how to enable and make use of ADRCI for customized retention and Auto-purge of Sump, Trace, xml.log files, etc?
It seems currently ADRCI is disabled as one of our dev database servers is having .trc file accumulated for over a year and the ask is -
1) How can we diagnose and troubleshoot the issue?
2) How can we use and leverage the ADRCI to work to run purge activities based on the retention period that we specify?
3) Is it recommended to use ADRCI for purging purposes and what are the recommended best practices with regard to setting up the policies?