Re: Unable to allocate redo log, Archiving required

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Wed, 5 Jan 2000 14:32:52 -0000
Message-ID: <947082945.3191.0.nnrp-09.c2de6f3d@news.demon.co.uk>

Hiya,

think I've just found the answer to this after having a similar problem myself...

Is your log_archive_start parameter set to false ?

Was it previously set to true, and you haven't issued an alter database noarchivelog ?

i.e. shutdown the instance (abort or immediate) startup mount
alter database noarchivelog (ensure log archive_start=false in init.ora) alter database open

this will ensure the database is open properly in noarchivelog mode.

hth
Neil.

Anurag Minocha wrote in message <3873044A.42A44AA7_at_synergy-infotech.com>...
>Hi,
>While i was running some scripts on oracle 8.1.5 it gave me the
>following error.
>"Unable to allocate redo log, Archiving required"
>"Press Enter to Acknowledge message"
>
>What does this mean. I do not want to archive my database since it is a
>test database. How do i fix this problem without enabling archiving.
>
>Thanks
>Anurag
>
>also reply at
>anurag_at_synergy-infotech.com
>
Received on Wed Jan 05 2000 - 08:32:52 CST