RE: Identifying the content of a corrupted block in system tablespace

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <vlado@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 7 Jan 2005 12:16:13 -0500

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
recently?

Otherwise, what the other folks said.

mwf

-----Original Message-----
<snip>
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

AIM: vbarun2


--
//www.freelists.org/webpage/oracle-l

Other related posts: