From: "Gary Healy (Powerup)" <ghealy@powerup.com.au>
Subject: Re: Redo-Log Archiv Problem
Date: 2000/07/07
Message-ID: <3965ce19@grissom>#1/1
Distribution: world
References: <3965BCFD.7696861E@brocom.de>
X-Original-NNTP-Posting-Host: ts53036.powerup.com.au
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Trace: ozemail.com.au 962973213 203.32.8.130 (Fri, 07 Jul 2000 22:33:33 EST)
Organization: OzEmail Ltd, Australia
X-MSMail-Priority: Normal
NNTP-Posting-Date: Fri, 07 Jul 2000 22:33:33 EST
Newsgroups: comp.databases.oracle.server


I assume you have enough free space in the I:\ORANT\DATABASE directory to
write the log files.
Peter Miller <p.miller@brocom.de> wrote in message
news:3965BCFD.7696861E@brocom.de...
> 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