Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Redo-Log Archiv Problem
Hello,
I have a problem with redo-log-archiving (Oracle 8.0.5 under NT4):
The trace-file comes up with:
Thread 1 advanced to log sequence 4184
Current log# 2 seq# 4184 mem# 0: I:\ORANT\DATABASE\LOGORC12.ORA
Thread 1 cannot allocate new log, sequence 4185 Checkpoint not complete
Current log# 2 seq# 4184 mem# 0: I:\ORANT\DATABASE\LOGORC12.ORA
Thread 1 advanced to log sequence 4185
Current log# 1 seq# 4185 mem# 0: I:\ORANT\DATABASE\LOGORC11.ORA
Thread 1 cannot allocate new log, sequence 4186 Checkpoint not complete
Current log# 1 seq# 4185 mem# 0: I:\ORANT\DATABASE\LOGORC11.ORA
Thread 1 advanced to log sequence 4186
Current log# 2 seq# 4186 mem# 0: I:\ORANT\DATABASE\LOGORC12.ORA
Thu Jul 06 15:12:37 2000
Current log# 1 seq# 4189 mem# 0: I:\ORANT\ Thread 1 advanced to log
sequence 4187
Current log# 1 seq# 4187 mem# 0: I:\ORANT\DATABASE\LOGORC11.ORA
Thu Jul 06 15:22:58 2000
Thread 1 advanced to log sequence 4188
Current log# 2 seq# 4188 mem# 0: I:\ORANT\DATABASE\LOGORC12.ORA
Thread 1 cannot allocate new log, sequence 4189 Checkpoint not complete
Current log# 2 seq# 4188 mem# 0: I:\ORANT\DATABASE\LOGORC12.ORA
Thread 1 cannot allocate new log, sequence 4189 All online logs needed archiving
and so on.....
1,2 or 3 logs are archived without complaining but then appears the
message:
'...cannot allocate new log sequence ...'
what am I doing wrong?
The command archive log list shows, that all seems to be fine,
and also the arch-files appear in the correct directory.
What's the problem in allocating every 2nd or 3rd sequence?
Many thanks in advance,
Peter Received on Fri Jul 07 2000 - 00:00:00 CDT