Solved

error's ORA 1568 - ORA 600

Posted on 1997-08-18
2
857 Views
Last Modified: 2010-05-18
An error ORA-01578:ORACLE data block corrupted(file#16,block#24084)  often
appears (on a different file#) on a HASH CLUSTER, and is followed by an
error ORA-00600: internal error code,arguments:
[3339],[268452314],[234897882]

1) How can i do to detect this error before my application stop.
ORACLE preconizes the order : ANALYZE CLUSTER  VALIDATE
STRUCTURE CASCADE;

Have you got other solutions ?

2)How ca i analyze the parameters of the error ORA 600 ?

ORACLE tells me it's an hardware error, but EMC2 answers me there is no
hardware error's on the disk.

What do you think about it ?


Thank you very much for your help...


PS: Sorry for my poor english (I,m french. Mail pbuczek@magic.fr)
0
Comment
Question by:pbuczek
2 Comments
 

Author Comment

by:pbuczek
ID: 1080424
Edited text of question
0
 
LVL 1

Accepted Solution

by:
rodo earned 200 total points
ID: 1080425
Yes, the ora-1578 may be caused by hardware error, but may
by an operating system or oracle bug also...
The main source of information are the arguments of the ora-600
to determine the real cause in your case. And... this is internal
information of Oracle Corp. that is not documented publically.
In these cases you have to ask them.

Ther is no general way of fore-seeing the aparition of this error. ANALYZE ... VALIDATE STRUCTURE is a way to recognize it.

If the corrupted segment is an index, then you can simply drop
and re-create it. If it is a table, there are some ways to
retrieve the information that resides on the remaining
non-corrupted datablocks.
e.g: there is an event (number 10231) for the initSID.ora file that causes the rdbms to ignore corrupted datablocks so you can
export the rest of the information. Obviously, this has some danger because looses some internal checking about the consistency of the datablocks, and must be set up under
Oracle Support supervision.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Queries 15 38
Oracle Pivot Question 8 62
ORA-00972: identifier is too long from Unix but not from Windows in SQLPLUS 17 69
Repeat query 13 46
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to recover a database from a user managed backup

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question