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

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Wed, 02 Oct 2002 18:28:17 -0800
Message-ID: <F001.004DEDCA.20021002182817@fatcity.com>

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

Received on Wed Oct 02 2002 - 21:28:17 CDT