ORA-00607 Internal error occurred while making a change to a data block处理[通俗易懂]

大家好，又见面了，我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。

Jetbrains全家桶1年46，售后保障稳定

这个问题是我模拟的故障，具体怎么出现的请参考链接

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

Jetbrains全家桶1年46，售后保障稳定

–//查看对象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>

–//后台日志不再报错

发布者：全栈程序员-用户IM，转载请注明出处：https://javaforall.cn/213557.html原文链接：https://javaforall.cn

【正版授权，激活自己账号】： Jetbrains全家桶Ide使用，1年售后保障，每天仅需1毛

【官方授权正版激活】： 官方授权正版激活支持Jetbrains家族下所有IDE 使用个人JB账号...