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

Frederic Payant <fpayant_at_club-internet.fr> wrote in message news:<6qfbcuoorh75829kt183reua8rfu1m6s85_at_4ax.com>...
> Many thanks to all of you for your helpfull advices.
> I still don't understand why my database doesn't restart as you all
> agree on the fact that it should (I'll investigate on this next time
> it'll freeze)
> But now I've necessary tools to restart it without shuting it down
>
> Have a nice day
>

If you are running 8i or higher, and your init.ora parameter is

log_archive_dest=/your/arch/location

then once you free up space in the arch destination, the arch process will resume automatically.

If you are using the _1 suffix to the mandatory log_archive_dest parameter, you will need to add the "reopen n" clause to tell the archiver to try again after n seconds. The default value for REOPEN is 5 minutes or 300 secs, but maybe you didnt wait so long to see if the archiver woke up again.

Try setting

log_archive_dest_1='LOCATION = /disk1/archive MANDATORY REOPEN 10'

or just use the old (8.0 and lower)syntax

log_archive_dest=/disk1/archive

Murali Received on Wed Apr 24 2002 - 10:31:20 CDT