RE: Identifying the content of a corrupted block in system tablespace
Mark W. Farnham
Something about 8.0.6 rings bells. If I recall correctly there is a patch to
fix an error in block checking, or maybe it was that the upgrade from 8.0.5
to 8.0.6 made block checking catch some good blocks as if they were bad. IF
that is the problem and the dictionary block is not actually corrupt you may
be able to get all your stuff by turning block checking off. Did someone
recently turn block checking on, or start using new data or index types
Otherwise, what the other folks said.
BTW, this is 8.0.6, they identified this problem 3 months ago in their
Peoplesoft application, and of course they don't have a good backup from
which to recover...
Vlado Barun, M.Sc.
Mobile: 865 335 7652