Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Redo-Log Archiv Problem

Redo-Log Archiv Problem

From: Peter Miller <p.miller_at_brocom.de>
Date: 2000/07/07
Message-ID: <3965BCFD.7696861E@brocom.de>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US