Oracle 8.1.5 EE
OS: Windows NT 4.0

I'm running the database in archivelog mode. The alert log has the following of and on...

LGWR: prodding the archiver

... but yesterday afternoon onwards, this kept repeating in the alert log and the server could not allocate new log as the online logs needed archiving...

Sorted this out, by acknowleging message on console and then giving ...

Code:
archive log all;
Trying to investigate why this happened ?? All applications using this database were affected! Everyone one was trouble-shooting the other tiers of the application but the database. Any pointers??

Thanks & Regards.



====================alert log ==============================
============================================================

Wed Sep 11 08:41:16 2002
LGWR: prodding the archiver
Thread 1 advanced to log sequence 1886
Current log# 2 seq# 1886 mem# 0: D:\ORACLE\ORADATA\BLAZE\REDO02.LOG
Wed Sep 11 08:41:16 2002
ARCH: Beginning to archive log# 1 seq# 1885
ARCH: Completed archiving log# 1 seq# 1885
Wed Sep 11 10:54:56 2002
LGWR: prodding the archiver
Thread 1 advanced to log sequence 1887
Current log# 3 seq# 1887 mem# 0: D:\ORACLE\ORADATA\BLAZE\REDO03.LOG
Wed Sep 11 11:24:02 2002
LGWR: prodding the archiver
Thread 1 advanced to log sequence 1888
Current log# 1 seq# 1888 mem# 0: D:\ORACLE\ORADATA\BLAZE\REDO01.LOG
Wed Sep 11 14:42:29 2002
LGWR: prodding the archiver
Thread 1 cannot allocate new log, sequence 1889
All online logs needed archiving
Current log# 1 seq# 1888 mem# 0: D:\ORACLE\ORADATA\BLAZE\REDO01.LOG
LGWR: prodding the archiver
LGWR: prodding the archiver
...
...
LGWR: prodding the archiver
LGWR: prodding the archiver
Thu Sep 12 09:45:47 2002
Archive Log All
ARCH: Beginning to archive log# 2 seq# 1886
Thu Sep 12 09:45:47 2002
LGWR: prodding the archiver
LGWR: prodding the archiver
LGWR: prodding the archiver
LGWR: prodding the archiver
Thu Sep 12 09:45:51 2002
ARCH: Completed archiving log# 2 seq# 1886
ARCH: Beginning to archive log# 3 seq# 1887
Thu Sep 12 09:45:51 2002
LGWR: prodding the archiver
Thread 1 advanced to log sequence 1889
Current log# 2 seq# 1889 mem# 0: D:\ORACLE\ORADATA\BLAZE\REDO02.LOG

======================= end of alert log ===================

[Edited by ggnanaraj on 09-12-2002 at 03:07 AM]