[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/，如需轉載，請註明出處，否則將追究法律責任。

oracle alert日誌每天截斷truncate_alert.sh

相關文章