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

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Wed, 17 Sep 2003 23:42:12 +1000
Message-Id: <3f686584$0$28119$afc38c87@news.optusnet.com.au>

Ruthf wrote:

> 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

What do you mean, 'we've changed to no archive mode'?

That you switched off ARCH, or that you issued the 'alter database noarchivelog' command?

If the former, then no, you haven't changed your server mode at all. The thing is still in archivelog mode, but there's no ARCH to do the archiving. Hence the hang.

Regards
HJR Received on Wed Sep 17 2003 - 08:42:12 CDT