| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Problem on Win2k
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:
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-lReceived on Wed Jul 12 2006 - 07:06:58 CDT
 |
 |