This error is nearly, but not quite, always caused by the archivelog destination running out of space. You say that you checked disk space (I assume you mean on e:\). Another possible cause is that the drive is networked in someway (NAS/SAN) and you temporarily lost connection to it - this or hardware errors - should show up in the system event log.

 

Finally there is a bug in OCFS which matches your description - though you seem to be running 8i so I guess OCFS doesn't come into the equation.

 

On 7/12/06, Alessandro Vercelli <alever@libero.it> wrote:

Hi all,
I'm facing with a strange problem with Oracle 8.1.7 on win2k.
Some days ago database freezed completely with the following error in alert log:

Mon Jul 10 14:25:45 2006
ARC0: Error 19504 creating archivelog file 'E:\ORA817\MMOHSDB\ARCHIVE\MMOHSDBT001S07878.ARC'
ARC0: Archiving not possible: error count exceeded
ARC0: Failed to archive log# 3 seq# 7878
ARCH: Archival stopped, error occurred. Will continue retrying
ARCH:
ORA-16014: log 3 sequence# 7878 not archived, no available destinations
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\MMOHSDB\REDO03.LOG'

After this initial error, I found a very long series of:

ARC0: Beginning to archive log# 3 seq# 7878
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log# 3 seq# 7878

Tried to close the db with immediate, but it hanged, using abort succeeded.

In the first looking for errors, I checked disk space which was more than 4 Gb free, so this was not the problem; after I looked at the archived log destination which contained 2908 archived logs (this is an operative db and  the setting up for a backup server is slowed down by some "business" discussions...); so I created a temporary location in which I moved most of the archived logs.

The db restarted successfully, and now is running without problems, but I'd like to find what is the above error; I don't remember there are issues on Win2k related to number of files into a directory, surely there're limitations but they're much higher than 2908; prior of moving archived logs, I tried to create a file into the same location without problem.

Has any body experienced such an issue?

Many thanks,

Alessandro

--
http://www.freelists.org/webpage/oracle-l