Re: ORA-00607

Billy Verreynne wrote:

> 00607, 00000, "Internal error occurred while making a change to a data
> block"
> // *Cause: An internal error or memory exception occurred while Oracle was
> // applying redo to a data block.
> // *Action: call Oracle Support
>
> Got this one this weekend (Sa midnight of all times <sigh>).
>

Ouch - I synpathize.

> A validate structure on the table terminated almost immediately complaining
> about an existing index (did not point to a particular one in the trace -
> simply said "row not found in index tsn: 10 rdba: 0x040a9030").
>
> I dropped all the indexes and rebuild. That seemed to have worked. No errors
> thus far. Touch wood.
>
> Any comments about this particular error? Should the re-index build be
> enough to fix this problem? Does it point to a possible disk problem (does
> not seem so to me, but the Unix sysadmin did do a major physical re-org of
> the volume sets to optimise striping, just prior).
>

Is it possible your SA did the re-org while the database and datafiles were live? If so, I'd almost want to point fingers at the disk re-org utility. A small race condition in the copy, especially under a SMP environment, could cause this (I encountered something similar on VM/CMS many years ago). Especially since you indicate the index rebuild seems stable. Received on Mon Jun 02 2003 - 22:00:30 CDT