I started to tell you that there were no arch trace file, but got a call, while writing this mail (1.5 hours ago), that the system stuck again. This time we put :alter system set archive_log_trace=32; so we have trace. The trace file for the arch process that stuck is:
Tue Nov 05 14:21:36 2002 ORACLE V8.1.6.3.0 - Production vsnsta=0 vsnsql=e vsnxtr=3 Windows NT Version 4.0 Service Pack 6, CPU type 586 Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production With the Partitioning option JServer Release 8.1.6.3.0 - Production Windows NT Version 4.0 Service Pack 6, CPU type 586 Instance name: m135 Redo thread mounted by this instance: 1 Oracle process number: 118 Windows thread id: 728, image: ORACLE.EXE *** SESSION ID:(185.7252) 2002-11-05 14:21:36.531 *** 2002-11-05 14:21:36.531 *** 2002-11-06 09:18:32.656 ARC6: Archive destination 1 made inactive: File I/O error 19502 Propogating archive 0 destination version 14 to version 18 Propogating archive 0 state version 10 to version 14 Propogating archive 1 destination version 5 to version 7 Propogating archive 1 state version 5 to version 7 Propogating archive 2 destination version 5 to version 7 Propogating archive 2 state version 5 to version 7 Propogating archive 3 destination version 5 to version 7 Propogating archive 3 state version 5 to version 7 Propogating archive 4 destination version 5 to version 7 Propogating archive 4 state version 5 to version 7 Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 9:05 PM > Did I say LGWR trace file? > > I meant ARCH trace file, sorry. > > jared > > > > > > > [EMAIL PROTECTED] > Sent by: [EMAIL PROTECTED] > 11/05/2002 10:23 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject: Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE > > > Yechiel, > > No OS errors here. You may want to look at the > LGWR trace file in the BDUMP directory. > > 2 things > > 1) Have the SA check for device errors. Something in the IO > system is not working. > > 2) Open a TAR. > > If you have another location to redirect arch logs to, > you may want to do that. > > The following 2 notes you will find useful for redirecting > archive logs to another location without bouncing the database. > > 135866.1 > 74324.1 > > > HTH > > Jared > > > > > > > "Yechiel Adar" <[EMAIL PROTECTED]> > 11/05/2002 10:56 AM > > > To: "ORACLE-L" <[EMAIL PROTECTED]>, > <[EMAIL PROTECTED]> > cc: > Subject: Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE > SPACE > > > 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: > 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: > 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).