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: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
