oracle----删除归档、清理日志、杀oracle进程脚本

删除trc文件:

ls -lrt|grep trc|head -150|awk '{print $8}'|xargs rm
ls -lrt *.trc|head -10|awk '{print $9}'|xargs rm

删除归档文件:

ls -lrt|head -10|awk '{print $9}'|xargs rm

archPath=/arch${1}
archPercent=`df -g|grep ${archPath}|awk '{print $4}'|sed 's/%//g'`
echo $(date)=${archPercent}%
cd $archPath
if [ ${archPercent} -gt 40 ] ; then
ls -ltr *.arc|head -30|awk '{print $9}'|xargs rm
echo "archivelog deleted at "$(date)
fi

删除监听日志文件:
tail -1000 listener.log>listener.log

log_file_dir=/oracle/product/9.2.0/network/log/
log_size_m=`du -sm $log_file_dir/listener.log|awk '{ print $1}'`
echo $(date)=${log_size_m}
cd $log_file_dir
if [ ${log_size_m} -gt 500 ] ; then
>listener.log
fi

杀oracle连接进程:
ps -ef|grep LOCAL=NO|awk '{print $2}'|xargs kill -9

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26078027/viewspace-1052782/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26078027/viewspace-1052782/