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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pbuczekAuthor Commented:
Edited text of question
0
rodoCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.