Re: Entries in the alert log for archiving

It looks like your redo log file size is too small. The period of time between each log writing is only 50-60 seconds.

Stefan Roesch wrote:
>
> stuartirvine_at_my-deja.com wrote:
>
> > I am getting the following in my alert log. Does this mean that Oracle
> > did not archive the redo log completely. The file created in the
> > archive log destination directory. Ant thoughts would be great
> >
> > Thu Aug 24 12:42:40 2000
> > ARC1: received prod
> > Thu Aug 24 12:42:41 2000
> > LGWR: prodding the archiver
> > Thread 1 advanced to log sequence 878
> > Thu Aug 24 12:42:41 2000
> > Current log# 7 seq# 878 mem# 0: K:\ORANT8I\ORADATA\COMM\LOG
 COMM7A.ORA
> > Current log# 7 seq# 878 mem# 1: K:\ORANT8I\ORADATA\COMM\LOG
 COMM7B.ORA
> > Thu Aug 24 12:42:42 2000
> > ARC2: received prod
> > Thu Aug 24 12:42:42 2000
> > ARC2: Beginning to archive log# 6 seq# 877
> > Thu Aug 24 12:42:49 2000
> > LGWR: prodding the archiver
> > Thread 1 advanced to log sequence 879
> > Thu Aug 24 12:42:49 2000
> > Current log# 8 seq# 879 mem# 0: K:\ORANT8I\ORADATA\COMM\LOG
 COMM8A.ORA
> > Current log# 8 seq# 879 mem# 1: K:\ORANT8I\ORADATA\COMM\LOG
 COMM8B.ORA
> > Thu Aug 24 12:42:50 2000
> > ARC0: received prod
> > Thu Aug 24 12:42:50 2000
> > ARC0: Beginning to archive log# 6 seq# 877
> > ARC0: Failed to archive log# 6 seq# 877
> > ARC0: Beginning to archive log# 7 seq# 878
> > Thu Aug 24 12:42:51 2000
> > ARC2: Completed archiving log# 6 seq# 877
> > ARC2: re-scanning for new log files
> > ARC2: prodding the archiver
> > Thu Aug 24 12:42:51 2000
> > ARC1: received prod
> > ARC1: Beginning to archive log# 7 seq# 878
> > ARC1: Failed to archive log# 7 seq# 878
> > Thu Aug 24 12:42:59 2000
> > ARC0: Completed archiving log# 7 seq# 878
> > ARC0: re-scanning for new log files
> > ARC0: prodding the archiver
> > Thu Aug 24 12:42:59 2000
> > ARC2: received prod
> > Thu Aug 24 12:42:59 2000
> > LGWR: prodding the archiver
> > Thread 1 advanced to log sequence 880
> > Current log# 2 seq# 880 mem# 0: K:\ORANT8I\ORADATA\COMM\LOG2A.ORA
> > Thu Aug 24 12:42:59 2000
> > Current log# 2 seq# 880 mem# 1: K:\ORANT8I\ORADATA\COMM\LOG2B.ORA
> > Thu Aug 24 12:43:00 2000
> > ARC0: received prod
> > Thu Aug 24 12:43:00 2000
> > ARC0: Beginning to archive log# 8 seq# 879
> > Thu Aug 24 12:43:09 2000
> > LGWR: prodding the archiver
> > Thread 1 advanced to log sequence 881
> > Thu Aug 24 12:43:09 2000
> > Current log# 3 seq# 881 mem# 0: K:\ORANT8I\ORADATA\COMM\LOG3A.ORA
> > Current log# 3 seq# 881 mem# 1: K:\ORANT8I\ORADATA\COMM\LOG3B.ORA
> > Thu Aug 24 12:43:10 2000
> > ARC1: received prod
> > Thu Aug 24 12:43:10 2000
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> No ,everything is working coorect. I think you are using 8.1.5. There is
 a
> bug that you cannot turn off
> these informational messages from the alert.log and a trace file is also
> written every time.
>
> Hope this helps
> Stefan
>

--
Posted via CNET Help.com
http://www.help.com/