oracle alert日志每天截断truncate_alert.sh

[oracle@shanxi ORCL]$ cat /home/oracle/admin/truncate_alert.sh

#!/bin/bash

# Filename: truncate_alert.sh

# Date: 2012-10-31

# Version: 1.0

# Author: chi

# Desc: turncate the alert_.log every day

. /home/oracle/.bash_profile

# if database is open , the variable flag will not be empty 

flag=`ps -ef | grep ora_ | grep -v 'grep'`

if [ -z  "$flag" ] ; then

        exit

fi

BDUMP_DIR=`sqlplus -S / as sysdba<

set echo off pagesize 0 feedback off termout off;

select value from v\\$parameter where name='background_dump_dest';

exit

EOF`

# BDUMP_DIR will be error hen database  is closed

 

YESTER=`date -d '1 day ago' +%Y%m%d`

cd $BDUMP_DIR

cat alert_${ORACLE_SID}.log > alert_${ORACLE_SID}_${YESTER}.log

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

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

转载于:http://blog.itpub.net/27042095/viewspace-750056/