From: Peter Miller Subject: Redo-Log Archiv Problem Date: 2000/07/07 Message-ID: <3965BCFD.7696861E@brocom.de>#1/1 Content-Transfer-Encoding: 7bit X-Accept-Language: de Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@euler.space.net X-Trace: euler.space.net 962968458 32125 195.30.191.114 (7 Jul 2000 11:14:18 GMT) Organization: Brockhaus/Commission Mime-Version: 1.0 NNTP-Posting-Date: 7 Jul 2000 11:14:18 GMT Newsgroups: comp.databases.oracle.server 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