Housekeeping of logs , traces, diag directories is every DBA’s job and some may write their own , some adopt from others which is common.
Often we found in our environments similar sort of scripts placed, which I found mostly were
Non Pluggable to any new environments
- You cannot port it to others or outside since there is dependency of some other functions etc
- Not easy to manage or scale if you want to add more
- Not easier to understand even.
Trust me I came across at least more than five environments which are having either too big complex scripts or none.
- For those, who want a simple way of achieving this , I suggest to read this document and place in your environment, of course with
adrci ( I will add that one too soon)
- this is not use any more.
Download:- Housekeeping Shell Script
Hope this helps.
Thanks
Geek DBA
Great blog, great script. Runs thoroughly to any logs generated by database and clusterware.
Hello Olie,
Thanks for your nice comments, and visiting here.
-Geek DBA