alert告警日志管理:
路径 /u01/app/oracle/diag/rdbms/orcl/orcl/trace/
将alert log 按天存放,每天一个alert log 文件
[oracle@ijx ~]$ cat alertlog_byday.sh
#############################
# alertlog_bydat.sh #
# created by yhaichao #
# 2013-8-22 #
#############################
#!/bin/bash
DATE=`date +%Y%m%d`
ORACLE_SID=scard
db_unique_name=scard
cd /u01/oracle/diag/rdbms/$db_unique_name/$ORACLE_SID/trace/
if [ -f alert_$ORACLE_SID.log ];then
if [ -f alert_${ORACLE_SID}_$DATE.log ];then
echo "the file is exits!"
else
cat alert_$ORACLE_SID.log >>alert_${ORACLE_SID}_$DATE.log
cat /dev/null > alert_$ORACLE_SID.log
fi
fi
[oracle@ijx ~]$
将脚本添加到crontb:
[oracle@qs-wg-db2 ~]$ crontab -l
00 00 * * * /u01/scripts/alertlog_byday.sh >/u01/scripts/alertlog_byday.log 2>&1