Failed to archive log....

From: Hussain Ahmed Qadri <hussain_at_skm.org.pk>
Date: Wed, 02 Oct 2002 16:58:22 -0800
Message-ID: <F001.004DED18.20021002165822@fatcity.com>

Hi all,

I just wanted a little insight on the following entries of my alert log file;

---

---

ARC0: Beginning to archive log# 3 seq# 51809 ARC0: Failed to archive log# 3 seq# 51809 Tue Oct 01 09:32:37 2002

ARC4: Beginning to archive log# 3 seq# 51809
ARC4: Failed to archive log# 3 seq# 51809
ARC4: Beginning to archive log# 4 seq# 51810

Tue Oct 01 09:32:37 2002
ARC0: Beginning to archive log# 4 seq# 51810 ARC0: Failed to archive log# 4 seq# 51810 Tue Oct 01 09:32:40 2002
Completed checkpoint up to RBA [0xca62.2.10], SCN: 0x0000.02bfbd05 Tue Oct 01 09:32:41 2002
ARC3: Completed archiving log# 3 seq# 51809

---

---

ARC0 failed to archive log seq#51809 at first, then ARC4 tried to archive the same log seq# and it failed again but then the same archiver process (ARC4) started archiving next seq# and failed again. After a few seconds ARC0 successfully archives 51809. Similarly rest of the seq# get archived to after a few tries by one archiver or the other. This behavior is not regular, it appears off and on, most of the times there is no failing, and everything proceeds normally.
I was wondering if any of you can explain the following points to help improve my concepts,

• Is FAILING temporarily any threat?
• What could be the reason for it?
• If the first archiver fails (ARC0) and then the second (ARC4) fails too, why does it try to archive the next seq# rather than finishing the previous one?
• Any reason for this inconsistency?

Thanks & Regards,
Hussain Ahmed Qadri
DBA
SKMCH&RC

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hussain Ahmed Qadri
  INET: hussain_at_skm.org.pk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Wed Oct 02 2002 - 19:58:22 CDT