RE: Failed to archive log

The alert is just telling you that there was a delay archiving your redo log. This does not mean that you have lost any data, or archive logs, but it can become a bottleneck in your database if transactions have to wait for archiving on a regular basis. If this was during a normal activity/load period, then you may need to look into the efficiency of your redo and archive file systems.

e.g. Your redo logs are on separate file systems so when the disk is done receiving write requests, it is free to perform reads necessary for archiving.

Your archive file system is separate from your redo file systems so it is always read to process the writes requests necessary to copy redo logs.

Your redo file systems and archive file systems are on dedicated spindles or striped across several spindles that are not used for other concurrent activity, e.g. not shared with data files.

You should also look into the frequency of log switches, if this is too frequent, then it is easy to need a redo log before adequate time has expired for the archiving to occur. (General rule, log switches every 15 minutes are satisfactory for most OLTP systems.)

HTH
-Ron-

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of DENNIS
> WILLIAMS
> Sent: Wednesday, November 14, 2001 5:42 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Failed to archive log
>
>
> Has anyone seen the following in their alert log? Is this serious? It does
> then go on and say it completed archiving that log. Thanks for your
> insights.
>
> Thread 1 advanced to log sequence 3513
> Tue Nov 13 01:02:03 2001
> ARC0: Beginning to archive log# 2 seq# 3512
> Current log# 3 seq# 3513 mem# 0: /oracle8/admin/ams/pfile/log3a.dbf
> ARC0: Failed to archive log# 2 seq# 3512
> Tue Nov 13 01:02:04 2001
> ARCH: Completed archiving log# 2 seq# 3512
> Tue Nov 13 05:41:07 2001
> Thread 1 advanced to log sequence 3514
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron  Yount
  INET: ronwy_at_swbell.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).