这个问题是我模拟的故障，具体怎么出现的请参考链接
https://blog.csdn.net/m15217321304/article/details/105223487
--//查看数据库日志
Recovery of Online Redo Log: Thread 1 Group 3 Seq 24 Reading mem 0
Mem# 0: /u01/app/oradata/QXY1/redo03.log
Block recovery stopped at EOT rba 24.105.16
Block recovery completed at rba 24.105.16, scn 0.1671920
ORACLE Instance QXY1 (pid = 13) - Error 607 encountered while recovering transaction (3, 31) on object 76842.
Errors in file /u01/app/diag/rdbms/qxy1/QXY1/trace/QXY1_smon_18239.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kdBlkCheckError], [1], [89233], [6110], [], [], [], [], [], [], [], []
Starting background process CJQ0
Mon Mar 30 17:01:34 2020
CJQ0 started with pid=30, OS id=18285
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Starting background process SMCO
Mon Mar 30 17:01:34 2020
SMCO started with pid=28, OS id=18287
Dumping diagnostic data in directory=[cdmp_20200330170134], requested by (instance=1, osid=18239 (SMON)), summary=[incident=157959].
Mon Mar 30 17:02:31 2020
Sweep [inc][157959]: completed
Sweep [inc2][157959]: completed
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kdBlkCheckError], [1], [89233], [6110], [], [], [], [], [], [], [], []
Corrupt Block Found
TSN = 0, TSNAME = SYSTEM
RFN = 1, BLK = 89233, RDBA = 4283537
OBJN = 76842, OBJD = 76842, OBJECT = A, SUBOBJECT =
SEGMENT OWNER = SYS, SEGMENT TYPE = Table Segment--//查看对象object=76842
SQL> select object_id, object_name from dba_objects where object_id = 76842;
OBJECT_ID OBJECT_NAME
---------- ------------------------------
76842 A
SQL>
--//transaction (3, 31)意思就是3号回滚段 31号slot上面有活动事物
--//查看QXY1_smon_18239.trc
BH (0x633f8cf8) file#: 1 rdba: 0x00415c91 (1/89233) class: 1 ba: 0x63376000
set: 6 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 0,0
dbwrid: 0 obj: 76842 objn: 76842 tsn: 0 afn: 1 hint: f
hash: [0x6dbad8d8,0x6dbad8d8] lru: [0x633f8f10,0x6d16d478]
obj-flags: object_ckpt_list
ckptq: [0x6d18b748,0x633f92e8] fileq: [0x6d18b768,0x633f92f8] objq: [0x69034870,0x69034870] objaq: [0x69034850,0x69034850]
use: [0x6d0fc420,0x6d0fc420] wait: [NULL]
st: XCURRENT md: EXCL fpin: 'kdowh01: kdoiur' tch: 0
flags: mod_started
change state: ACTIVE
change count: 1
LRBA: [0x18.40.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]
kcra_dump_redo_internal: skipped for critical process
Incident 157959 created, dump file: /u01/app/diag/rdbms/qxy1/QXY1/incident/incdir_157959/QXY1_smon_18239_i157959.trc
ORA-00600: internal error code, arguments: [kdBlkCheckError], [1], [89233], [6110], [], [], [], [], [], [], [], []
Doing block recovery for file 1 block 89233
Block header before block recovery:
buffer tsn: 0 rdba: 0x00415c91 (1/89233)
scn: 0x0000.00190a3f seq: 0x01 flg: 0x04 tail: 0x0a3f0601
frmt: 0x02 chkval: 0xea42 type: 0x06=trans data
Resuming block recovery (PMON) for file 1 block 89233
Block recovery from logseq 24, block 64 to scn 1671923
seg/obj: 0x12c2a csc: 0x00.190a3f itc: 2 flg: O typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0001.011.00000275 0x00c01efa.007d.1c C--- 0 scn 0x0000.0013cf57
0x02 0x0003.01f.00000337 0x00c01c5a.008e.28 C--- 0 scn 0x0000.00000000
bdba: 0x00415c91
data_block_dump,data header at 0x6337605c
===============
tsiz: 0x1fa0
hsiz: 0x14
pbl: 0x6337605c
76543210
flag=--------
ntab=1
nrow=1
frre=-1
fsbo=0x14
fseo=0x1f7c
avsp=0x1f8a
tosp=0x1f8c
0xe:pti[0] nrow=1 offs=0
0x12:pri[0] offs=0x1f7c
block_row_dump:
tab 0, row 0, @0x1f7c
tl: 2 fb: --HDFL-- lb: 0x0
end_of_block_dump
************ dump undo block **********
Dump of buffer cache at level 3 for tsn=2 rdba=12590170
BH (0x633e6418) file#: 3 rdba: 0x00c01c5a (3/7258) class: 22 ba: 0x63182000
set: 5 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 0,0
dbwrid: 0 obj: -1 objn: 0 tsn: 2 afn: 3 hint: f
hash: [0x6d050fa0,0x6d050fa0] lru: [0x633e6630,0x633e63d0]
ckptq: [NULL] fileq: [NULL] objq: [0x633e68b8,0x69c4d1e0] objaq: [0x633e68c8,0x62ff52b8]
st: XCURRENT md: NULL fpin: 'ktuwh23: ktubko' tch: 1
flags:
LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]
buffer tsn: 2 rdba: 0x00c01c5a (3/7258)
scn: 0x0000.00190a24 seq: 0x01 flg: 0x04 tail: 0x0a240201
frmt: 0x02 chkval: 0x3715 type: 0x02=KTU UNDO BLOCK
Hex dump of block: st=0, typ_found=1
********************************************************************************
UNDO BLK:
xid: 0x0003.01f.00000337 seq: 0x8e cnt: 0x28 irb: 0x28 icl: 0x0 flg: 0x0000
Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1f4c 0x02 0x1efc 0x03 0x1e20 0x04 0x1d68 0x05 0x1ca8
0x06 0x1be8 0x07 0x1b00 0x08 0x1a98 0x09 0x1a40 0x0a 0x19b8
0x0b 0x18a4 0x0c 0x1830 0x0d 0x17ac 0x0e 0x1740 0x0f 0x16dc
0x10 0x1688 0x11 0x15dc 0x12 0x1538 0x13 0x1494 0x14 0x13e4
0x15 0x1330 0x16 0x1294 0x17 0x1200 0x18 0x115c 0x19 0x10c0
0x1a 0x102c 0x1b 0x0f88 0x1c 0x0ed8 0x1d 0x0e7c 0x1e 0x0e08
0x1f 0x0d8c 0x20 0x0cb0 0x21 0x0c48 0x22 0x0bf0 0x23 0x0bac
0x24 0x0b50 0x25 0x0adc 0x26 0x0a80 0x27 0x0a2c 0x28 0x0994
*-----------------------------
* Rec #0x28 slt: 0x1f objn: 76842(0x00012c2a) objd: 76842 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00c01c5a.008e.0a ctl max scn: 0x0000.00150931 prv tx scn: 0x0000.00150943
txn start scn: scn: 0x0000.00000000 logon user: 0
prev brb: 12590168 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x03 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: Z
KDO Op code: IRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00415c91 hdba: 0x00415c90 --//bdba的地址就是DBA 0x00415c91 (4283537 1,89233)
itli: 2 ispac: 0 maxfr: 4863
tabn: 0 slot: 0(0x0) size/delt: 6
fb: --H-FL-- lb: 0x0 cc: 1
null: -
col 0: [ 2] c1 0b --//A表删除之前的10
kcra_dump_redo_internal: skipped for critical process
ORACLE Instance QXY1 (pid = 13) - Error 607 encountered while recovering transaction (3, 31) on object 76842.
*** 2020-03-30 17:01:34.012
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kdBlkCheckError], [1], [89233], [6110], [], [], [], [], [], [], [], []
----- SQL Statement (None) -----
Current SQL information unavailable - no cursor.--//解决办法就是清除3号回滚段上面的活动事物
--//清除3号回滚段31号槽位上面的事务状态
--//查找3号回滚段的文件头
SQL> select header_file, header_block from dba_segments where segment_name = '_SYSSMU3_4004931649$';
HEADER_FILE HEADER_BLOCK
----------- ------------
3 160
--//dump 3号文件160确认下
SQL> alter system dump datafile 3 block 160;
System altered.
buffer tsn: 2 rdba: 0x00c000a0 (3/160)
scn: 0x0000.0019d682 seq: 0x01 flg: 0x04 tail: 0xd6822601
frmt: 0x02 chkval: 0x4c46 type: 0x26=KTU SMU HEADER BLOCK
Hex dump of block: st=0, typ_found=1
71,1 22%
frmt: 0x02 chkval: 0x4c46 type: 0x26=KTU SMU HEADER BLOCK
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00007F32FD8E8200 to 0x00007F32FD8EA200
7F32FD8E8200 0000A226 00C000A0 0019D682 04010000 [&...............]
7F32FD8E8210 00004C46 00000000 00000000 00000000 [FL..............]
7F32FD8E8220 00000000 00000009 000001AF 00000FF0 [................]
7F32FD8E8230 00000000 00000001 00000007 00C000A2 [................]
7F32FD8E8240 00000000 00000000 00000000 00000000 [................]
7F32FD8E8250 000F0003 00000338 00000001 00000009 [....8...........]
7F32FD8E8260 00000000 00000000 40000000 00C000A1 [...........@....]
7F32FD8E8270 00000007 00C000A8 00000008 00C003B8 [................]
7F32FD8E8280 00000008 00C00408 00000008 00C00468 [............h...]
7F32FD8E8290 00000008 00C00528 00000008 00C00600 [....(...........]
7F32FD8E82A0 00000080 00C00B80 00000080 00C01C00 [................]
7F32FD8E82B0 00000080 00000000 00000000 00000000 [................]
7F32FD8E82C0 00000000 00000000 00000000 00000000 [................]
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub stmt_num cmt
0x1c 9 0x00 0x0337 0x000f 0x0000.0019838e 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585558894
0x1d 9 0x00 0x0337 0x001b 0x0000.0016e44f 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585549242
0x1e 9 0x00 0x0337 0x0007 0x0000.0016e511 0x00c01c5a 0x0000.000.00000000 0x00000001 0x00000000 1585549246
0x1f 10 0x90 0x0337 0x0008 0x0000.001908d3 0x00c01c5a 0x0000.000.00000000 0x00000001 0x00000000 0 --//这行数据
0x20 9 0x00 0x0337 0x0021 0x0000.00169508 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585549155
0x21 9 0x00 0x0337 0x001d 0x0000.001695be 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585549159
EXT TRN CTL::
--//bbed修改
BBED> set dba 3,160
DBA 0x00c000a0 (12583072 3,160)
--//不能够map直接查看
BBED> map
File: /u01/app/oradata/QXY1/undotbs01.dbf (3)
Block: 160 Dba:0x00c000a0
------------------------------------------------------------
BBED-00400: invalid blocktype (38)
BBED> d
File: /u01/app/oradata/QXY1/undotbs01.dbf (3)
Block: 160 Offsets: 20 to 8191 Dba:0x00c000a0
------------------------------------------------------------------------
00000000 00000000 00000000 00000000 09000000 af010000 f00f0000 00000000
01000000 07000000 a200c000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 09000000 00000000 00000000 00000040 a100c000 07000000
a800c000 08000000 b803c000 08000000 0804c000 08000000 6804c000 08000000
2805c000 08000000 0006c000 80000000 800bc000 80000000 001cc000 80000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 ac9a815e 24367b5e 2c367b5e 2d367b5e
31367b5e 33367b5e 45367b5e ec367b5e ac9a815e ec367b5e ec367b5e ec367b5e
ec367b5e ec367b5e ec367b5e ec367b5e ec367b5e ec367b5e ec367b5e 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 eb571500
00000000 a200c000 8f000200 01008f00 01000000 00000000 11000f00 00b00100
68000000 feffff7f a200c000 8f000200 0000321f 00000000 8e000300 1200ac1e
00000000 8e001000 12009a15 00000000 8d002600 1100fe01 00000000 00000000
00000000 38030000 591cc000 7ce41600 00000000 09001e00 00000000 00000000
00000000 01000000 ba8f815e 38030000 591cc000 63e41600 00000000 09000000
00000000 00000000 00000000 01000000 ba8f815e 38030000 591cc000 58461600
00000000 09000e00 00000000 00000000 00000000 01000000 908e815e 37030000
00000000 69a71500 00000000 09000d00 00000000 00000000 00000000 00000000
d58a815e 37030000 591cc000 bd451600 00000000 09001400 00000000 00000000
00000000 01000000 6a8d815e 37030000 00000000 38151900 00000000 09001c00
00000000 00000000 00000000 00000000 ac9a815e 37030000 581cc000 1f581500
00000000 09000300 00000000 00000000 00000000 01000000 7c8a815e 38030000
00000000 b4081900 00000000 09000900 00000000 00000000 00000000 00000000
a593815e 38030000 5a1cc000 da081900 00000000 09000a00 00000000 00000000
00000000 01000000 a593815e 38030000 5a1cc000 c6081900 00000000 09000800
00000000 00000000 00000000 01000000 a593815e 38030000 5a1cc000 88091900
00000000 09000b00 00000000 00000000 00000000 01000000 a993815e 38030000
5a1cc000 92091900 00000000 09001800 00000000 00000000 00000000 01000000
a993815e 37030000 581cc000 9da71500 00000000 09001000 00000000 00000000
00000000 01000000 d58a815e 37030000 581cc000 77a71500 00000000 09000c00
00000000 00000000 00000000 01000000 d58a815e 37030000 00000000 ef941600
00000000 09002000 00000000 00000000 00000000 00000000 638f815e 38030000
00000000 82d61900 00000000 0900ffff 00000000 00000000 00000000 00000000
e8bc815e 37030000 00000000 ca441600 00000000 09101300 00000000 00000000
00000000 00000000 668d815e 37030000 581cc000 fa571500 00000000 09001700
00000000 00000000 00000000 01000000 7c8a815e 37030000 591cc000 ab451600
00000000 09001a00 00000000 00000000 00000000 01000000 6a8d815e 37030000
00000000 d0441600 00000000 09001600 00000000 00000000 00000000 00000000
668d815e 37030000 591cc000 cd451600 00000000 09000200 00000000 00000000
00000000 01000000 6a8d815e 37030000 591cc000 a0451600 00000000 09001200
00000000 00000000 00000000 01000000 6a8d815e 37030000 591cc000 ea441600
00000000 09001900 00000000 00000000 00000000 01000000 668d815e 37030000
581cc000 00581500 00000000 09000600 00000000 00000000 00000000 01000000
7c8a815e 37030000 5a1cc000 cb091900 00000000 09000500 00000000 00000000
00000000 01000000 e593815e 37030000 591cc000 03451600 00000000 09001500
00000000 00000000 00000000 01000000 668d815e 37030000 591cc000 b3451600
00000000 09000400 00000000 00000000 00000000 01000000 6a8d815e 37030000
591cc000 5ce41600 00000000 09000100 00000000 00000000 00000000 01000000
ba8f815e 37030000 00000000 8e831900 00000000 09000f00 00000000 00000000
00000000 00000000 6eb5815e 37030000 00000000 4fe41600 00000000 09001b00
00000000 00000000 00000000 00000000 ba8f815e 37030000 5a1cc000 11e51600
00000000 09000700 00000000 00000000 00000000 01000000 be8f815e 37030000
5a1cc000 d3081900 00000000 0a900800 00000000 00000000 00000000 01000000
00000000 37030000 591cc000 08951600 00000000 09002100 00000000 00000000
00000000 01000000 638f815e 37030000 591cc000 be951600 00000000 09001d00
00000000 00000000 00000000 01000000 678f815e 03000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00010000 4000c700 00004000 c7000001
8002c102 03c21129 01267bd7
<32 bytes per line>--//把事务这行转换下
0x1c 9 0x00 0x0337 0x000f 0x0000.0019838e 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585558894
0x1d 9 0x00 0x0337 0x001b 0x0000.0016e44f 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585549242
0x1e 9 0x00 0x0337 0x0007 0x0000.0016e511 0x00c01c5a 0x0000.000.00000000 0x00000001 0x00000000 1585549246
0x1f 10 0x90 0x0337 0x0008 0x0000.001908d3 0x00c01c5a 0x0000.000.00000000 0x00000001 0x00000000 0 --//这行数据
0x20 9 0x00 0x0337 0x0021 0x0000.00169508 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585549155
0x21 9 0x00 0x0337 0x001d 0x0000.001695be 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585549159--//有事物这行比较特殊
10=0a
0x90=90
BBED> find /x 0a90
File: /u01/app/oradata/QXY1/undotbs01.dbf (3)
Block: 160 Offsets: 7456 to 8191 Dba:0x00c000a0
------------------------------------------------------------------------
0a900800 00000000 00000000 00000000 01000000 00000000 37030000 591cc000
08951600 00000000 09002100 00000000 00000000 00000000 01000000 638f815e
37030000 591cc000 be951600 00000000 09001d00 00000000 00000000 00000000
01000000 678f815e 03000000 00000000 00000000 00000000 00000000 0000000
BBED>
BBED> m /x 0900
File: /u01/app/oradata/QXY1/undotbs01.dbf (3)
Block: 160 Offsets: 7456 to 8191 Dba:0x00c000a0
------------------------------------------------------------------------
09000800 00000000 00000000 00000000 01000000 00000000 37030000 591cc000
08951600 00000000 09002100 00000000 00000000 00000000 01000000 638f815e
BBED> sum apply
Check value for File 3, Block 160:
current = 0xdf70, required = 0xdf70
BBED>
BBED> verify
DBVERIFY - Verification starting
FILE = /u01/app/oradata/QXY1/undotbs01.dbf
BLOCK = 160
Block Checking: DBA = 12583072, Block Type = System Managed Segment Header Block
ERROR: SMU Segment Header Corrupted. Error Code = 38505
ktu4smck: number of txn in commit list not equal to inactive txn
TRN CTL:: seq: 0x008f chd: 0x0011 ctl: 0x000f inc: 0x00000000 nfb: 0x0001
mgc: 0xb000 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x00c000a2.008f.02 scn: 0x0000.001557eb
Version: 0x01
FREE BLOCK POOL::
uba: 0x00c000a2.008f.02 ext: 0x0 spc: 0x1f32
uba: 0x00000000.008e.03 ext: 0x12 spc: 0x1eac
uba: 0x00000000.008e.10 ext: 0x12 spc: 0x159a
uba: 0x00000000.008d.26 ext: 0x11 spc: 0x1fe
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub bcl cmt
-----------------------------------------------------------------------------------------
0x00 9 0x00 0x0338 0x001e 0x0000.0016e47c 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585549242
0x01 9 0x00 0x0338 0x0000 0x0000.0016e463 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585549242
0x02 9 0x00 0x0338 0x000e 0x0000.00164658 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585548944
0x03 9 0x00 0x0337 0x000d 0x0000.0015a769 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585547989
0x04 9 0x00 0x0337 0x0014 0x0000.001645bd 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585548650
0x05 9 0x00 0x0337 0x001c 0x0000.00191538 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585552044
0x06 9 0x00 0x0337 0x0003 0x0000.0015581f 0x00c01c58 0x0000.000.00000000 0x00000001 0x00000000 1585547900
0x07 9 0x00 0x0338 0x0009 0x0000.001908b4 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585550245
0x08 9 0x00 0x0338 0x000a 0x0000.001908da 0x00c01c5a 0x0000.000.00000000 0x00000001 0x00000000 1585550245
0x09 9 0x00 0x0338 0x0008 0x0000.001908c6 0x00c01c5a 0x0000.000.00000000 0x00000001 0x00000000 1585550245
0x0a 9 0x00 0x0338 0x000b 0x0000.00190988 0x00c01c5a 0x0000.000.00000000 0x00000001 0x00000000 1585550249
0x0b 9 0x00 0x0338 0x0018 0x0000.00190992 0x00c01c5a 0x0000.000.00000000 0x00000001 0x00000000 1585550249
0x0c 9 0x00 0x0337 0x0010 0x0000.0015a79d 0x00c01c58 0x0000.000.00000000 0x00000001 0x00000000 1585547989
0x0d 9 0x00 0x0337 0x000c 0x0000.0015a777 0x00c01c58 0x0000.000.00000000 0x00000001 0x00000000 1585547989
0x0e 9 0x00 0x0337 0x0020 0x0000.001694ef 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585549155
0x0f 9 0x00 0x0338 0xffff 0x0000.0019d682 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585560808
0x10 9 0x10 0x0337 0x0013 0x0000.001644ca 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585548646
0x11 9 0x00 0x0337 0x0017 0x0000.001557fa 0x00c01c58 0x0000.000.00000000 0x00000001 0x00000000 1585547900
0x12 9 0x00 0x0337 0x001a 0x0000.001645ab 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585548650
0x13 9 0x00 0x0337 0x0016 0x0000.001644d0 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585548646
0x14 9 0x00 0x0337 0x0002 0x0000.001645cd 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585548650
0x15 9 0x00 0x0337 0x0012 0x0000.001645a0 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585548650
0x16 9 0x00 0x0337 0x0019 0x0000.001644ea 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585548646
0x17 9 0x00 0x0337 0x0006 0x0000.00155800 0x00c01c58 0x0000.000.00000000 0x00000001 0x00000000 1585547900
0x18 9 0x00 0x0337 0x0005 0x0000.001909cb 0x00c01c5a 0x0000.000.00000000 0x00000001 0x00000000 1585550309
0x19 9 0x00 0x0337 0x0015 0x0000.00164503 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585548646
0x1a 9 0x00 0x0337 0x0004 0x0000.001645b3 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585548650
0x1b 9 0x00 0x0337 0x0001 0x0000.0016e45c 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585549242
0x1c 9 0x00 0x0337 0x000f 0x0000.0019838e 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585558894
0x1d 9 0x00 0x0337 0x001b 0x0000.0016e44f 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585549242
0x1e 9 0x00 0x0337 0x0007 0x0000.0016e511 0x00c01c5a 0x0000.000.00000000 0x00000001 0x00000000 1585549246
0x1f 9 0x00 0x0337 0x0008 0x0000.001908d3 0x00c01c5a 0x0000.000.00000000 0x00000001 0x00000000 0 --//已经ok了
0x20 9 0x00 0x0337 0x0021 0x0000.00169508 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585549155
0x21 9 0x00 0x0337 0x001d 0x0000.001695be 0x00c01c59 0x0000.000.00000000 0x00000001 0x00000000 1585549159
EXT TRN CTL::
usn: 3
sp1:0x00000000 sp2:0x00000000 sp3:0x00000000 sp4:0x00000000
sp5:0x00000000 sp6:0x00000000 sp7:0x00000000 sp8:0x00000000
EXT TRN TBL::
index extflag extHash extSpare1 extSpare2
---------------------------------------------
0x00 0x00000000 0x00000000 0x00000000 0x00000000
0x01 0x00000000 0x00000000 0x00000000 0x00000000
0x02 0x00000000 0x00000000 0x00000000 0x00000000
0x03 0x00000000 0x00000000 0x00000000 0x00000000
0x04 0x00000000 0x00000000 0x00000000 0x00000000
0x05 0x00000000 0x00000000 0x00000000 0x00000000
0x06 0x00000000 0x00000000 0x00000000 0x00000000
0x07 0x00000000 0x00000000 0x00000000 0x00000000
0x08 0x00000000 0x00000000 0x00000000 0x00000000
0x09 0x00000000 0x00000000 0x00000000 0x00000000
0x0a 0x00000000 0x00000000 0x00000000 0x00000000
0x0b 0x00000000 0x00000000 0x00000000 0x00000000
0x0c 0x00000000 0x00000000 0x00000000 0x00000000
0x0d 0x00000000 0x00000000 0x00000000 0x00000000
0x0e 0x00000000 0x00000000 0x00000000 0x00000000
0x0f 0x00000000 0x00000000 0x00000000 0x00000000
0x10 0x00000000 0x00000000 0x00000000 0x00000000
0x11 0x00000000 0x00000000 0x00000000 0x00000000
0x12 0x00000000 0x00000000 0x00000000 0x00000000
0x13 0x00000000 0x00000000 0x00000000 0x00000000
0x14 0x00000000 0x00000000 0x00000000 0x00000000
0x15 0x00000000 0x00000000 0x00000000 0x00000000
0x16 0x00000000 0x00000000 0x00000000 0x00000000
0x17 0x00000000 0x00000000 0x00000000 0x00000000
0x18 0x00000000 0x00000000 0x00000000 0x00000000
0x19 0x00000000 0x00000000 0x00000000 0x00000000
0x1a 0x00000000 0x00000000 0x00000000 0x00000000
0x1b 0x00000000 0x00000000 0x00000000 0x00000000
0x1c 0x00000000 0x00000000 0x00000000 0x00000000
0x1d 0x00000000 0x00000000 0x00000000 0x00000000
0x1e 0x00000000 0x00000000 0x00000000 0x00000000
0x1f 0x00000000 0x00000000 0x00000000 0x00000000
0x20 0x00000000 0x00000000 0x00000000 0x00000000
0x21 0x00000000 0x00000000 0x00000000 0x00000000
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing (Index): 0
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> --//后台日志不再报错
扫一扫
2445
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
