RE: Read a corrupted block

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <Joel.Patterson@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 29 Jul 2010 11:33:36 -0400

Joel,
 
    What platform??  If it's a Nix variant there is dd and there is
always ALTER SYSTEM DUMP 
 

Dick Goulet 
Senior Oracle DBA/NA Team Lead 
PAREXEL International 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Joel.Patterson@xxxxxxxxxxx
Sent: Thursday, July 29, 2010 10:47 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Read a corrupted block



When all hope fails - block recover, dbms_repair, etc.  and before you
enable skipping corrupt blocks, is there some utility that can show me
what is in the block?

 

Something like a hex reader, but since it is only one block, (and we are
probably going to be getting rid of that data anyway), the method should
be free.  (For instance, I think dude (possible spelling) is something
that could work, but for one block it would be overkill).

 

Even if it is not free, you could let me know.   I probably won't get
it, but the information would be useful, and the question has been
raised.

 

 

 

Other related posts: