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

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<aa6qjs$och$1_at_lust.ihug.co.nz>...
> > > But assuming you *have* the Enterprise Edition, you could simply try an
> > > 'alter system log_archive_dest_state_x enable'.

I've tried your way and went to dead end. I've presumed that you mean:

alter system set log_archive_dest_state_1 = enable;

However this statement doesn't resumed stuck archiving so I used my way, which is maybe dead wrong, but works.

--
_________________________________________

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.