自动清理oracle的归档日志、alert日志、监听日志、审计日志脚本

AugustJin

954

2页

15次

2022-04-15

10墨值下载

自动清理 oracle 的归档日志、alert 日志、监听日志、审计日志脚本。

#crontab

30 8 * * * /ora/u01/scripts/clean_log.sh > /dev/null 2>&1

#######################################################################

################archive log

#!/bin/bash

. /home/oracle/.bash_profile

# --------------------

# every day archivelog about 400G

# --------------------

export ORACLE_SID=ORCL

$ORACLE_HOME/bin/rman log=/oracle/archlog/ORCL/clean.log <<EOF

connect target /

run{

crosscheck archivelog all;

delete noprompt expired archivelog all;

delete noprompt archivelog all completed before 'sysdate - 3';

}

exit;

EOF

#################arlert log

#!/bin/bash

#---------------------

#alert about 30m every month

#---------------------

cd ${ORACLE_BASE}/diag/rdbms/ORCL/$ORACLE_SID/trace

export SIZE=`du -m alert_${ORACLE_SID}.log | cut -f1`

if [ ${SIZE} -ge 30 ]; then

# cp alert_${ORACLE_SID}.log /oracle/rmanbackup/oracle_log/alert/alert_$

{ORACLE_SID}_`date +%Y%m%d%H%M%S`.log

cp alert_${ORACLE_SID}.log /oracle/rmanbackup/oracle_log/alert/alert_$

{ORACLE_SID}_`date +%Y%m%d%H%M%S`.log

# cat /dev/null > alert_${ORACLE_SID}.log

truncate -s 0 alert_${ORACLE_SID}.log

find . -mtime +30 -name "*.trc" | xargs rm -rf

find . -mtime +30 -name "*.trm" | xargs rm -rf

#################listener log

#!/bin/bash

#---------------------

#listener.log about 100m every 8 month,listener.xml about 200m every month

#---------------------

cd $ORACLE_BASE/diag/tnslsnr/`hostname`/listener/trace

export SIZE=`du -m listener.log | cut -f1`

if [ $SIZE -ge 100 ]; then

# lsnrctl set log_status off

# mv listener.log /oracle/rmanbackup/oracle_log/listener/listener_`date +%Y%m%d

%H%M%S`.log

cp listener.log /oracle/rmanbackup/oracle_log/listener/listener_`date +%Y%m%d

%H%M%S`.log

truncate -s 0 listener.log

# lsnrctl set log_status on

cd $ORACLE_BASE/diag/tnslsnr/`hostname`/listener_orcl/alert

find . -mtime +30 -name "log_*.xml" | xargs rm -rf

#################audit log

#!/bin/bash

#---------------------

#audit log about 2GB every month,but aud$ table will exist system

tablespace,please noted

#---------------------

cd $ORACLE_HOME/rdbms/audit

find . -mtime +30 -exec mv {} /oracle/rmanbackup/oracle_log/audit \;

exit

of 2

10墨值下载

日志

关注

评论