@session1
SQL> select *from a;
ID
----------
10
SQL> delete a; --//没有提交
1 row deleted.
SQL> alter system flush buffer_cache;
System altered.
SQL> alter system checkpoint;
System altered.
SQL>
--//会话2(因为会话1没有提交,所以会话2能看到)
SQL> select * from a;
ID
----------
10
SQL>
SQL> @dba a
old 1: select rowid, dbms_rowid.rowid_relative_fno(rowid) file#, dbms_rowid.rowid_block_number(rowid) block, a.* from &1 a
new 1: select rowid, dbms_rowid.rowid_relative_fno(rowid) file#, dbms_rowid.rowid_block_number(rowid) block, a.* from a a
ROWID FILE# BLOCK ID
------------------ ---------- ---------- ----------
AAASwqAABAAAVyRAAA 1 89233 10
--//dump 1号文件89233块
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 ---- 1 fsc 0x0007.00000000 --//Lck = 1说明上面有事物
bdba: 0x00415c91
data_block_dump,data header at 0x7fdf32e23a5c
===============
tsiz: 0x1fa0
hsiz: 0x14
pbl: 0x7fdf32e23a5c
76543210
flag=--------
ntab=1
nrow=1
frre=-1
fsbo=0x14
fseo=0x1f7c
avsp=0x1f83
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: 0x2
--//清除上面的Lck标志
BBED> set dba 1,89233
DBA 0x00415c91 (4283537 1,89233)
BBED> map
File: /u01/app/oradata/QXY1/system01.dbf (1)
Block: 89233 Dba:0x00415c91
------------------------------------------------------------
KTB Data Block (Table/Cluster)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdbh, 14 bytes @92
struct kdbt[1], 4 bytes @106
sb2 kdbr[1] @110
ub1 freespace[8040] @112
ub1 rowdata[36] @8152
ub4 tailchk @8188
BBED> p ktbbh
struct ktbbh, 72 bytes @20
ub1 ktbbhtyp @20 0x01 (KDDBTDATA)
union ktbbhsid, 4 bytes @24
ub4 ktbbhsg1 @24 0x00012c2a
ub4 ktbbhod1 @24 0x00012c2a
struct ktbbhcsc, 8 bytes @28
ub4 kscnbas @28 0x00190a3f
ub2 kscnwrp @32 0x0000
sb2 ktbbhict @36 2
ub1 ktbbhflg @38 0x03 (KTBFONFL)
ub1 ktbbhfsl @39 0x00
ub4 ktbbhfnx @40 0x00000000
struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0x0001
ub2 kxidslt @46 0x0011
ub4 kxidsqn @48 0x00000275
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00c01efa
ub2 kubaseq @56 0x007d
ub1 kubarec @58 0x1c
ub2 ktbitflg @60 0x8000 (KTBFCOM)
union _ktbitun, 2 bytes @62
sb2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0x0013cf57
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0003
ub2 kxidslt @70 0x001f
ub4 kxidsqn @72 0x00000337
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00c01c5a --//UBA信息
ub2 kubaseq @80 0x008e
ub1 kubarec @82 0x28
ub2 ktbitflg @84 0x0001 (NONE) ---//修改为8000
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 7
ub2 _ktbitwrp @86 0x0007
ub4 ktbitbas @88 0x00000000
BBED> set offset 84
OFFSET 84
BBED> d
File: /u01/app/oradata/QXY1/system01.dbf (1)
Block: 89233 Offsets: 84 to 595 Dba:0x00415c91
------------------------------------------------------------------------
01000700 00000000 00010100 ffff1400 7c1f831f 8c1f0000 01007c1f 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<32 bytes per line>
BBED> m /x 0080
File: /u01/app/oradata/QXY1/system01.dbf (1)
Block: 89233 Offsets: 84 to 595 Dba:0x00415c91
------------------------------------------------------------------------
00800700 00000000 00010100 ffff1400 7c1f831f 8c1f0000 01007c1f 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<32 bytes per line>
BBED> p ktbbh
struct ktbbh, 72 bytes @20
ub1 ktbbhtyp @20 0x01 (KDDBTDATA)
union ktbbhsid, 4 bytes @24
ub4 ktbbhsg1 @24 0x00012c2a
ub4 ktbbhod1 @24 0x00012c2a
struct ktbbhcsc, 8 bytes @28
ub4 kscnbas @28 0x00190a3f
ub2 kscnwrp @32 0x0000
sb2 ktbbhict @36 2
ub1 ktbbhflg @38 0x03 (KTBFONFL)
ub1 ktbbhfsl @39 0x00
ub4 ktbbhfnx @40 0x00000000
struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0x0001
ub2 kxidslt @46 0x0011
ub4 kxidsqn @48 0x00000275
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00c01efa
ub2 kubaseq @56 0x007d
ub1 kubarec @58 0x1c
ub2 ktbitflg @60 0x8000 (KTBFCOM)
union _ktbitun, 2 bytes @62
sb2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0x0013cf57
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0003
ub2 kxidslt @70 0x001f
ub4 kxidsqn @72 0x00000337
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00c01c5a
ub2 kubaseq @80 0x008e
ub1 kubarec @82 0x28
ub2 ktbitflg @84 0x8000 (KTBFCOM)
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 7
ub2 _ktbitwrp @86 0x0007
ub4 ktbitbas @88 0x00000000
BBED>
BBED> sum apply
Check value for File 1, Block 89233:
current = 0xe84c, required = 0xe84c
BBED> verify
DBVERIFY - Verification starting
FILE = /u01/app/oradata/QXY1/system01.dbf
BLOCK = 89233
Block Checking: DBA = 4283537, Block Type = KTB-managed data block
data header at 0x12c0e5c
kdbchk: row locked by non-existent transaction
table=0 slot=0
lockid=2 ktbbhitc=2
Block 89233 failed with check code 6101
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 1
Total Blocks Failing (Data) : 1
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>
--//修改行锁标志
BBED> p kdbt
struct kdbt[0], 4 bytes @106
sb2 kdbtoffs @106 0
sb2 kdbtnrow @108 1
BBED> p kdbr
sb2 kdbr[0] @110 8060
BBED> x /rnnnn *kdbr[0]
rowdata[0] @8152
----------
flag@8152: 0x3c (KDRHFL, KDRHFF, KDRHFD, KDRHFH)
lock@8153: 0x02
cols@8154: 0
BBED>
BBED> set offset 8153
OFFSET 8153
BBED> d
File: /u01/app/oradata/QXY1/system01.dbf (1)
Block: 89233 Offsets: 8153 to 8191 Dba:0x00415c91
------------------------------------------------------------------------
020102c1 0b3c0201 02c10b3c 020102c1 0b3c0201 02c10b3c 020102c1 0b3c0201
02c10b01 063f0a
<32 bytes per line>
BBED> m /x 00
File: /u01/app/oradata/QXY1/system01.dbf (1)
Block: 89233 Offsets: 8153 to 8191 Dba:0x00415c91
------------------------------------------------------------------------
000102c1 0b3c0201 02c10b3c 020102c1 0b3c0201 02c10b3c 020102c1 0b3c0201
02c10b01 063f0a
<32 bytes per line>
BBED> sum apply
Check value for File 1, Block 89233:
current = 0xea4c, required = 0xea4c
BBED> verify
DBVERIFY - Verification starting
FILE = /u01/app/oradata/QXY1/system01.dbf
BLOCK = 89233
Block Checking: DBA = 4283537, Block Type = KTB-managed data block
data header at 0x12c0e5c
kdbchk: the amount of space used is not equal to block size
used=22 fsc=0 avsp=8067 dtl=8096
Block 89233 failed with check code 6110
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 1
Total Blocks Failing (Data) : 1
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
--//修改ktbbhitc
BBED> p ktbbh
struct ktbbh, 72 bytes @20
ub1 ktbbhtyp @20 0x01 (KDDBTDATA)
union ktbbhsid, 4 bytes @24
ub4 ktbbhsg1 @24 0x00012c2a
ub4 ktbbhod1 @24 0x00012c2a
struct ktbbhcsc, 8 bytes @28
ub4 kscnbas @28 0x00190a3f
ub2 kscnwrp @32 0x0000
sb2 ktbbhict @36 2
ub1 ktbbhflg @38 0x03 (KTBFONFL)
ub1 ktbbhfsl @39 0x00
ub4 ktbbhfnx @40 0x00000000
struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0x0001
ub2 kxidslt @46 0x0011
ub4 kxidsqn @48 0x00000275
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00c01efa
ub2 kubaseq @56 0x007d
ub1 kubarec @58 0x1c
ub2 ktbitflg @60 0x8000 (KTBFCOM)
union _ktbitun, 2 bytes @62
sb2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0x0013cf57
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0003
ub2 kxidslt @70 0x001f
ub4 kxidsqn @72 0x00000337
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00c01c5a
ub2 kubaseq @80 0x008e
ub1 kubarec @82 0x28
ub2 ktbitflg @84 0x8000 (KTBFCOM)
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 7 --//清除
ub2 _ktbitwrp @86 0x0007
ub4 ktbitbas @88 0x00000000
BBED> set offset 86
OFFSET 86
BBED> d
File: /u01/app/oradata/QXY1/system01.dbf (1)
Block: 89233 Offsets: 86 to 597 Dba:0x00415c91
------------------------------------------------------------------------
07000000 00000001 0100ffff 14007c1f 831f8c1f 00000100 7c1f0000 00000000
BBED> m /x 00
File: /u01/app/oradata/QXY1/system01.dbf (1)
Block: 89233 Offsets: 86 to 597 Dba:0x00415c91
------------------------------------------------------------------------
00000000 00000001 0100ffff 14007c1f 831f8c1f 00000100 7c1f0000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
--//修改kdbhtosp
BBED> p kdbh
struct kdbh, 14 bytes @92
ub1 kdbhflag @92 0x00 (NONE)
sb1 kdbhntab @93 1
sb2 kdbhnrow @94 1
sb2 kdbhfrre @96 -1
sb2 kdbhfsbo @98 20
sb2 kdbhfseo @100 8060
sb2 kdbhavsp @102 8074
sb2 kdbhtosp @104 8074
BBED> assign /d kdbhtosp=8076
sb2 kdbhtosp @104 8076
BBED> sum apply
Check value for File 1, Block 89233:
current = 0xea42, required = 0xea42
BBED> verify
DBVERIFY - Verification starting
FILE = /u01/app/oradata/QXY1/system01.dbf
BLOCK = 89233
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 1
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>
--//到目前为止,会话1还没有提交。
--//会话2再次查询
SQL> select * from a; --//这是修改事物信息之前查询结果
ID
----------
10
SQL> alter system flush buffer_cache;
System altered.
SQL> select * from a; --//第二次查询发现事物已经没有了(因为上面刚才手动清除了)
no rows selected
SQL>
SQL>
--//查询v$transaction发现还记录事物信息
select XIDUSN,XIDSLOT,XIDSQN,UBAFIL,UBABLK,UBASQN,UBAREC from v$transaction;
SQL> select XIDUSN,XIDSLOT,XIDSQN,UBAFIL,UBABLK,UBASQN,UBAREC from v$transaction;
XIDUSN XIDSLOT XIDSQN UBAFIL UBABLK UBASQN UBAREC
---------- ---------- ---------- ---------- ---------- ---------- ----------
3 31 823 3 7258 142 40
SQL>
--//dump 3号文件7285块
SQL> select * from v$rollname;
USN NAME
---------- ------------------------------------------------------------
0 SYSTEM
1 _SYSSMU1_1240252155$
2 _SYSSMU2_111974964$
3 _SYSSMU3_4004931649$
4 _SYSSMU4_1126976075$
5 _SYSSMU5_4011504098$
6 _SYSSMU6_3654194381$
7 _SYSSMU7_4222772309$
8 _SYSSMU8_3612859353$
9 _SYSSMU9_3945653786$
10 _SYSSMU10_3271578125$
11 rows selected.
--//
SQL> alter system dump undo header "_SYSSMU3_4004931649$";
System altered.
SQL>
********************************************************************************
Undo Segment: _SYSSMU3_4004931649$ (3)
********************************************************************************
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 9 #blocks: 431
last map 0x00000000 #maps: 0 offset: 4080
Highwater:: 0x00c000a1 ext#: 0 blk#: 0 ext size: 7
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 0
Unlocked
Map Header:: next 0x00000000 #extents: 9 obj#: 0 flag: 0x40000000
Extent Map
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub stmt_num 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 0xffff 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 0x0337 0x0011 0x0000.001557eb 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585547900
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 0x0336 0x000f 0x0000.00150986 0x00c01c58 0x0000.000.00000000 0x00000001 0x00000000 1585547767
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 0x80 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
--//回滚段上面还是存在活动事物0x1f 10 0x80 这行
--//重启数据库是否回滚
SQL> startup force
ORACLE instance started.
Total System Global Area 242208768 bytes
Fixed Size 2227176 bytes
Variable Size 184550424 bytes
Database Buffers 50331648 bytes
Redo Buffers 5099520 bytes
Database mounted.
Database opened.
--//确认数据确实已经被删除了
SQL> select * from a;
no rows selected
--//再次dump _SYSSMU3_4004931649$
********************************************************************************
Undo Segment: _SYSSMU3_4004931649$ (3)
********************************************************************************
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 9 #blocks: 431
last map 0x00000000 #maps: 0 offset: 4080
Highwater:: 0x00c000a1 ext#: 0 blk#: 0 ext size: 7
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 0
Unlocked
Map Header:: next 0x00000000 #extents: 9 obj#: 0 flag: 0x40000000
Extent Map
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub stmt_num 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 0xffff 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 0x0337 0x0011 0x0000.001557eb 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1585547900
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 0x0336 0x000f 0x0000.00150986 0x00c01c58 0x0000.000.00000000 0x00000001 0x00000000 1585547767
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 0x80 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
--//活动事物还是存在
--//这个时候会出现什么问题呢??
--//数据库alert日志
--//查看数据库日志
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
--//问题处理过程见
https://blog.csdn.net/m15217321304/article/details/105223777