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