Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: System datafile corruption.

Re: System datafile corruption.

From: Jeremiah Wilton <jwilton_at_speakeasy.net>
Date: Thu, 18 Apr 2002 08:38:28 -0800
Message-ID: <F001.004481BF.20020418083828@fatcity.com>


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: jwilton_at_speakeasy.net 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: ListGuru_at_fatcity.com (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).
Received on Thu Apr 18 2002 - 11:38:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US