Oracle 11g files housekeeping methods
Since Oracle Database 11g, all traces, incident dumps and packages, the alert log, Health Monitor reports, core dumps, and more files are stored in the ADR, a file-based Automatic Diagnostic Repository for simplified database diagnostic data management. However housekeeping or purging of those files got not simplified. Unfortunately the new Oracle utility ADRCI can not purge all the files Oracle database generates in ADR. Thus, you should use the other OS tools to accomplish the same. Below I list common Oracle files that must be cleaned periodically with associated housekeeping methods I usually use on Linux servers.
– Linux log rotate mechanism used
– alert.log, listener.log, backup logs and any other log files affected
– Files are purged and zipped for archiving purpose
Read more about Oracle database housekeeping using Unix logrotate mechanism.
– Linux crontab utility with shell scripting used
– Oracle SYS Operations Auditing files (*.aud files) affected
– Files are deleted based on number of copies
– Linux crontab utility with Oracle ADRCI tool used
– ADR related incidents, dumps, reports and traces, xml files (ADRCI can not modify Text-formatted files) affected
In the next posts I’ll show how to accomplish all 3 steps of Oracle database 11g file housekeeping.