Oracle-L: RE: Failed to archive log....

From: Steve McClure <smcclure_at_usscript.com>
Date: Thu, 03 Oct 2002 09:23:33 -0800
Message-ID: <F001.004DF7EE.20021003092333@fatcity.com>

When I see this happening at our site it simply means that ARCx is free to work and looking for something to archive. It grabs the oldest unarchived file, only to discover that ARCy is in the midst of recovering that same file....so it "fails". So the message is a bit misleading. This happens at our site when someone does a huge data load without telling me. We have an offsite standby database connected across a 512k DSL line. So if a sizable dataload occurs without me setting the standby archive destination to "defer", all our logs get tied up and we have 10 archivers simultaneously transmitting across the 512k pipe. So even if I am not made aware of a dataload, I find out about it soon enough.

-----Original Message-----
Rafiq
Sent: Wednesday, October 02, 2002 7:28 PM To: Multiple recipients of list ORACLE-L

There were lot of delete/update/insert at that time on your database and your archiving was too much at that time... also try to use separate disk/mount time for your arch destination to avoid write contention at that time....

Regards
Rafiq

Indicator

to increase size of your redologs or add some more group members

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Wed, 02 Oct 2002 16:58:22 -0800

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

Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.com

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve McClure
  INET: smcclure_at_usscript.com

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 Thu Oct 03 2002 - 12:23:33 CDT