oracle日志分割-purge_logs

最新推荐文章于 2022-09-28 14:01:09 发布

congyun2180

最新推荐文章于 2022-09-28 14:01:09 发布

阅读量383

点赞数

文章标签：数据库

[xszntsnoradb@oracle:/u01/app/oracle/admin/VPETEST/bdump] cat /home/oracle/scripts/purge_logs
#!/usr/bin/env ksh

###########################################################################
#
# script : purge_logs
# auteur : philippe CATHERINE
# objet   : purge des fichiers de logs oracle 'superflus'
#
# version : v1.2
# sortie : ($?) 0 => OK   1 => KO
#
# A noter que ce la retention peut etre adaptée selon les besoins
# (variables RETENTION_TRACES & RETENTION_ALERTLOG)
#
###########################################################################
#set -x #set -e

# Check if oratab exists
if [[ -r "/var/opt/oracle/oratab" ]]; then
        RATAB=/var/opt/oracle/oratab
elif [[ -r "/etc/oratab" ]]; then
        RATAB=/etc/oratab
else
        echo ""; echo " !! File ${ORATAB} missing...."; echo ""
        return 1
fi

RETENTION_TRACES='2'
RETENTION_ALERTLOG='5'
DATE=`date +'%d%m%y'`

cat ${ORATAB}|grep -v "#"|grep ":Y" |awk -F: '{print $1" "$2}'| while read ORACLE_SID ORACLE_HOME; do
        ## Suppression des traces du listener
        cp /var/opt/oracle/lsnrdump/LSN_${ORACLE_SID}.log /var/opt/oracle/lsnrdump/LSN_${ORACLE_SID}.${DATE}.log
        cat /dev/null > /var/opt/oracle/lsnrdump/LSN_${ORACLE_SID}.log
        find /var/opt/oracle/lsnrdump -name "LSN_*.log" -mtime +${RETENTION_TRACES} -print -exec rm -f {} \;
        ## Suppression des fichiers aud
        find /u01/app/oracle/admin/${ORACLE_SID}/adump -name "*.aud" -mtime +${RETENTION_TRACES} -print -exec rm -f {} \;
        find ${ORACLE_HOME}/rdbms/audit -name "*.aud" -mtime +${RETENTION_TRACES} -print -exec rm -f {} \;
        ## Suppression des fichiers trace (9i)
        find ${ORACLE_HOME}/rdbms/log -name "*.trc" -mtime +${RETENTION_TRACES} -print -exec rm -f {} \;
        ## Suppression des fichiers trace
        find /u01/app/oracle/admin/${ORACLE_SID}/bdump -name "*.trc" -mtime +${RETENTION_TRACES} -print -exec rm -f {} \;
        ## Suppression des fichiers alertlog
        cp /u01/app/oracle/admin/${ORACLE_SID}/bdump/alert_${ORACLE_SID}.log /u01/app/oracle/admin/${ORACLE_SID}/bdump/alert_${ORACLE_SID}.${DATE}.log
        cat /dev/null > /u01/app/oracle/admin/${ORACLE_SID}/bdump/alert_${ORACLE_SID}.log
        find /u01/app/oracle/admin/${ORACLE_SID}/bdump -name "alert_*.log" -mtime +${RETENTION_ALERTLOG} -print -exec rm -f {} \;
done

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

转载于:http://blog.itpub.net/12137615/viewspace-677544/