HELP: Unable to allocate new log (?)

From: Mirza Mohsin Beg <mbeg_at_netearnings.com>
Date: Sun, 19 Sep 1999 15:12:26 -0700
Message-ID: <37E55FCA.4B361B71@netearnings.com>

Hi,

I keep getting messages in my Oracle 8.0.5.0 DB alert log file together with a window that pops up on the console saying there was a log-file 'problem'. The alert log then shows as follows :-

.......
D:\LOGDIRECTORY1\LOAN_LOG41.ORA
Thread 1 cannot allocate new log, sequence 189 All online logs needed archiving
Current log# 4 seq# 188 mem# 0: T:\REDOLOG\LOG_LOG42.ORA Current log# 4 seq# 188 mem# 1: D:\LOGDIRECTORY1\LOAN_LOG41.ORA Thread 1 advanced to log sequence 189
......

The archivelog (and duplex archiving) is turned on and the DB seems to be spooling the archive logs in both directories without a problem. There is several GB of available space in both directories also. Can anyone help?

-M
ps: please email me directly also. Received on Sun Sep 19 1999 - 17:12:26 CDT