| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: file alert
Seema,
I'm just curious. Why in the world would you want a log file that large? To me, it just gets too big to do anything with. You gonna scroll thru a file that big? Makes no sense to me.
I like these alert logs a reasonable size so that reviewing them is easy. A file that big - well, you'd have problems using vi to look at it. And you certainly could not ftp it to your desktop.
I say keep them small and compressed and have them available for review when you need them.
Good Luck.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Seema Singh [mailto:oracledbam_at_hotmail.com]
Sent: Monday, October 04, 2004 1:16 PM
To: thomas.mercadante_at_labor.state.ny.us; oracle-l_at_freelists.org
Subject: RE: file alert
I ahve similar script.Wondering to do it when alert log file > 1gb I would
get alert.
Actually I'm trying to store value from du command and put into variable and
then check the variable.thanks
-seema
>From: "Mercadante, Thomas F" <thomas.mercadante_at_labor.state.ny.us>
>To: "'oracledbam_at_hotmail.com'" <oracledbam_at_hotmail.com>,
>oracle-l_at_freelists.org
>Subject: RE: file alert Date: Mon, 4 Oct 2004 13:04:52 -0400
>
>Seema,
>
>Why don't you just rename the alert file once a week? Something like
>this:
>
>BDUMP_DIR=/ora1/u0001/WTWD/bdump
>RUNDATE=`date '+%m%d%y'`
>find $BDUMP_DIR -mtime +15 -print -exec rm {} \;
>mv $BDUMP_DIR/alert_WTWU.log $BDUMP_DIR/alert_WTWU_${RUNDATE}.log
>
>
>I actually rename mine daily and purge the old files that are over 15
>days old.
>
>Hope this helps.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-----Original Message-----
>From: Seema Singh [mailto:oracledbam_at_hotmail.com]
>Sent: Monday, October 04, 2004 12:20 PM
>To: oracle-l_at_freelists.org
>Subject: file alert
>
>
>Hello,
>I want to setup scripton linux whenever alert log >1GB we have to get
>alert.Does anyone send similar kidn of script ? when I'm executing
>following command its show error
>
>frees1=`du -sk /alert logdestination/alert_sid.log| tail -1 | awk
>'{printf "%s\n",$2}'`; export frees1 thanks
>-Seema
>
>_________________________________________________________________
>Express yourself instantly with MSN Messenger! Download today - it's
>FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
>--
>http://www.freelists.org/webpage/oracle-l
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 04 2004 - 12:46:21 CDT
 |
 |