RE: Corrupt blocks

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 7 Aug 2008 10:22:54 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A902B5AE04@usahm208.amer.corp.eds.com>

The message lists the block. Try dumping it to see if the block is unused. The corruption could be in an "unused" portion of the block.  

If the block in question is not empty then as you can read all the data I suggest recreating the object and its dependencies. In fact I would, if possible, try an alter table move with alter index rebuilds just to be safe.  

• Mark D Powell -- Phone (313) 592-5148

  ---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Steve Bradshaw

	Sent: Thursday, August 07, 2008 9:55 AM
	To: oracle-l_at_freelists.org
	Subject: Corrupt blocks
	
	
	Hi,
	
	We've got a table that the alert log is reporting as having a

corrupt block:         

	Corrupt Block Found
	         TSN = 20, TSNAME = DEVELOPMENT
	         RFN = 10, BLK = 28391, RDBA = 41971431
	         OBJN = 54369, OBJD = 54369, OBJECT = SKRSAIN, SUBOBJECT
=
	         SEGMENT OWNER = SATURN, SEGMENT TYPE = Table Segment
	
	I can create a copy of this table using "create table as..." and

it doesn't issue an error. So does this mean that the corruption is an unused datablock and if so will the data in the copy of the table be intact?         

        Thanks in advance.                  

        Steve         

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

Received on Thu Aug 07 2008 - 09:22:54 CDT