定期清理Oracle DB产生的log 文件, 脚本如下.
sid_list=`/bin/ps -ef |/bin/grep smon |/bin/grep -v grep | /bin/cut -f3 -d_`
host_name=`hostname`
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/admin
#dumpfile tracefile incident listener
for sid in $sid_list;
do
export ORACLE_SID=$sid;
l_sid=`tr ‘[A-Z]‘ ‘[a-z]‘ <<
u_sid=`tr ‘[a-z]‘ ‘[A-Z]‘ <<
/usr/bin/find /oracle/admin/$sid/adump -mtime +7 -name "*.aud"|xargs rm -f
if [ $l_sid == $sid ];
then
/usr/bin/find /oracle/diag/rdbms/$l_sid/$l_sid/trace -mtime +7 -name "*.trc"|xargs rm -f
/usr/bin/find /oracle/diag/rdbms/$l_sid/$l_sid/trace -mtime +7 -name "*.trm"|xargs rm -f
/usr/bin/find /oracle/diag/rdbms/$l_sid/$l_sid/incident -mtime +7 -name "incdir*"|xargs rm -rf
/usr/bin/find /oracle/diag/rdbms/$l_sid/$l_sid/alert -mtime +7 -name "log*.xml"|xargs rm -rf
else
/usr/bin/find /oracle/diag/rdbms/$l_sid/$u_sid/trace -mtime +7 -name "*.trc"|xargs rm -f
/usr/bin/find /oracle/diag/rdbms/$l_sid/$u_sid/trace -mtime +7 -name "*.trm"|xargs rm -f
/usr/bin/find /oracle/diag/rdbms/$l_sid/$u_sid/incident -mtime +7 -name "incdir*"|xargs rm -rf
/usr/bin/find /oracle/diag/rdbms/$l_sid/$u_sid/alert -mtime +7 -name "log*.xml"|xargs rm -rf
fi
/usr/bin/find /oracle/diag/tnslsnr/$host_name/listener_$l_sid/alert/* -mtime +7 -name "log*.xml"|xargs rm -rf
/usr/bin/find /oracle/diag/tnslsnr/$host_name/listener_$l_sid/incident/* -mtime +7 -name "incdir*"|xargs rm -rf
/usr/bin/find /oracle/diag/tnslsnr/$host_name/listener_$l_sid/trace/* -mtime +7 -name "*.trc"|xargs rm -f
/usr/bin/find /oracle/diag/tnslsnr/$host_name/listener_$l_sid/trace/* -mtime +7 -name "*.trm"|xargs rm -f
/usr/bin/find /oracle/diag/tnslsnr/$host_name/listener_$l_sid/trace/* -mtime +7 -name "listener_$l_sid*.log"|xargs rm -f
done
原文:http://www.cnblogs.com/heric/p/6362528.html