Re: Redo-Log Archiv Problem

Your have bursts of activity. Your redo log files are too small (the default is 200k, which is ridiculous) or you have too few of them (at least 4). The last message is pointing to the same problem: you have bursts of activity and the ARCH process cant' cope with the load. You should be able to resolve that by the measures outlined above.

Hth,

Sybrand Bakker
Oracle DBA

"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