Clean *.trc ,*.trm and *.aud older than 1 day clean oracle home

Clean *.trc ,*.trm and *.aud older than 1 day clean oracle home

#!/bin/bash

. /home/oracle/.bash_profile

export log=/u01/app/oracle/shells/clean_rdbms_audit.log

echo $ORACLE_HOME | tee $log
echo “DELETING AUDIT LOGS FROM RDBMS” | tee -a $log
date | tee -a $log
df -m $ORACLE_HOME | tee -a $log
/bin/find /u01/app/oracle/ -type f -name “*.trc” -mtime +1 -exec rm {} \;
find $ORACLE_BASE/admin -type f -name “*.aud” -mtime +5 -exec rm {} \;
find $ORACLE_BASE/diag/rdbms -type f -name “*.trc” -mtime +1 -exec rm {} \;
find $ORACLE_BASE/diag/rdbms -type f -name “*.trm” -mtime +1 -exec rm {} \;
find $ORACLE_BASE/diag/rdbms -name “*_lmhb_*.tr?” -exec rm {} \;
sleep 10
df -m $ORACLE_HOME | tee -a $log
echo “END OF DELETING AUDIT LOGS” | tee -a $log
date |tee -a $log
exit 0;

About the Author

debasis maity

12+ years of rich experience on Database Administrations and on Infrastructure Solution Architect. AWS Certified Solution Architect and Senior Oracle DBA