Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE

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 -----
To: <adar76_at_zahav.net.il>
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"
> <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).