Solved

error's ORA 1568 - ORA 600

Posted on 1997-08-18
2
844 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
Comment Utility
Edited text of question
0
 
LVL 1

Accepted Solution

by:
rodo earned 200 total points
Comment Utility
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.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
oracle global variables 4 51
Oracle PL/SQL syntax 4 52
PL/SQL LOOP CURSOR 3 39
oracle rollup query 3 34
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now