Re: Deleting alertlog while intance is running.

I drop and rename the alert_SID.log file on AIX , sun and I never had any problems

Regards

        T. Le Gal

Thor-Ivar Skofsrud wrote:

> "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 - 09:48:47 CDT