Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deleting alertlog while intance is running.
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