Re: HELP: Unable to allocate new log (?)

You need to increase the size of your redo-logs, they're switching far too aften and cannot keep up.... Re-create new ones and drop the oldies....

Cheers,

Robert Prendin
RP Data Solutions Inc.

"Specializing in remote DBA support..."

On Sun, 19 Sep 1999 15:12:26 -0700, Mirza Mohsin Beg <mbeg_at_netearnings.com> wrote:

>
>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 - 19:22:55 CDT