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

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

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

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.