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

Home -> Community -> Usenet -> c.d.o.server -> Re: Deleting alertlog while intance is running.

Re: Deleting alertlog while intance is running.

From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: Mon, 1 Jun 1998 12:58:18 -0600
Message-ID: <3572f959.0@news.cadvision.com>


I believe you can delete it while oracle is running. But a safe alternative is to use dev/null:
cp /dev/null thealertlog.log

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
Tor Kristjan Berge wrote in message <356e7ef0.0_at_d2o202.telia.com>...
>Is it possible to delete the alertlog file on a sparcstaion running solaris
>and oracle 7.3 while the instance is running?
>
>What I what to do is to have a program copying the alertlog to another
file,
>scanning the file for errors and deleting the original alertlog file
(before
>it grows too large!) and hopefully the the instance starts producing a new
>alertlog file........
>
>For this to work, it requires that the instance closes the alertlog each
>time it has written to the log. If the instance keeps the file open as long
>as it is running, the only thing you achieve by "deleting" the alertlog
file
>while the instance is running is deleting the link to the file. In other
>words the file would continue to grow, but is no longer possible to access
>the the alertlog.
>
>AM I WRONG?????????
>(I wish I was!)
>
>Yours Tor Kristjan Berge
>
>
>
>
Received on Mon Jun 01 1998 - 13:58:18 CDT

Original text of this message

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