Re: Purging alert log files
- From: Andreas Piesk <a.piesk@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 22 Jan 2007 17:46:00 +0100
Kline.Michael schrieb:
> 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
why do you copy the alert.log? i just rename it. rename is atomic, so no
data loss possible. oracle will create a new alert.log if there's no
such file.
regards,
-ap
--
Andreas Piesk a.piesk@xxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
