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).
