x1f70
tl: 20 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [10] 53 59 53 5f 43 30 30 31 34 39
col 2: [ 3] c2 02 32
tab 0, row 4, @0x1f5c
tl: 20 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [10] 53 59 53 5f 43 30 30 31 34 35
col 2: [ 3] c2 02 2e
tab 0, row 5, @0x1f48
tl: 20 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [10] 53 59 53 5f 43 30 30 31 33 30
col 2: [ 3] c2 02 1f
tab 0, row 6, @0x1f36
tl: 18 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [ 9] 53 59 53 5f 43 30 30 34 32
col 2: [ 2] c1 2b
tab 0, row 7, @0x1f24
tl: 18 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [ 9] 53 59 53 5f 43 30 30 39 33
col 2: [ 2] c1 5e
tab 0, row 8, @0x1f10
tl: 20 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [10] 53 59 53 5f 43 30 30 31 34 37
col 2: [ 3] c2 02 30
tab 0, row 9, @0x1efc
tl: 20 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [10] 53 59 53 5f 43 30 30 31 34 33
col 2: [ 3] c2 02 2c
tab 0, row 10, @0x1eea
tl: 18 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [ 9] 53 59 53 5f 43 30 30 34 34
col 2: [ 2] c1 2d
tab 0, row 11, @0x1ed8
tl: 18 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [ 9] 53 59 53 5f 43 30 30 38 36
col 2: [ 2] c1 57
tab 0, row 12, @0x5a8
tl: 26 fb: --H-FL-- lb: 0x1 cc: 3
col 0: [ 1] 80
col 1: [16] 5f 4e 45 58 54 5f 43 4f 4e 53 54 52 41 49 4e 54
col 2: [ 3] c2 35 0f
tab 0, row 13, @0x1ec4
tl: 20 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [10] 53 59 53 5f 43 30 30 31 35 30
col 2: [ 3] c2 02 33
... ...
tab 0, row 339, @0x60e
tl: 20 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [10] 53 59 53 5f 43 30 30 33 33 35
col 2: [ 3] c2 04 24
end_of_block_dump
End dump data blocks tsn: 0 file#: 1 minblk 170 maxblk 170
BBED> p *kdbr[12]
rowdata[0]
----------
ub1 rowdata[0] @1516 0x2c
BBED> x /rccnn
rowdata[0] @1516
----------
flag@1516: 0x2c (KDRHFL, KDRHFF, KDRHFH)
lock@1517: 0x01
cols@1518: 3
col 0[1] @1519: .
col 1[16] @1521: _NEXT_CONSTRAINT
col 2[3] @1538: 5214
BBED> dump /v offset 1538 count 16
File: /data/orcl/system01.dbf (1)
Block: 170 Offsets: 1538 to 1553 Dba:0x004000aa
-------------------------------------------------------
03c2350f 2c000301 80105f4e 4558545f l ..5.,....._NEXT_
<16 bytes per line>
BBED> modify /x 03c23519
File: /data/orcl/system01.dbf (1)
Block: 170 Offsets: 1538 to 1553 Dba:0x004000aa
------------------------------------------------------------------------
03c23519 2c000301 80105f4e 4558545f
<32 bytes per line>
BBED> p *kdbr[12]
rowdata[0]
----------
ub1 rowdata[0] @1516 0x2c
BBED> x /rccnn
rowdata[0] @1516
----------
flag@1516: 0x2c (KDRHFL, KDRHFF, KDRHFH)
lock@1517: 0x01
cols@1518: 3
col 0[1] @1519: .
col 1[16] @1521: _NEXT_CONSTRAINT
col 2[3] @1538: 5224
SQL> create table T_SUNHAILONG (id int primary key,value varchar2(20)) tablespace USERS;
create table T_SUNHAILONG (id int primary key,value varchar2(20)) tablespace USERS
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 49, file 1, block 27255 (2)
udump trace:
*** ACTION NAME:() 2015-01-03 18:40:47.118
*** MODULE NAME:(sqlplus@bogon (TNS V1-V3)) 2015-01-03 18:40:47.118
*** SERVICE NAME:(SYS$USERS) 2015-01-03 18:40:47.118
*** SESSION ID:(159.3) 2015-01-03 18:40:47.118
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)
kwqmnich: current time:: 2: 40: 51
kwqmnich: instance no 0 check_only flag 1
kwqmnich: initialized job cache structure
oer 8102.2 - obj# 49, rdba: 0x00406a77(afn 1, blk# 27255)
kdk key 8102.2:
ncol: 1, len: 4
key: (4): 03 c2 35 19
mask: (4096):
故障出现：
SQL> select obj#,name,owner#,t |