Why don't you verify that the corrupted block belongs to the segment you think it does, or belongs to a segment at all?
select owner||'.'||segment_name, segment_type from dba_extents where file_id = <file#> and 67108870 between block_id and (block_id + blocks - 1); -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 18 Apr 2002, Jenner Mike wrote: > I have a system datafile that returns dbv errors for a SYSTEM > datafile. > > The fault has existed for a long time undiscovered so recovery from backup > is not possible. The database still does not exhibit any problems except for > dbv! > The errors are all 'Block Type = Undo data block', so I assume the fault is > in the system rollback segment. > > I'm sure I can't drop/recreate the SYSTEM rbs, so does anyone have any > suggestions apart from a full export and import? > > Dbv extract is below: > > > Block Checking: DBA = 67108870, Block Type = Undo data block > > ERROR: Undo Block Corrupted. Error Code = 2008 > > ktu4ubck: size(108) of undo record #1 corrupted. > > UNDO BLK HEADER: > > xid: 0x0000.08a.00000151 seq: 0x198 cnt: 0x4d irb: 0x4d icl: 0x0 flg: > 0x000 > 0 > > Rec Offset | Rec Offset | Rec Offset | Rec Offset | Rec Offset > > --------------------------------------------------------------------------- > > 0x00 0x1fe8 | 0x01 0x1f80 | 0x02 0x1f2e | 0x03 0x1ee0 | 0x04 0x1e76 > > . > . > 0x4b 0x027c | 0x4c 0x0212 | 0x4d 0x01b0 > > Hex dump: > > 0x000b6b94(+0000): 00 0a 00 10 00 3c 00 10 00 02 00 00 2a 11 00 00 > > . > . > 0x000b6bf4(+0060): 00 9d 00 00 78 bc 01 00 > > > > grep 'Block Type' dbv_log | wc -l > 127 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
