Re: Deleting alertlog while intance is running.

"Tor Kristjan Berge" <tor_at_telox.no> writes:

>
> 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

I use a Perl script to scan the alertlog for errors, append it to another file and truncate the original file to zero size. I do this while the instance is up and running, and it works fine. I have not tried to delete the alertlog, so I don't know if that will work.

--
Regards
Thor-Ivar Skofsrud Received on Fri May 29 1998 - 06:42:08 CDT