Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> System datafile corruption.
Guys,
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
Regards,
Mike Jenner
Database Administrator
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: M.Jenner_at_southampton.gov.uk 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 - 08:28:24 CDT
![]() |
![]() |