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

"Dusan Bolek" <pagesflames_at_usa.net> wrote in message news:1e8276d6.0204240052.49deeed7_at_posting.google.com...
> "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:<aa3301$26q$1_at_lust.ihug.co.nz>...
> > > 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.
>
> Don't think so, because this is the only destination and
> LOG_ARCHIVE_MIN_SUCCEED_DEST has its default value, which is one.
> And you're right that I'm using EE, but I presume (no SE available)
> that using:
> alter system set LOG_ARCHIVE_DEST =
> "location=E:\oraarch\TEST01\archive\" does a same job for Standard
> Editions.
>

Nope.... that would be mixing the old 8.0 syntax with the new (and EE only) syntax, which are mutually exclusive.

> > But assuming you *have* the Enterprise Edition, you could simply try an
> > 'alter system log_archive_dest_state_x enable'.
>
> I've never said that my way is the only way. I will try, but I think
> that both of ways would be pretty similar in outcome.
>

Well it's one way or the other. If you are using the _dest_n parameters, then re-enabling the destination is the only way to go (you can, of course, specify a "reopen" parameter which attempts to re-enable the destination automatically. And there is a default for that, which I've forgotten -I think it's 600 seconds). But if you are using the old _dest parameters, then stopping and starting ARCH seems as good a way as any.

HJR
> Mr. Frederick do not tell us his platform, but I've encountered this
> behaviour only on NTs. Maybe the problem lies in refreshing of free
> bytes number on drive, while ARCH is giving another try to resume
> work. Looks like ARCH stills remembers old 0-byte value and doesn't
> look again if something has changed. Maybe even ARCH looks if
> something has changed, but NT's giving him the same value.
>
> BTW: Sorry for my ignorance caused by born on wrong side of the globe,
> but what the hell is "Yikes!" ? :-)
> --
> _________________________________________
>
> 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 Wed Apr 24 2002 - 12:38:01 CDT