RE: Purging alert log files
- From: "Kline.Michael" <Michael.Kline@xxxxxxxxxxxx>
- To: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- Date: Mon, 22 Jan 2007 11:00:06 -0500
Pretty much the same here. It the log is less than 10 meg, normally why
purge.
Michael Kline
Database Administration
Outside 804.261.9446
Cell 804.744.1545
3-9446
-----Original Message-----
From: Syed Jaffar Hussain [mailto:sjaffarhussain@xxxxxxxxx]
Sent: Monday, January 22, 2007 10:59 AM
To: Kline.Michael
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Purging alert log files
I would rather like to purge the alert log based on its size because
some database doesn't have much functionality and doesn't grow much.
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]
--
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g OCP DBA
I blog at :http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
------------------------------------------------------------------------
----------
"Winners don't do different things. They do things differently."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
