RE: Failed to archive log....
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 fileso 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: 0x.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 SKMCHRC _ Join the worlds 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).
Re: Failed to archive log....
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: 0x.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 SKMCHRC _ Join the worlds 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).
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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: Ron Yount INET: [EMAIL PROTECTED] 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: [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).
RE: Failed to archive log
Um... What version? What does v$log say about the status? Do you have multiple archive log destinations specified? Is one of them set to optional? -Original Message- Sent: Wednesday, November 14, 2001 6:42 PM To: Multiple recipients of list ORACLE-L 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. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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: Johnston, Tim INET: [EMAIL PROTECTED] 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: [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).