Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE
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
Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE
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 &
Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE
Thanks Jared. I forgot to mention that the SA checked for device errors. None found. A tar has been opened is already on it's way to higher support level. This problem occurred again today, third time in two weeks. Also, the database is up, only the ARCH process is dead. I started the ARCH (archive log stop; archive log all; archive log start;) and the database continued to work. Yechiel Adar Mehish - Original Message - To: ORACLE-L <[EMAIL PROTECTED]> Cc: Yechiel Adar <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 8:17 PM > 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 > > > > > > -- 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).
Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE
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 - To: <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 4:48 PM > 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).
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. > > > &g
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 - To: <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 4:48 PM > 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).
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 > >
Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE
Yechiel, What appears in the archive log? There is very likely to be some OS errors included. Jared "Yechiel Adar" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/05/2002 12:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE 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).
ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE
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).