Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Q: Shutting down log archiving
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+121,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