Re: can not allocate log, archival required..

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 22 Mar 2002 19:59:59 -0000
Message-ID: <3c9b930a_2@mk-nntp-1.news.uk.worldonline.com>

"Tina Mourad" <tmourad_at_gmx.net> wrote in message news:9be11957.0203211643.2c1a2cf6_at_posting.google.com...
> I get the DOS window warning "Oracle instance xxx can not allocate
> log, archival required".
>
> My init.ora does have the line
> LOG_ARCHIVE_START = TRUE
>
> thanks in advance..

Database is hanging (waiting), because archive log dest is full. Make some space available, and it should carry on where it left off. HTH, Paul Received on Fri Mar 22 2002 - 13:59:59 CST