When I see a humungous file like that, I build a little ksh
script that hasn't failed me yet.
 
suffix=`date +%y%m%d`
cp -p alertSID.log alertSID_${suffix}.log
> alertSID.log
 
The only thing that might happen is if Oracle is updating the
log file at EXACTLY the moment you execute this script then that
log line may be lost.  As I said, it hasn't happened - yet - that
I know of - but YMMV.
 
Cheers,
Mike
-----Original Message-----
From: AK [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L
Subject: alert log file

for  one of the db over here  alert log is biggggggg .Looks like its never been truncated or backup .
Is it a problem if i just move this alert log file to another directory , will oracle create a new alert log file ?
Do I need to bounce db ?
 
btw its 8.1.6 ( hp-ux )
-ak
 

Reply via email to