Here is parts of the alert log: Current log# 6 seq# 4153 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1356.ORA Sun Nov 03 11:03:34 2002 ARC0: Beginning to archive log# 5 seq# 4152 ARC0: Completed archiving log# 5 seq# 4152 Sun Nov 03 11:10:33 2002 Thread 1 advanced to log sequence 4154 Current log# 7 seq# 4154 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1357.ORA Sun Nov 03 11:10:33 2002 ARC2: Beginning to archive log# 6 seq# 4153 ARC2: Completed archiving log# 6 seq# 4153 Sun Nov 03 11:20:50 2002 Thread 1 advanced to log sequence 4155 Current log# 8 seq# 4155 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1358.ORA Sun Nov 03 11:20:50 2002 ARC1: Beginning to archive log# 7 seq# 4154 ARC1: I/O error 19502 archiving log 7 to 'E:\ORACLE\ORADATA\MUSK135\DATABASE\ARCHIVE\M135T001S04154.ARC' ARC1: Archiving not possible: error count exceeded ARC1: Failed to archive log# 7 seq# 4154 ARCH: Archival stopped, error occurred. Will continue retrying ARCH: ORA-16038: log 7 sequence# 4154 cannot be archived ORA-19502: write error on file "", blockno (blocksize=) ORA-00312: online log 7 thread 1: 'D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1357.ORA' Sun Nov 03 11:28:06 2002 Thread 1 advanced to log sequence 4156 Current log# 3 seq# 4156 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1353.ORA Sun Nov 03 11:28:06 2002 ARC2: Beginning to archive log# 7 seq# 4154 ARC2: Archiving not possible: No primary destinations ARC2: Failed to archive log# 7 seq# 4154 ARCH: Archival stopped, error occurred. Will continue retrying ARCH: ORA-16014: log 7 sequence# 4154 not archived, no available destinations ORA-00312: online log 7 thread 1: 'D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1357.ORA' Sun Nov 03 11:38:54 2002 Thread 1 advanced to log sequence 4157 Current log# 9 seq# 4157 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOG9.ORA Sun Nov 03 11:38:55 2002 ARC0: Beginning to archive log# 7 seq# 4154 ARC0: Archiving not possible: No primary destinations ARC0: Failed to archive log# 7 seq# 4154 Sun Nov 03 11:39:07 2002 Thread 1 advanced to log sequence 4158 Current log# 10 seq# 4158 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOG10.ORA Sun Nov 03 11:39:07 2002 ARC1: Beginning to archive log# 7 seq# 4154 ARC1: Archiving not possible: No primary destinations ARC1: Failed to archive log# 7 seq# 4154
Yechiel Adar Mehish ----- Original Message ----- To: ORACLE-L <[EMAIL PROTECTED]> Cc: Yechiel Adar <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 7:31 PM > Yechiel, > > What about those alert log entries? > > Jared > > > > > > > "Yechiel Adar" <[EMAIL PROTECTED]> > 11/05/2002 10:38 AM > > > To: "ORACLE-L" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, > <[EMAIL PROTECTED]> > cc: > Subject: Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE > > > Hello Charlie and Jared > > Thanks for the reply. > > As I mentioned in my mail there is a lot of free space on the disk and the > database is with auto archive. > Our problem is that the ARCH process gives an error message (ora 19502) > and > stop. There are messages on the console about error trying to write the > archive log, like when the disk is full. Then the redo log will fill up > and > the instance will stop. > > After I connect as internal and do: > archive log stop; > archive log all; > archive log start; > > everything is back to normal. > > Yechiel Adar > Mehish > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, November 05, 2002 4:48 PM > Subject: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE > > > > My first guess is that the instance has archiving enable, but the > ARCHIVER > > is/was not started. > > The DB will run OK until all the redo logfiles have been filled. > > At this point the instance will simply cease to process any additional > > transactions > > until it has space to which to write additional redo logfile > information. > > > > There should be an entry in the alert_SID.log about what is happening & > > why. > > > > ----- Forwarded by Charlie Mengler/THD on 11/05/2002 06:45 AM ----- > > > > "Yechiel Adar" > > <[EMAIL PROTECTED] To: Multiple > recipients of list ORACLE-L <[EMAIL PROTECTED]> > > .il> cc: > > Sent by: Subject: ORA-19502 ON > RAID > 5 DISKS WITH ENOUGH FREE SPACE > > [EMAIL PROTECTED] > > > > > > > 11/05/2002 12:58 > > AM > > Please respond to > > ORACLE-L > > > > > > > > > > > > > > Hello All > > > > Oracle 8.1.6.3.4 on NT. > > > > I got ora-19502 - can not write archive log, and users could not logged > on. > > I can logon only as internal. > > We had the same problem a few days ago. > > The technical support people checked the raid 5 disks and did not find > any > > I/O errors. > > There is a lot of free space on the drive. > > > > Has anybody encountered this problem? > > Do you know what can cause it? > > What I need to do in order to prevent this from happening again? > > > > > > Yechiel Adar > > Mehish > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Yechiel Adar > > 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: Yechiel Adar 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).
