Re: Purging alert log files
- From: "David Barbour" <david.barbour1@xxxxxxxxx>
- To: Michael.Kline@xxxxxxxxxxxx
- Date: Mon, 22 Jan 2007 11:59:45 -0500
I rotate them once a month. Scheduled as a cron job to execute the first
minute of every month. Add a line to zip the file. I just didn't get
around to it yet.
##########################################################
# Rotate Oracle Alert Log at the beginning of each Month
##########################################################
00 00 1 * * /usr/local/scripts/oracle/rotate_alertlog.sh
"rotate_alertlog.sh" 52 lines, 849 characters
#!/bin/ksh
# Script to rotate alert log at the beginning of each month
# DAB 09/30/06
# Set local variables
export ORACLE_HOME=/oracle/PR1/920_64
export ORACLE_SID=PR1
export PATH=$PATH:$ORACLE_HOME/bin
# Change to the directory where the alert log is located.
`cd /oracle/PR1/saptrace/background`
currentMonth=`date +%m`
case "$currentMonth" in
01)
fileTag="Dec";;
02)
fileTag="Jan";;
03)
fileTag="Feb";;
04)
fileTag="Mar";;
05)
fileTag="Apr";;
06)
fileTag="May";;
07)
fileTag="Jun";;
08)
fileTag="Jul";;
09)
fileTag="Aug";;
10)
fileTag="Sep";;
11)
fileTag="Oct";;
12)
fileTag="Nov";;
esac
#print $currentMonth
#print $fileTag
`mv /oracle/PR1/saptrace/background/alert_PR1.log
/oracle/PR1/saptrace/background/alert_PR1_$fileTag.log`
exit
On 1/22/07, Kline.Michael <Michael.Kline@xxxxxxxxxxxx> wrote:
How often are you purging(and cutting copies of) alert logs???
Currently we are doing this to purge our log file. For a while on some
boxes they were doing this all the time so that our "backup" directory had
may be hundreds of "alert logs" with time stamps. Of course if you wanted to
"grep" for something you could, but often that gave so many hits that needed
to be ignored as old alertlog copies didn't count.
Larger alert logs, 1 year or so, allow us to look to see if this happened
in the past.
Also, I'm thinking there is a strong possibility that we could lose data
on this. I've seen it sometimes take 5-15 seconds just to tail the alert
log.
Currently:
cp $LOG_NAME $LOG_NAME.prev
/usr/bin/gzip -c $LOG_NAME.prev > $ORA_LOG/$ORACLE_SID"_"$LOG_NAME"_"`date
+%H:%M_%d-%h-%Y`.gz
cat /dev/null > $LOG_NAME
Maybe should:
cp $LOG_NAME $LOG_NAME.prev
cat /dev/null > $LOG_NAME
/usr/bin/gzip -c $LOG_NAME.prev > $ORA_LOG/$ORACLE_SID"_"$LOG_NAME"_"`date
+%H:%M_%d-%h-%Y`.gz
I also usually purge once per year, or maybe once per month. On one test
box, we "rotate" when we refresh the database.
Michael Kline
Tel: 804.261.9446 Net: 643.9446
Cell: 804.744.1545
michael.kline@xxxxxxxxxxxx
LEGAL DISCLAIMER
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or other use
of or taking action in reliance upon this information by persons or entities
other than the intended recipient is prohibited. If you have received this
email in error please contact the sender and delete the material from any
computer.
SunTrust and Seeing beyond money are federally registered service marks of
SunTrust Banks, Inc.
[ST:XCL]
Other related posts:
