Re: error ORA-01578

Corrupted data block !? Sounds horrible !

Sounds like it's time to perform a full export of the tablespace involved, followed by a drop + create of the tablespace. And not to forget: an import. Consider the file gone. Save what you can.

Analyse an ORA-600 ? Not my cup of tea. Calling Oracle may help. They may even have a patch for you. Or they may just tell you to upgrade :-)

Sorry about my poor french - I'm Danish...

--
Karl
Oracle Certified DBA

Patrick BUCZEK wrote in message <01bd1506$3e678280$ca0903c2_at_portable-pbk>...


>An error ORA-01578:ORACLE data block corrupted(file#16,block#24084)  often


>appears (with the same parameters) 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 <clester.name> 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_at_magic.fr)

>

>

>



begin 666 Karl E. Jørgensen.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DKX<F=E;G-E;CM+87)L.T4N
M#0I&3CI+87)L($4N($KX<F=E;G-E;_at_T*3U)'.E-E<75E;"!);6%G90T*3D]4
M13I396YI;W(_at_4WES=&5M<R!%;F=I;F5E<@T*55),.@T*55),.FAT=' Z+R]S
M97%U96PM:6UA9V4N8V]M#0I%34%)3#M04D5&.TE.5$523D54.FMJ;W)G0&US
H;BYC;VT-"E)%5CHQ.3DW,3(S,%0Q.3(W,3%:#0I%3D0Z5D-!4D0-"_at_``
`
end
end