Q: Shutting down log archiving

From: Uwe Schneider <uwe.schneider_at_xlink.net>
Date: Thu, 18 Nov 1999 10:13:35 +0100
Message-ID: <3833C33F.EB9AF6D3@xlink.net>

Hi,

I just wanted to stop the automatic archiving of redo logs on one instance. What I did was:
- svrmgrl: ALTER SYSTEM ARCHIVE LOG STOP; - init.ora: LOG_ARCHIVE_START=FALSE

But: after instance startup it seems to be in an inconsistend state:

> select * from v$database;

NAME CREATED LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#

--------- -------------------- ------------ ------------------
---------------
WG7N      12/29/98 17:04:49    ARCHIVELOG           1,9242E+12     

1,9242E+12

and after a while the database stops with the following message in alert.log:

Thread 1 cannot allocate new log, sequence 3780 All online logs needed archiving
  Current log# 2 seq# 3779 mem# 0: /orahome/oracle7/WG7N/log_WG7N_2a   Current log# 2 seq# 3779 mem# 1: /mnt/dbs/filer2/WG7N/log_WG7N_2b

What have I done wrong? How can I fix the problem?

Best regards!

--
uwe.schneider_at_xlink.net Received on Thu Nov 18 1999 - 03:13:35 CST