Re: Deleting alertlog while intance is running.

You can delete the alert log whenever you want, oracle will open a new one if it does not exist the next time it need to write something to it.

joe
http://www.oracle-dba.com

In article <356e7ef0.0_at_d2o202.telia.com>,   "Tor Kristjan Berge" <tor_at_telox.no> wrote:
>
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 29 1998 - 12:54:25 CDT