| 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?
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-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
Sent: Wednesday, July 12, 2000 2:23 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:arch directory filled; restart ARCH process?
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 Wed Jul 12 2000 - 17:43:10 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
 |
 |