Re: How to restart an instance who failed in lack of archivelog space ?

"Dusan Bolek" <pagesflames_at_usa.net> wrote in message news:1e8276d6.0204222246.9945918_at_posting.google.com...
> Knut Talman <knut.talman_at_mytoys.de> wrote in message
news:<3CC49B18.5000003_at_mytoys.de>...
> > Frederic Payant wrote:
> >
> > > Hi,
> > >
> > > Is there any way to restart an instance when it freezed
> > > because of lack of space in archive log directory ?
> > > It seems that shutdown and restart is the only way for it to
> > > work again even if free space is allocated in archive log dir.
> >
> >
> > I also discovered that archiving does not restart automatically.
> > Connect to your instance as sys (sysdba) or internal, then issue:
> >
> > archive log stop;
> > archive log start;
>
> Is true that in some cases ARCH will not resume its work even after
> freeing disk space. I've encountered this problem on Windows NT, on
> Unixes I have no problems like this.
> I have another way to force resuming of ARCH, so there is no need to
> stop archiving. Just set your archive destination (using ALTER SYSTEM)
> to the same directory as you're already using (of course after freeing
> that place). For example:
>
> alter system set LOG_ARCHIVE_DEST_1 =
> "location=E:\oraarch\TEST01\archive\"
>

Yikes! That's now an OPTIONAL destination, because you didn't explicitly set MANDATORY. It's also an unfortunate fact that you can only use this sort of syntax using the Enterprise Edition of Oracle.... dest_n is not available in standard edition.

But assuming you *have* the Enterprise Edition, you could simply try an 'alter system log_archive_dest_state_x enable'.

Regards
HJR
> After that system will resume archiving, no restarting or stopping
> ARCH is needed.
>
> --
> _________________________________________
>
> Dusan Bolek, Ing.
> Oracle team leader
>
> Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> can call it an overture to bankruptcy) on that server. I'm still using
> this email to prevent SPAM. Maybe one day I will change it and have a
> proper mail even for news, but right now I can be reached by this
> email.
Received on Tue Apr 23 2002 - 02:36:31 CDT