Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Redo-Log Archiv Problem
I assume you have enough free space in the I:\ORANT\DATABASE directory to
write the log files.
Peter Miller <p.miller_at_brocom.de> wrote in message
news:3965BCFD.7696861E_at_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
Received on Fri Jul 07 2000 - 00:00:00 CDT