Re: Entries in the alert log for archiving

Well, I don't know about Archiver, but from the timestamps...

You switch logs at 12:42:41 and then at 12:42:49 and then at 12:42:59 and then at 12:43:09 .

So you are filling up each Online Redo Log every 10 seconds or so. That seems incredibly fast. How big are these logs?

You'll be issuing a checkpoint at every log switch (which means, amongst other things, that CKPT must touch every file in your database), and hence having a huge amount of I/O every 10 seconds. And if you end up switching back to your first log before the checkpoint has completed (or before ARCH has done its stuff), your system will hang whilst things catch up with themselves. You do, however, appear to have a lot of logs, so perhaps that's not a concern for you.

There's no rule about how frequently you should be log switching, but there's a rule of thumb that says once every half hour or so is not a bad idea. You could try adding a set of much bigger logs to try and get to that sort of switching frequency (and then dropping the smaller ones), and then see if there's still a problem.

Personally, I tend to go for enormous logs that don't switch at all until I tell them to do so at the dead of night ('alter system switch logfile') -I risk having to make multiple cups of coffee when recovering from an Instance failure, but so long as the Instance keeps its act together, my performance is fine.

Regards
HJR <stuartirvine_at_my-deja.com> wrote in message news:8o3nsv$4g9$1_at_nnrp1.deja.com...
> 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.
Received on Sat Aug 26 2000 - 16:38:31 CDT