error's ORA 1568 - ORA 600

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)
pbuczekAsked:
Who is Participating?
 
rodoConnect With a Mentor Commented:
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
 
pbuczekAuthor Commented:
Edited text of question
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.