| 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
Yechiel,
No OS errors here. You may want to look at the LGWR trace file in the BDUMP directory.
2 things
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:
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:
ARC0: Beginning to archive log# 7 seq# 4154 ARC0: Archiving not possible: No primary destinations ARC0: Failed to archive log# 7 seq# 4154Sun 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).Received on Tue Nov 05 2002 - 12:23:35 CST
 |
 |