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

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;

and everything will be OK.

Regards,

Knut Received on Mon Apr 22 2002 - 18:22:00 CDT