adr_cleanup.ksh 1.1 KB

123456789101112131415161718192021222324252627282930313233343536
  1. #!/bin/ksh
  2. # Richard Wilson - 30.03.2014
  3. # Automatic Diagnostic Repository Cleanup.a
  4. # Hint: 7 days for trace and dump files, 1 month for the others.
  5. # ---------------------------------------------------------------------------------------------------------------
  6. export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
  7. set -A HOMES "systst3/SYSTST3" "systst4/SYSTST4" "sit3/SIT3" "sit4/SIT4" "uat3/UAT3" "uat4/UAT4" "train2/TRAIN2" "pack3/PACK3"
  8. idx=0
  9. days_90=129600
  10. days_60=86400
  11. days_30=43200
  12. days_21=30240
  13. days_14=20160
  14. days_10=14400
  15. days_7=10080
  16. days_5=7200
  17. while [ ${idx} -lt ${#HOMES[@]} ]
  18. do
  19. ${ORACLE_HOME}/bin/adrci <<- EOF
  20. # set homepath diag/rdbms/${HOMES[${idx}]}
  21. set home diag/rdbms/${HOMES[${idx}]}
  22. purge -age ${days_21} -type ALERT;
  23. purge -age ${days_14} -type CDUMP;
  24. purge -age ${days_21} -type INCIDENT;
  25. purge -age ${days_21} -type HM;
  26. purge -age ${days_14} -type TRACE;
  27. purge -age ${days_21} -type UTSCDMP;
  28. EOF
  29. (( idx+=1 ))
  30. done
  31. # ---------------------------------------------------------------------------------------------------------------