| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Tuesday, November 05, 2002 9:05 PM
> Did I say LGWR trace file?
>
> I meant ARCH trace file, sorry.
>
> jared
>
>
>
>
>
>
> Jared.Still_at_radisys.com
> Sent by: root_at_fatcity.com
> 11/05/2002 10:23 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> 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" <adar76_at_inter.net.il>
> 11/05/2002 10:56 AM
>
>
> To: "ORACLE-L" <ORACLE-L_at_fatcity.com>,
> <Jared.Still_at_radisys.com>
> 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 <ORACLE-L_at_fatcity.com>
> Cc: Yechiel Adar <adar76_at_zahav.net.il>; <Charlie_Mengler_at_HomeDepot.com>
> Sent: Tuesday, November 05, 2002 7:31 PM
>
>
> > Yechiel,
> >
> > What about those alert log entries?
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > "Yechiel Adar" <adar76_at_inter.net.il>
> > 11/05/2002 10:38 AM
> >
> >
> > To: "ORACLE-L" <ORACLE-L_at_fatcity.com>,
> <Jared.Still_at_radisys.com>,
> > <Charlie_Mengler_at_HomeDepot.com>
> > 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: <Charlie_Mengler_at_HomeDepot.com>
> > To: <adar76_at_zahav.net.il>
> > 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"
> > > <adar76_at_inter.net To: Multiple
> > recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > .il> cc:
> > > Sent by: Subject: ORA-19502 ON
> > RAID
> > 5 DISKS WITH ENOUGH FREE SPACE
> > > root_at_fatcity.com
> >
> > >
> > >
> > > 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: adar76_at_inter.net.il
> > >
> > > 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: ListGuru_at_fatcity.com (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: Jared.Still_at_radisys.com
>
> 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: ListGuru_at_fatcity.com (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: Jared.Still_at_radisys.com
>
> 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: ListGuru_at_fatcity.com (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: adar76_at_inter.net.il 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: ListGuru_at_fatcity.com (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).Received on Wed Nov 06 2002 - 03:19:03 CST
 |
 |