| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: arch directory filled; restart ARCH process?
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFECD4.E21C1620
Content-Type: text/plain;
charset="iso-8859-1"
Would be interesting to know what would happen if archive logs were in the same file system as alert.log. On NT it is often the situation for small boxes - let say they have 1 disk. Anybody knows the answer?
Alex Hillman
-----Original Message-----
From: James Bullard [mailto:jbullard_at_onvia.com]
Sent: Wednesday, July 12, 2000 7:48 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: arch directory filled; restart ARCH process?
There was also a bug in 8.0.5 on HP/UNIX and archiver would not restart after the destination had been cleared, however, they do have a patch. Apparently it is eliminated in 8.0.6. Another interesting side note, on our live site, we had the same problem occur and Oracle will spawn other archiver processes in the event after some prodding the first one does not respond. It shows up in the alert log.
James
-----Original Message-----
Sent: Wednesday, July 12, 2000 2:23 PM
To: Multiple recipients of list ORACLE-L
Once the archive destination has free space the arch process should restart
automatically by itself. I've had this happen every so often. The DB does
not
crash although arch gets wrapped up around the flag pole pretty bad till it
gets
fixed. The DB will continue to run normally until the last of the online
redo
logs gets filled at which time it ceases to run additional transactions,
freezes
anybody currently logged on and refuses to accept any new connections.
Mostly
folks will get an ORA-00257 error and that's all. Once Arch is freed up and
has
had time to archive one online redo log successfully things will return to
normal by themselves. BTW: If arch was writing to a file when the directory
filled, it will hold that file open & try to finish when it can.
Dick Goulet
____________________Reply Separator____________________ Author: "Sandy Ocheltree" <ora_dba_at_hotmail.com> Date: 7/12/00 10:45 AM
Help. I have just started working with a database in archivelog mode. The process that writes our archived logs to tape failed yesterday and eventually the directory that holds the logs filled. The database did not crash though! (I thought that's how it worked?) The alert log has entries showing ARCH trying to write to the filled directory, and failing, but no db
crash. I have copied the archived files off for now and freed up space--is it safe to just restart the ARCH process? Once the process is restarted will
it continue to write to the file that it was archiving to when it failed? Or
will it write to a new file? Am I missing something crucial here?
Thanks,
Sandy
-- Author: Sandy Ocheltree INET: ora_dba_at_hotmail.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Jul 13 2000 - 09:16:05 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Author: INET: dgoulet_at_vicr.com 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: 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).. -- Author: James Bullard INET: jbullard_at_onvia.com 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: 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). ------_=_NextPart_001_01BFECD4.E21C1620 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: arch directory filled; restart ARCH process?</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Would be interesting to know what would happen if = archive logs were in the same file system as alert.log. On NT it is = often the situation for small boxes - let say they have 1 disk. Anybody = knows the answer?</FONT></P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: James Bullard [<A = HREF=3D"mailto:jbullard_at_onvia.com">mailto:jbullard_at_onvia.com</A>]</FONT>= <BR><FONT SIZE=3D2>Sent: Wednesday, July 12, 2000 7:48 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: arch directory filled; restart ARCH = process?</FONT> </P> <BR> <P><FONT SIZE=3D2>There was also a bug in 8.0.5 on HP/UNIX and archiver = would not restart</FONT> <BR><FONT SIZE=3D2>after the destination had been cleared, however, = they do have a patch.</FONT> <BR><FONT SIZE=3D2>Apparently it is eliminated in 8.0.6. Another = interesting side note, on our</FONT> <BR><FONT SIZE=3D2>live site, we had the same problem occur and Oracle = will spawn other</FONT> <BR><FONT SIZE=3D2>archiver processes in the event after some prodding = the first one does not</FONT> <BR><FONT SIZE=3D2>respond. It shows up in the alert log.</FONT> </P> <BR> <P><FONT SIZE=3D2>James </FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>Sent: Wednesday, July 12, 2000 2:23 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR> <P><FONT SIZE=3D2>Once the archive destination has free space the arch = process should restart</FONT> <BR><FONT SIZE=3D2>automatically by itself. I've had this happen = every so often. The DB does</FONT> <BR><FONT SIZE=3D2>not</FONT> <BR><FONT SIZE=3D2>crash although arch gets wrapped up around the flag = pole pretty bad till it</FONT> <BR><FONT SIZE=3D2>gets</FONT> <BR><FONT SIZE=3D2>fixed. The DB will continue to run normally = until the last of the online</FONT> <BR><FONT SIZE=3D2>redo</FONT> <BR><FONT SIZE=3D2>logs gets filled at which time it ceases to run = additional transactions,</FONT> <BR><FONT SIZE=3D2>freezes</FONT> <BR><FONT SIZE=3D2>anybody currently logged on and refuses to accept = any new connections.</FONT> <BR><FONT SIZE=3D2>Mostly</FONT> <BR><FONT SIZE=3D2>folks will get an ORA-00257 error and that's = all. Once Arch is freed up and</FONT> <BR><FONT SIZE=3D2>has</FONT> <BR><FONT SIZE=3D2>had time to archive one online redo log successfully = things will return to</FONT> <BR><FONT SIZE=3D2>normal by themselves. BTW: If arch was writing = to a file when the directory</FONT> <BR><FONT SIZE=3D2>filled, it will hold that file open & try to = finish when it can.</FONT> </P> <P><FONT SIZE=3D2>Dick Goulet</FONT> </P> <P><FONT SIZE=3D2>____________________Reply = Separator____________________</FONT> <BR><FONT SIZE=3D2>Author: "Sandy Ocheltree" = <ora_dba_at_hotmail.com></FONT> <BR><FONT SIZE=3D2>Date: 7/12/00 = 10:45 AM</FONT> </P> <P><FONT SIZE=3D2>Help. I have just started working with a database in = archivelog mode. The </FONT> <BR><FONT SIZE=3D2>process that writes our archived logs to tape failed = yesterday and </FONT> <BR><FONT SIZE=3D2>eventually the directory that holds the logs filled. = The database did not </FONT> <BR><FONT SIZE=3D2>crash though! (I thought that's how it worked?) The = alert log has entries </FONT> <BR><FONT SIZE=3D2>showing ARCH trying to write to the filled = directory, and failing, but no db</FONT> </P> <P><FONT SIZE=3D2>crash. I have copied the archived files off for now = and freed up space--is </FONT> <BR><FONT SIZE=3D2>it safe to just restart the ARCH process? Once the = process is restarted will</FONT> </P> <P><FONT SIZE=3D2>it continue to write to the file that it was = archiving to when it failed? Or</FONT> </P> <P><FONT SIZE=3D2>will it write to a new file? Am I missing something = crucial here?</FONT> <BR><FONT SIZE=3D2>Thanks,</FONT> <BR><FONT SIZE=3D2>Sandy</FONT> <BR><FONT = SIZE=3D2>_______________________________________________________________= _________</FONT> <BR><FONT SIZE=3D2>Get Your Private, Free E-mail from MSN Hotmail at <A = HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A></FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Sandy Ocheltree</FONT> <BR><FONT SIZE=3D2> INET: ora_dba_at_hotmail.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
<BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: </FONT> <BR><FONT SIZE=3D2> INET: dgoulet_at_vicr.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing)..</FONT>
<BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: James Bullard</FONT> <BR><FONT SIZE=3D2> INET: jbullard_at_onvia.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
 |
 |