Re: ARCHIVE and NO ARCHIVE ?!?!?!?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 17 Sep 2003 12:18:55 GMT
Message-ID: <PiY9b.108246$bo1.25259@news-server.bigpond.net.au>

"Ruthf" <ruthf_at_tvuna.co.il> wrote in message news:48580dac.0309170324.49e65049_at_posting.google.com...
> We changed our server from ARCHIVE to NO ARCHIVE mode.
> WHY DO I GET THE FOLLOWING ERROR ???????????
>
> Thread 1 cannot allocate new log, sequence 2107
> All online logs needed archiving
> Current log# 1 seq# 2106 mem# 0: E:\ORACLE\ORADATA\ORC1\REDO01_N.LOG
> Current log# 1 seq# 2106 mem# 1: H:\ORACLE\ORADATA\REDO01_2.LOG

Hi Ruthf,

Having placed your database in archivelog mode, Oracle will not overwrite a redo log group unless it has been appropriately archived. In the above case, none of your redo logs have been archived to Oracle's satisfaction.

My guess is that you haven't started the ARCH process (via the log_archive_start parameter) hence you're database sitting like a stunned mullet. That said, if you're unable to archive any of your mandatory destinations or you're unable to satisfy the log_archive_min_succeed_dest parameter, you could be likewise stuffed.

Still reckon you haven't started the archive process though ...

Good Luck

Richard Received on Wed Sep 17 2003 - 07:18:55 CDT