Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Purging alert log files

RE: Purging alert log files

From: Kline.Michael <Michael.Kline_at_SunTrust.com>
Date: Mon, 22 Jan 2007 11:00:06 -0500
Message-ID: <5709F47931154947BA9DB0C4C3951709D36F02@ga016e0m13.corp.suntrust.com>


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_at_gmail.com] Sent: Monday, January 22, 2007 10:59 AM
To: Kline.Michael
Cc: oracle-l_at_freelists.org
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_at_suntrust.com> 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_at_suntrust.com
>
>
>
>
>
> 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."
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 22 2007 - 10:00:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US