Re: Oracle database corruption on HP-UX & Andataco(Micropolis) disk.

In article <2phbi6$hdt_at_elaine.teleport.com>, Don Vinton <dgv_at_teleport.com> wrote:
>Our system administrator has been pulling his hair out lately. Heres a
>description of the problem.
>
>
>>ORA-01578: ORACLE data block corrupted (file # 22, block # 372)
>>ORA-00600: internal error code, arguments: [3339], [1476395384], [1476395380],
I have seen this problem in one off our production databases. First we thought it was a hardware error, but later we discovered it was an Oracle error.

What I know of it is that the error occures when Oracle can't make any sense from its own data blocks. I think some CRC is screwed up. We tracked the block down to the correct table and were lucky that the table was not a mutating one. We copied the table from another database into the 'corrupt' database after renaming the table (not deleting, preventing the bad block reappearance in another table) to table_not_for_reading (or something like that).

You can't do anything with the table that contains the bad block, not even an export. Maybe Oracle Support can help you further, but don't count on that one.

-- 
Peter

-------------------------------------------------------------------------------
Peter van der Kooi		| Telephone: +31 50 851046
PTT Telecom BV			| Telefax  : +31 50 851078
I&AT				| E-mail   : peter_at_telecom.ptt.nl
P.O. Box 188			| DISCLAIMER: This statement is not an official
NL-9700 AD Groningen		| statement from, nor does it represent an
The Netherlands			| official position of, PTT Telecom B.V.
-------------------------------------------------------------------------------