刪除/disk1_cx300/archlog/ 下超過7的以.dbf結尾的文件
find /disk1_cx300/archlog/ -mtime +7 -name "*.dbf" -exec rm {} \;
刪除在/u01/oracle/oradata/bkdb/arch下比arch_1_2650.log更舊的文件(包括arch_1_2650.log)
find /u01/oracle/oradata/bkdb/arch -type f ! -newer arch_1_2650.log -exec rm {} \;
清除log
crontab -l oracle|grep /apps/oracle/jobs/clear_ora_log.sh
0 * * * 6 /apps/oracle/jobs/clear_ora_log.sh ohub salary > /dev/null 2>&1
root@hrdb # cat /apps/oracle/jobs/clear_ora_log.sh
#!/bin/ksh
#clear oracle logs,include: 1).core dump; 2).udump; 3).network logs
if [ -z "$1" ]
then
echo "Usage: check_alert_log.sh
exit 99
fi
loop=0
while [ $# -ne 0 ]
do
#echo $1
check=`cat /var/opt/oracle/oratab|grep -i "\<$1\>"|wc -l`
tmp=`expr $check` # Convert string to number
if [ $tmp -lt 1 ]
then
echo
echo "Not a valid ORACLE_SID. Retry."
echo
exit 99
fi
ORACLE_SID=$1
HOME=/apps/oracle
ORACLE_HOME=`cat /var/opt/oracle/oratab|grep ^$ORACLE_SID:|cut -f2 -d':'`
UDUMP_DEST=$HOME/admin/$ORACLE_SID/udump
CDUMP_DEST=$HOME/admin/$ORACLE_SID/cdump
export HOME ORACLE_SID ORACLE_HOME UDUMP_DEST
#1.clear core dump
cd $ORACLE_HOME/dbs
rm -rf core_*
cd $CDUMP_DEST
rm -rf core_*
#2). clear udump
cd $UDUMP_DEST
find . -name "*.trc" -ctime +3 -print|xargs rm -f
#3). clear network log
cd $ORACLE_HOME/network/log
>listener.log
>sqlnet.log
shift
done
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8203880/viewspace-310330/ ,如需转载,请注明出处,否则将追究法律责任。