Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: REDO log problem
There is an article on this under the FAQ section of my website. (And another on 'resizing' of redo logs which may then be relevant)
-- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Practical Oracle 8i: Building Efficient Databases Publishers: Addison Wesley Longman Book bound date: 8th Dec 2000 See a first review at: http://www.ixora.com.au/resources/index.htm#practical_8i George Ye wrote in message <8uq60s$vae$1_at_nnrp1.deja.com>...Received on Tue Nov 14 2000 - 02:07:55 CST
>Is there any serious problem if there are the warning messages in the
>database ALRT log file:
>
>>Thu Nov 09 03:19:59 2000
>>Thread 1 cannot allocate new log, sequence 49020
>>Checkpoint not complete
>> Current log# 1 seq# 49019 mem# 0: F:\ORACLE\ORADATA\ZXDB\REDO01.LOG
>>LGWR: prodding the archiver
>>Thread 1 advanced to log sequence 49020
>> Current log# 2 seq# 49020 mem# 0: F:\ORACLE\ORADATA\ZXDB\REDO02.LOG
>
>If the above messages appear very frequently, should I alter the
>database configuration somewhere?
>
>Thanks a million!
>
>George
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.