周末修裤子-生产遭遇ORA-00600 [kokasgi1]的恢复过程
########作者:sky QQ:654268465,转载请注明出处########
上周一客户现场实施说数据库重启后无法启动，请求恢复，由于这个库数据不是特别重要(Win下的11.2.0.1)，临时用前当天0点的dmp备份恢复了，让业务先用起来。这个周末花了点时间对现场的数据库进行了恢复，记录如下。
启动报错如下：
Trace指示错误如下：
对Trace中索引提取的键值进行查看：
提取表的记录如下：
经对比发现无法启动的原因为：表中没有SYS和SYSTEM用户，只有YGKFSYS和YGKFSYSTEM，可见sys和system用户是被改名了且表和索引存在不一致的信息(索引不存在YGKFSYSTEM这个键值)
修表如下：
BBED> set file 1 block 209
FILE# 1
BLOCK# 209
BBED> p kdbt
struct kdbt[0], 4 bytes @106
sb2 kdbtoffs @106 0
sb2 kdbtnrow @108 21
struct kdbt[1], 4 bytes @110
sb2 kdbtoffs @110 21
sb2 kdbtnrow @112 22
BBED> find /x 03535953 TOP
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4978 to 5041 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
03535953 02c10210 30444343 45413938 32303843 36323532 018002c1 0407786e 031e0b08 37077877 06140e33 2007786e 031e0c07 3907786e 031e0c07 390180ff
<64 bytes per line>
BBED> x /rcnc offset 4969
rowdata[513] @4969
------------
flag@4969: 0x33 (KDRHFN, KDRHFP, KDRHFD, KDRHFH)
lock@4970: 0x43
cols@4971: 0
BBED> x /rcnc *kdbr[23]
rowdata[3398] @7854
-------------
flag@7854: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)
lock@7855: 0x00
cols@7856: 19
col 0[6] @7858: PUBLIC
col 1[1] @7865: 0
col 2[0] @7867: *NULL*
col 3[1] @7868: .
col 4[1] @7870: .
col 5[7] @7872: xn....7
col 6[0] @7880: *NULL*
col 7[0] @7881: *NULL*
col 8[0] @7882: *NULL*
col 9[1] @7883: .
col 10[0] @7885: *NULL*
col 11[2] @7886: ..
col 12[0] @7889: *NULL*
col 13[0] @7890: *NULL*
col 14[1] @7891: .
col 15[1] @7893: .
col 16[22] @7895: DEFAULT_CONSUMER_GROUP
col 17[0] @7918: *NULL*
col 18[1] @7919: .
BBED> x /rcnc offset 4975
rowdata[519] @4975
------------
flag@4975: 0x00 (NONE)
lock@4976: 0x16
cols@4977: 1
nrid@4978:0x03535953.2c1
col 0[2] @4984: .0
BBED> find /x 03535953 top
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4978 to 5041 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
03535953 02c10210 30444343 45413938 32303843 36323532 018002c1 0407786e 031e0b08 37077877 06140e33 2007786e 031e0c07 3907786e 031e0c07 390180ff
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 5318 to 5381 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
03535953 02c10210 44344335 30313630 38364232 44433641 018002c1 0407786e 031e0b08 3707786e 031e0b08 3707786e 031e0c07 3907786e 031e0c07 390180ff
<64 bytes per line>
BBED> x /rcnc offset 5315
rowdata[859] @5315
------------
flag@5315: 0x00 (NONE)
lock@5316: 0x16
cols@5317: 1
nrid@5318:0x03535953.2c1
col 0[2] @5324: .D
BBED> find /c SYS top
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4465 to 4528 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
53595354 454d02c1 02103330 45353733 45383441 37453334 33310180 02c10407 786e031e 0b083807 78770614 0e332007 786e031e 0c073907 786e031e 0c073901
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4640 to 4703 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
53595302 c1021030 44434345 41393832 30384336 32353201 8002c104 07786e03 1e0b0837 07787706 140e3320 07786e03 1e0c0739 07786e03 1e0c0739 0180ff02
<64 bytes per line>
BBED> x /rcnc offset 4462
rowdata[6] @4462
----------
flag@4462: 0x47 (KDRHFN, KDRHFP, KDRHFL, KDRHFC)
lock@4463: 0x4b
cols@4464: 70
ckix@4465: 83
col 0[89] @4466: STEM....30E573E84A7E3431......xn....8.xw...3 .xn....9.xn....9.............DEFAULT_CONSUME
col 1[82] @4556: 0x5f 0x47 0x52 0x4f 0x55 0x50 0xff 0x01 0x80 0xff 0xff 0x3e 0x53 0x3a 0x39 0x39 0x32 0x38 0x41 0x38 0x33 0x36 0x43
0x39 0x34 0x33 0x44 0x31 0x38 0x33 0x37 0x46 0x30 0x38 0x36 0x42 0x33 0x37 0x33 0x46 0x42 0x46 0x36 0x43 0x46 0x43 0x30 0x37 0x30
0x36 0x38 0x36 0x43 0x33 0x39 0x38 0x33 0x43 0x42 0x35 0x43 0x43 0x45 0x37 0x42 0x30 0x36 0x31 0x31 0x33 0x43 0x38 0x38 0x31 0x6c
0x00 0x16 0x01 0x07 0x59 0x47 0x4b
col 2[70] @4639: SYS....0DCCEA98208C6252......xn....7.xw...3 .xn....9.xn....9..........
col 3[1] @4710: .
col 4[22] @4712: DEFAULT_CONSUMER_GROUP
col 5[0] @4735: *NULL*
col 6[1] @4736: .
col 7[0] @4738: *NULL*
col 8[0] @4739: *NULL*
col 9[62] @4740: S:75944620D48E8B9AABCDBBA27932D8472A3F61A493ED8C22CEE97D68BD2C
col 10[108] @4803: ....SYSTEM....30E573E84A7E3431......xn....8.xw...3 .xn....9.xn....9.............DEFAULT_CONSUMER_GROUP.....>
col 11[83] @4912: :9928A836C943D1837F086B373FBF6CFC070686C3983CB5CCE7B06113C881l....SYS....0DCCEA9820
col 12[56] @4996: C6252......xn....7.xw...3 .xn....9.xn....9.............D
col 13[69] @5053: FAULT_CONSUMER_GROUP.....>S:75944620D48E8B9AABCDBBA27932D8472A3F61A49
col 14[51] @5123: ED8C22CEE97D68BD2Cl....SYSTEM....D4DF7931AB130E37..
col 15[2] @5175: ..
col 16[7] @5178: xn....8
col 17[7] @5186: xn....8
col 18[7] @5194: xn....9
col 19[7] @5202: xn....9
col 20[1] @5210: .
col 21[0] @5212: *NULL*
col 22[2] @5213: ..
col 23[0] @5216: *NULL*
col 24[0] @5217: *NULL*
col 25[2] @5218: ..
col 26[1] @5221: .
col 27[22] @5223: DEFAULT_CONSUMER_GROUP
col 28[0] @5246: *NULL*
col 29[1] @5247: .
col 30[0] @5249: *NULL*
col 31[0] @5250: *NULL*
col 32[62] @5251: S:E4847FBF22CDD8078177F621D9C996F031D5C56B02E64DE0927C56EB9C85
col 33[108] @5314: ....SYS....D4C5016086B2DC6A......xn....7.xn....7.xn....9.xn....9..............DEFAULT_CONSUMER_GROUP.....>S:
col 34[65] @5423: 8702456E5B56725AC0AABFD2597A8315CB40DE93E8B27E32A764431AECAl....O
col 35[85] @5489: TLN....4A3BA55E08595C81......xn....9.xn....9.xn......xn...................DEFAULT_CON
col 36[83] @5575: UMER_GROUP.....>S:C65CB394696D9B259B30C2D5A91AA72B08ACC1E06A532BED6C8D22B81B4Al....
col 37[71] @5659: ATHER_SYSTEM_STATISTICS........xn....'................DEFAULT_CONSUMER_
col 38[71] @5731: ROUP...l....ADM_PARALLEL_EXECUTE_TASK........xn.... ................DEF
col 39[65] @5803: ULT_CONSUMER_GROUP...........@.....@.......l....DATAPUMP_IMP_FULL
col 40[95] @5869: DATABASE........xn.....................DEFAULT_CONSUMER_GROUP...........@.....@.......l....DATA
col 41[80] @5965: UMP_EXP_FULL_DATABASE........xn.....................DEFAULT_CONSUMER_GROUP... ..
col 42[0] @6046:
col 43[64] @6047: ....T_USER........xn....7...............DEFAULT_CONSUMER_GROUP..
col 44[128] @6112: ........@.....@.......l....AQ_USER_ROLE........xn.....................DEFAULT_CONSUMER_GROUP...........@.....@.......l....AQ_ADM
col 45[73] @6241: NISTRATOR_ROLE........xn.....................DEFAULT_CONSUMER_GROUP......
col 46[1] @6315: .
col 47[1] @6317: .
col 48[0] @6319:
col 49[64] @6320: .....@.......l....DIP....CE4A36B8E06CA59C.......xn....5.xn....5.
col 50[120] @6385: n....5.xn....5..............DEFAULT_CONSUMER_GROUP.....>S:13F1BFE5EDEFF950269976360A9D0FC70D5B8E4A6A45DD03B2EED8707F3C..
col 51[1] @6506: .
col 52[0] @6508:
col 53[1] @6509: .
col 54[0] @6511:
col 55[64] @6512: .....@.......l....DBFS_ROLE........xn.....................DEFAUL
col 56[84] @6577: _CONSUMER_GROUP...........@.....@.......l....LOGSTDBY_ADMINISTRATOR........xn....)..
col 57[0] @6662: *NULL*
col 58[1] @6663: .
col 59[0] @6665: *NULL*
col 60[2] @6666: ..
col 61[0] @6669: *NULL*
col 62[0] @6670: *NULL*
col 63[1] @6671: .
col 64[1] @6673: .
col 65[22] @6675: DEFAULT_CONSUMER_GROUP
col 66[0] @6698: *NULL*
col 67[1] @6699: .
col 68[172] @6701: .......@.....@.......l....IMP_FULL_DATABASE........xn.....................DEFAULT_CONSUMER_GROUP...........@.....@.......l....EXP_FULL_
DATABASE........xn...................
col 69[128] @6874: .DEFAULT_CONSUMER_GROUP...........@.....@.......l....OUTLN....4A3BA55E08595C81......xn....9.xn....9...............DEFAULT_CONSUM
BBED> x /rcnc offset 4637
rowdata[181] @4637
------------
flag@4637: 0x47 (KDRHFN, KDRHFP, KDRHFL, KDRHFC)
lock@4638: 0x4b
cols@4639: 70
ckix@4640: 83
col 0[89] @4641: S....0DCCEA98208C6252......xn....7.xw...3 .xn....9.xn....9.............DEFAULT_CONSUMER_G
col 1[82] @4731: 0x4f 0x55 0x50 0xff 0x01 0x80 0xff 0xff 0x3e 0x53 0x3a 0x37 0x35 0x39 0x34 0x34 0x36 0x32 0x30 0x44 0x34 0x38 0x45
0x38 0x42 0x39 0x41 0x41 0x42 0x43 0x44 0x42 0x42 0x41 0x32 0x37 0x39 0x33 0x32 0x44 0x38 0x34 0x37 0x32 0x41 0x33 0x46 0x36 0x31
0x41 0x34 0x39 0x33 0x45 0x44 0x38 0x43 0x32 0x32 0x43 0x45 0x45 0x39 0x37 0x44 0x36 0x38 0x42 0x44 0x32 0x43 0x6c 0x00 0x16 0x05
0x06 0x53 0x59 0x53 0x54 0x45 0x4d
col 2[2] @4814: ..
col 3[16] @4817: 30E573E84A7E3431
col 4[1] @4834: .
col 5[2] @4836: ..
col 6[7] @4839: xn....8
col 7[7] @4847: xw...3
col 8[7] @4855: xn....9
col 9[7] @4863: xn....9
col 10[1] @4871: .
col 11[0] @4873: *NULL*
col 12[2] @4874: ..
col 13[0] @4877: *NULL*
col 14[0] @4878: *NULL*
col 15[1] @4879: .
col 16[1] @4881: .
col 17[22] @4883: DEFAULT_CONSUMER_GROUP
col 18[0] @4906: *NULL*
col 19[1] @4907: .
col 20[0] @4909: *NULL*
col 21[0] @4910: *NULL*
col 22[62] @4911: S:9928A836C943D1837F086B373FBF6CFC070686C3983CB5CCE7B06113C881
col 23[108] @4974: ....SYS....0DCCEA98208C6252......xn....7.xw...3 .xn....9.xn....9.............DEFAULT_CONSUMER_GROUP.....>S:7
col 24[53] @5083: 944620D48E8B9AABCDBBA27932D8472A3F61A493ED8C22CEE97D6
col 25[56] @5137: BD2Cl....SYSTEM....D4DF7931AB130E37......xn....8.xn....8
col 26[7] @5194: xn....9
col 27[7] @5202: xn....9
col 28[1] @5210: .
col 29[0] @5212: *NULL*
col 30[2] @5213: ..
col 31[0] @5216: *NULL*
col 32[0] @5217: *NULL*
col 33[2] @5218: ..
col 34[1] @5221: .
col 35[22] @5223: DEFAULT_CONSUMER_GROUP
col 36[0] @5246: *NULL*
col 37[1] @5247: .
col 38[0] @5249: *NULL*
col 39[0] @5250: *NULL*
col 40[62] @5251: S:E4847FBF22CDD8078177F621D9C996F031D5C56B02E64DE0927C56EB9C85
col 41[108] @5314: ....SYS....D4C5016086B2DC6A......xn....7.xn....7.xn....9.xn....9..............DEFAULT_CONSUMER_GROUP.....>S:
col 42[65] @5423: 8702456E5B56725AC0AABFD2597A8315CB40DE93E8B27E32A764431AECAl....O
col 43[85] @5489: TLN....4A3BA55E08595C81......xn....9.xn....9.xn......xn...................DEFAULT_CON
col 44[83] @5575: UMER_GROUP.....>S:C65CB394696D9B259B30C2D5A91AA72B08ACC1E06A532BED6C8D22B81B4Al....
col 45[71] @5659: ATHER_SYSTEM_STATISTICS........xn....'................DEFAULT_CONSUMER_
col 46[71] @5731: ROUP...l....ADM_PARALLEL_EXECUTE_TASK........xn.... ................DEF
col 47[65] @5803: ULT_CONSUMER_GROUP...........@.....@.......l....DATAPUMP_IMP_FULL
col 48[95] @5869: DATABASE........xn.....................DEFAULT_CONSUMER_GROUP...........@.....@.......l....DATA
col 49[80] @5965: UMP_EXP_FULL_DATABASE........xn.....................DEFAULT_CONSUMER_GROUP... ..
col 50[0] @6046:
col 51[64] @6047: ....T_USER........xn....7...............DEFAULT_CONSUMER_GROUP..
col 52[128] @6112: ........@.....@.......l....AQ_USER_ROLE........xn.....................DEFAULT_CONSUMER_GROUP...........@.....@.......l....AQ_ADM
col 53[73] @6241: NISTRATOR_ROLE........xn.....................DEFAULT_CONSUMER_GROUP......
col 54[1] @6315: .
col 55[1] @6317: .
col 56[0] @6319:
col 57[64] @6320: .....@.......l....DIP....CE4A36B8E06CA59C.......xn....5.xn....5.
col 58[120] @6385: n....5.xn....5..............DEFAULT_CONSUMER_GROUP.....>S:13F1BFE5EDEFF950269976360A9D0FC70D5B8E4A6A45DD03B2EED8707F3C..
col 59[1] @6506: .
col 60[0] @6508:
col 61[1] @6509: .
col 62[0] @6511:
col 63[64] @6512: .....@.......l....DBFS_ROLE........xn.....................DEFAUL
col 64[84] @6577: _CONSUMER_GROUP...........@.....@.......l....LOGSTDBY_ADMINISTRATOR........xn....)..
col 65[0] @6662: *NULL*
col 66[1] @6663: .
col 67[0] @6665: *NULL*
col 68[2] @6666: ..
col 69[0] @6669: *NULL*
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4640 to 4703 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
53595302 c1021030 44434345 41393832 30384336 32353201 8002c104 07786e03 1e0b0837 07787706 140e3320 07786e03 1e0c0739 07786e03 1e0c0739 0180ff02
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4808 to 4871 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
53595354 454d02c1 02103330 45353733 45383441 37453334 33310180 02c10407 786e031e 0b083807 78770614 0e332007 786e031e 0c073907 786e031e 0c073901
<64 bytes per line>
BBED> x /rcnc offset 4805
rowdata[349] @4805
------------
flag@4805: 0x16 (KDRHFP, KDRHFL, KDRHFD)
lock@4806: 0x05
cols@4807: 0
BBED> find /x 03535953 top
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4978 to 5041 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
03535953 02c10210 30444343 45413938 32303843 36323532 018002c1 0407786e 031e0b08 37077877 06140e33 2007786e 031e0c07 3907786e 031e0c07 390180ff
<64 bytes per line>
BBED> show
FILE# 1
BLOCK# 209
OFFSET 4978
DBA 0x004000d1 (4194513 1,209)
FILENAME /home/oracle/SYSTEM01.DBF
BIFILE bifile.bbd
LISTFILE /home/oracle/bbed/listfile.txt
BLOCKSIZE 8192
MODE Edit
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 160
COUNT 64
LOGFILE log.bbd
SPOOL Yes
BBED> set file 1 block 209
FILE# 1
BLOCK# 209
BBED> find /x 03535953 top
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4978 to 5041 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
03535953 02c10210 30444343 45413938 32303843 36323532 018002c1 0407786e 031e0b08 37077877 06140e33 2007786e 031e0c07 3907786e 031e0c07 390180ff
<64 bytes per line>
BBED> x /rcnc offset 4975
rowdata[519] @4975
------------
flag@4975: 0x00 (NONE)
lock@4976: 0x16
cols@4977: 1
nrid@4978:0x03535953.2c1
col 0[2] @4984: .0
BBED> find /c SYS top
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4465 to 4528 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
53595354 454d02c1 02103330 45353733 45383441 37453334 33310180 02c10407 786e031e 0b083807 78770614 0e332007 786e031e 0c073907 786e031e 0c073901
<64 bytes per line>
BBED> set offset 0
OFFSET 0
BBED> find /c SYS top
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4465 to 4528 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
53595354 454d02c1 02103330 45353733 45383441 37453334 33310180 02c10407 786e031e 0b083807 78770614 0e332007 786e031e 0c073907 786e031e 0c073901
<64 bytes per line>
BBED> find /x 03535953 top
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4978 to 5041 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
03535953 02c10210 30444343 45413938 32303843 36323532 018002c1 0407786e 031e0b08 37077877 06140e33 2007786e 031e0c07 3907786e 031e0c07 390180ff
<64 bytes per line>
BBED> x /rcnc offset 4974
rowdata[518] @4974
------------
flag@4974: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)
lock@4975: 0x00
cols@4976: 22
ckix@4977: 1
col 0[3] @4978: SYS
col 1[2] @4982: 1
col 2[16] @4985: 0DCCEA98208C6252
col 3[1] @5002: .
col 4[2] @5004: ..
col 5[7] @5007: xn....7
col 6[7] @5015: xw...3
col 7[7] @5023: xn....9
col 8[7] @5031: xn....9
col 9[1] @5039: .
col 10[0] @5041: *NULL*
col 11[2] @5042: ..
col 12[0] @5045: *NULL*
col 13[0] @5046: *NULL*
col 14[1] @5047: .
col 15[1] @5049: .
col 16[22] @5051: DEFAULT_CONSUMER_GROUP
col 17[0] @5074: *NULL*
col 18[1] @5075: .
col 19[0] @5077: *NULL*
col 20[0] @5078: *NULL*
col 21[62] @5079: S:75944620D48E8B9AABCDBBA27932D8472A3F61A493ED8C22CEE97D68BD2C
BBED> x /rcnc offset 4461
rowdata[5] @4461
----------
flag@4461: 0x59 (KDRHFN, KDRHFF, KDRHFD, KDRHFC)
lock@4462: 0x47
cols@4463: 0
ckix@4464: 70
BBED> find /C SYS top
BBED-00201: invalid switch (/C)
BBED> find /c SYS top
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4465 to 4528 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
53595354 454d02c1 02103330 45353733 45383441 37453334 33310180 02c10407 786e031e 0b083807 78770614 0e332007 786e031e 0c073907 786e031e 0c073901
<64 bytes per line>
BBED> p kdbt
struct kdbt[0], 4 bytes @106
sb2 kdbtoffs @106 0
sb2 kdbtnrow @108 21
struct kdbt[1], 4 bytes @110
sb2 kdbtoffs @110 21
sb2 kdbtnrow @112 22
BBED> p *kdbr[21]
rowdata[1587]
-------------
ub1 rowdata[1587] @6043 0x20
BBED> x /rcnc
rowdata[1587] @6043
-------------
flag@6043: 0x20 (KDRHFH)
lock@6044: 0x00
cols@6045: 0
nrid@6046:0x004000d5.0
BBED> p *kdbr[22]
rowdata[175]
------------
ub1 rowdata[175] @4631 0x6c
BBED> x /rcnc
rowdata[175] @4631
------------
flag@4631: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)
lock@4632: 0x00
cols@4633: 22
ckix@4634: 1
col 0[7] @4635: YGKFSYS
col 1[2] @4643: 1
col 2[16] @4646: 0DCCEA98208C6252
col 3[1] @4663: .
col 4[2] @4665: ..
col 5[7] @4668: xn....7
col 6[7] @4676: xw...3
col 7[7] @4684: xn....9
col 8[7] @4692: xn....9
col 9[1] @4700: .
col 10[0] @4702: *NULL*
col 11[2] @4703: ..
col 12[0] @4706: *NULL*
col 13[0] @4707: *NULL*
col 14[1] @4708: .
col 15[1] @4710: .
col 16[22] @4712: DEFAULT_CONSUMER_GROUP
col 17[0] @4735: *NULL*
col 18[1] @4736: .
col 19[0] @4738: *NULL*
col 20[0] @4739: *NULL*
col 21[62] @4740: S:75944620D48E8B9AABCDBBA27932D8472A3F61A493ED8C22CEE97D68BD2C
BBED> p kdbr[22]
sb2 kdbr[22] @158 4539
BBED> modify /x 1213 offset 158
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 158 to 221 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
1213521e f81d9d1d 471d0c11 2e1cc71b 611b0f15 4b1ae719 7e192219 6218fa17 9b17e816 7b160f16 ba150000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 209:
current = 0x3766, required = 0x3766
BBED> p *kdbr[25]
rowdata[3217]
-------------
ub1 rowdata[3217] @7673 0x6c
BBED> x /rcnc
rowdata[3217] @7673
-------------
flag@7673: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)
lock@7674: 0x00
cols@7675: 19
ckix@7676: 3
col 0[8] @7677: RESOURCE
col 1[1] @7686: 0
col 2[0] @7688: *NULL*
col 3[1] @7689: .
col 4[1] @7691: .
col 5[7] @7693: xn....7
col 6[0] @7701: *NULL*
col 7[0] @7702: *NULL*
col 8[0] @7703: *NULL*
col 9[1] @7704: .
col 10[0] @7706: *NULL*
col 11[2] @7707: ..
col 12[0] @7710: *NULL*
col 13[0] @7711: *NULL*
col 14[1] @7712: .
col 15[1] @7714: .
col 16[22] @7716: DEFAULT_CONSUMER_GROUP
col 17[0] @7739: *NULL*
col 18[1] @7740: .
BBED> p *kdbr[26]
rowdata[3131]
-------------
ub1 rowdata[3131] @7587 0x6c
BBED> x /rcnc
rowdata[3131] @7587
-------------
flag@7587: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)
lock@7588: 0x00
cols@7589: 19
ckix@7590: 4
col 0[3] @7591: DBA
col 1[1] @7595: 0
col 2[0] @7597: *NULL*
col 3[1] @7598: .
col 4[1] @7600: .
col 5[7] @7602: xn....8
col 6[0] @7610: *NULL*
col 7[0] @7611: *NULL*
col 8[0] @7612: *NULL*
col 9[1] @7613: .
col 10[0] @7615: *NULL*
col 11[2] @7616: ..
col 12[0] @7619: *NULL*
col 13[0] @7620: *NULL*
col 14[1] @7621: .
col 15[1] @7623: .
col 16[22] @7625: DEFAULT_CONSUMER_GROUP
col 17[0] @7648: *NULL*
col 18[1] @7649: .
BBED> p *kdbr[27]
rowdata[0]
----------
ub1 rowdata[0] @4456 0x6c
BBED> x /rcnc
rowdata[0] @4456
----------
flag@4456: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)
lock@4457: 0x02
cols@4458: 22
ckix@4459: 5
col 0[10] @4460: YGKFSYSTEM
col 1[2] @4471: 1
col 2[16] @4474: 30E573E84A7E3431
col 3[1] @4491: .
col 4[2] @4493: ..
col 5[7] @4496: xn....8
col 6[7] @4504: xw...3
col 7[7] @4512: xn....9
col 8[7] @4520: xn....9
col 9[1] @4528: .
col 10[0] @4530: *NULL*
col 11[2] @4531: ..
col 12[0] @4534: *NULL*
col 13[0] @4535: *NULL*
col 14[1] @4536: .
col 15[1] @4538: .
col 16[22] @4540: DEFAULT_CONSUMER_GROUP
col 17[0] @4563: *NULL*
col 18[1] @4564: .
col 19[0] @4566: *NULL*
col 20[0] @4567: *NULL*
col 21[62] @4568: S:9928A836C943D1837F086B373FBF6CFC070686C3983CB5CCE7B06113C881
BBED> find /x 06535953 top
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4807 to 4870 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
06535953 54454d02 c1021033 30453537 33453834 41374533 34333101 8002c104 07786e03 1e0b0838 07787706 140e3320 07786e03 1e0c0739 07786e03 1e0c0739
<64 bytes per line>
BBED> x /rcnc offset 4803
rowdata[347] @4803
------------
flag@4803: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)
lock@4804: 0x00
cols@4805: 22
ckix@4806: 5
col 0[6] @4807: SYSTEM
col 1[2] @4814: 1
col 2[16] @4817: 30E573E84A7E3431
col 3[1] @4834: .
col 4[2] @4836: ..
col 5[7] @4839: xn....8
col 6[7] @4847: xw...3
col 7[7] @4855: xn....9
col 8[7] @4863: xn....9
col 9[1] @4871: .
col 10[0] @4873: *NULL*
col 11[2] @4874: ..
col 12[0] @4877: *NULL*
col 13[0] @4878: *NULL*
col 14[1] @4879: .
col 15[1] @4881: .
col 16[22] @4883: DEFAULT_CONSUMER_GROUP
col 17[0] @4906: *NULL*
col 18[1] @4907: .
col 19[0] @4909: *NULL*
col 20[0] @4910: *NULL*
col 21[62] @4911: S:9928A836C943D1837F086B373FBF6CFC070686C3983CB5CCE7B06113C881
BBED> p kdbr[27]
sb2 kdbr[27] @168 4364
BBED> modify /x 6712 offset 168
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 168 to 231 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
67122e1c c71b611b 0f154b1a e7197e19 22196218 fa179b17 e8167b16 0f16ba15 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 209:
current = 0x340d, required = 0x340d
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 209
Block Checking: DBA = 4194513, Block Type = KTB-managed data block
data header at 0x7f0216a2325c
kdbchk: xaction header lock count mismatch
trans=2 ilk=1 nlo=0
Block 209 failed with check code 6108
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> p *kdbr[27]
rowdata[347]
------------
ub1 rowdata[347] @4803 0x6c
BBED> x /rcnc
rowdata[347] @4803
------------
flag@4803: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)
lock@4804: 0x00
cols@4805: 22
ckix@4806: 5
col 0[6] @4807: SYSTEM
col 1[2] @4814: 1
col 2[16] @4817: 30E573E84A7E3431
col 3[1] @4834: .
col 4[2] @4836: ..
col 5[7] @4839: xn....8
col 6[7] @4847: xw...3
col 7[7] @4855: xn....9
col 8[7] @4863: xn....9
col 9[1] @4871: .
col 10[0] @4873: *NULL*
col 11[2] @4874: ..
col 12[0] @4877: *NULL*
col 13[0] @4878: *NULL*
col 14[1] @4879: .
col 15[1] @4881: .
col 16[22] @4883: DEFAULT_CONSUMER_GROUP
col 17[0] @4906: *NULL*
col 18[1] @4907: .
col 19[0] @4909: *NULL*
col 20[0] @4910: *NULL*
col 21[62] @4911: S:9928A836C943D1837F086B373FBF6CFC070686C3983CB5CCE7B06113C881
BBED> p *kdbr[22]
rowdata[518]
------------
ub1 rowdata[518] @4974 0x6c
BBED> x /rcnc
rowdata[518] @4974
------------
flag@4974: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)
lock@4975: 0x00
cols@4976: 22
ckix@4977: 1
col 0[3] @4978: SYS
col 1[2] @4982: 1
col 2[16] @4985: 0DCCEA98208C6252
col 3[1] @5002: .
col 4[2] @5004: ..
col 5[7] @5007: xn....7
col 6[7] @5015: xw...3
col 7[7] @5023: xn....9
col 8[7] @5031: xn....9
col 9[1] @5039: .
col 10[0] @5041: *NULL*
col 11[2] @5042: ..
col 12[0] @5045: *NULL*
col 13[0] @5046: *NULL*
col 14[1] @5047: .
col 15[1] @5049: .
col 16[22] @5051: DEFAULT_CONSUMER_GROUP
col 17[0] @5074: *NULL*
col 18[1] @5075: .
col 19[0] @5077: *NULL*
col 20[0] @5078: *NULL*
col 21[62] @5079: S:75944620D48E8B9AABCDBBA27932D8472A3F61A493ED8C22CEE97D68BD2C
BBED> map
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Dba:0x004000d1
------------------------------------------------------------
KTB Data Block (Table/Cluster)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdbh, 14 bytes @92
struct kdbt[2], 8 bytes @106
sb2 kdbr[43] @114
ub1 freespace[4256] @200
ub1 rowdata[3732] @4456
ub4 tailchk @8188
BBED> p ktbbh
struct ktbbh, 72 bytes @20
ub1 ktbbhtyp @20 0x01 (KDDBTDATA)
union ktbbhsid, 4 bytes @24
ub4 ktbbhsg1 @24 0x0000000a
ub4 ktbbhod1 @24 0x0000000a
struct ktbbhcsc, 8 bytes @28
ub4 kscnbas @28 0x37274b5c
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 0x0006
ub2 kxidslt @46 0x001c
ub4 kxidsqn @48 0x00000076
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00c01bfa
ub2 kubaseq @56 0x0014
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 0x0001e3cf
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0013
ub2 kxidslt @70 0x0015
ub4 kxidsqn @72 0x0000080a
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00c02081
ub2 kubaseq @80 0x0185
ub1 kubarec @82 0x03
ub2 ktbitflg @84 0x2001 (KTBFUPB)
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 0
ub2 _ktbitwrp @86 0x0000
ub4 ktbitbas @88 0x37274b5e
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 209
Block Checking: DBA = 4194513, Block Type = KTB-managed data block
data header at 0xbdba5c
kdbchk: xaction header lock count mismatch
trans=2 ilk=1 nlo=0
Block 209 failed with check code 6108
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 *kdbr[27]
rowdata[347]
------------
ub1 rowdata[347] @4803 0x6c
BBED> x /rcnc
rowdata[347] @4803
------------
flag@4803: 0x6c (KDRHFL, KDRHFF, KDRHFH, KDRHFC)
lock@4804: 0x00
cols@4805: 22
ckix@4806: 5
col 0[6] @4807: SYSTEM
col 1[2] @4814: 1
col 2[16] @4817: 30E573E84A7E3431
col 3[1] @4834: .
col 4[2] @4836: ..
col 5[7] @4839: xn....8
col 6[7] @4847: xw...3
col 7[7] @4855: xn....9
col 8[7] @4863: xn....9
col 9[1] @4871: .
col 10[0] @4873: *NULL*
col 11[2] @4874: ..
col 12[0] @4877: *NULL*
col 13[0] @4878: *NULL*
col 14[1] @4879: .
col 15[1] @4881: .
col 16[22] @4883: DEFAULT_CONSUMER_GROUP
col 17[0] @4906: *NULL*
col 18[1] @4907: .
col 19[0] @4909: *NULL*
col 20[0] @4910: *NULL*
col 21[62] @4911: S:9928A836C943D1837F086B373FBF6CFC070686C3983CB5CCE7B06113C881
BBED> modify /x 02 offset 4804
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 4804 to 4867 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
02160506 53595354 454d02c1 02103330 45353733 45383441 37453334 33310180 02c10407 786e031e 0b083807 78770614 0e332007 786e031e 0c073907 786e031e
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 209:
current = 0x340f, required = 0x340f
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 209
Block Checking: DBA = 4194513, Block Type = KTB-managed data block
data header at 0xc05c5c
kdbchk: the amount of space used is not equal to block size
used=2576 fsc=0 avsp=5512 dtl=8096
Block 209 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
BBED> p kdbh
struct kdbh, 14 bytes @92
ub1 kdbhflag @92 0x00 (NONE)
sb1 kdbhntab @93 2
sb2 kdbhnrow @94 43
sb2 kdbhfrre @96 -1
sb2 kdbhfsbo @98 108
sb2 kdbhfseo @100 4364
sb2 kdbhavsp @102 5512
sb2 kdbhtosp @104 5512
BBED> modify /x 9015 offset 102
File: /home/oracle/SYSTEM01.DBF (1)
Block: 209 Offsets: 102 to 165 Dba:0x004000d1
------------------------------------------------------------------------------------------------------------------------------------------------
90158815 00001500 15001600 8a1f451f 951e3c1e e21d871d 311d7e1c 181cb11b 4b1b991a 351ad119 68190c19 4c18e417 8517d216 65163f17 1213521e f81d9d1d
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 209:
current = 0x3417, required = 0x3417
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 209
Block Checking: DBA = 4194513, Block Type = KTB-managed data block
data header at 0xc0665c
kdbchk: avsp(5520) > tosp(5512)
Block 209 failed with check code 6128
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> sum apply
Check value for File 1, Block 209:
current = 0x340f, required = 0x340f
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 209
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> set file 1 block 417
FILE# 1
BLOCK# 417
BBED> map
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Dba:0x004001a1
------------------------------------------------------------
KTB Data Block (Index Leaf)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdxle, 32 bytes @92
sb2 kd_off[90] @124
ub1 freespace[5804] @304
ub1 rowdata[2012] @6108
ub4 tailchk @8188
BBED> p *kd_off[77]
rowdata[406]
------------
ub1 rowdata[406] @6514 0x00
BBED> x /rc
rowdata[406] @6514
------------
flag@6514: 0x00 (NONE)
lock@6515: 0x00
keydata[6]: 0x00 0x40 0x00 0xd4 0x00 0x0c
data key:
col 0[6] @6523: SYSMAN
BBED> p kdxle
struct kdxle, 32 bytes @92
struct kdxlexco, 16 bytes @92
ub1 kdxcolev @92 0x00
ub1 kdxcolok @93 0x00
ub1 kdxcoopc @94 0x80
ub1 kdxconco @95 0x01
ub4 kdxcosdc @96 0x00000000
sb2 kdxconro @100 90
sb2 kdxcofbo @102 216
sb2 kdxcofeo @104 6020
sb2 kdxcoavs @106 5892
sb2 kdxlespl @108 0
sb2 kdxlende @110 1
ub4 kdxlenxt @112 0x00000000
ub4 kdxleprv @116 0x00000000
ub1 kdxledsz @120 0x06
ub1 kdxleflg @121 0x00 (NONE)
BBED> modify /x 5b offset 100
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 100 to 163 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
5b00d800 84170417 00000100 00000000 00000000 06000000 641f0000 8b1d5e1b 9118a518 c5186a1c 081ef31d 1b1b261f 25197c1b 8b1be019 d01dad1d 091f321e
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe9e1, required = 0xe9e1
BBED> p kdxle
struct kdxle, 32 bytes @92
struct kdxlexco, 16 bytes @92
ub1 kdxcolev @92 0x00
ub1 kdxcolok @93 0x00
ub1 kdxcoopc @94 0x80
ub1 kdxconco @95 0x01
ub4 kdxcosdc @96 0x00000000
sb2 kdxconro @100 91
sb2 kdxcofbo @102 216
sb2 kdxcofeo @104 6020
sb2 kdxcoavs @106 5892
sb2 kdxlespl @108 0
sb2 kdxlende @110 1
ub4 kdxlenxt @112 0x00000000
ub4 kdxleprv @116 0x00000000
ub1 kdxledsz @120 0x06
ub1 kdxleflg @121 0x00 (NONE)
BBED> p /x kd_off
sb2 kd_off[0] @124 0x1f64
sb2 kd_off[1] @126 0x0
sb2 kd_off[2] @128 0x1d8b
sb2 kd_off[3] @130 0x1b5e
sb2 kd_off[4] @132 0x1891
sb2 kd_off[5] @134 0x18a5
sb2 kd_off[6] @136 0x18c5
sb2 kd_off[7] @138 0x1c6a
sb2 kd_off[8] @140 0x1e08
sb2 kd_off[9] @142 0x1df3
sb2 kd_off[10] @144 0x1b1b
sb2 kd_off[11] @146 0x1f26
sb2 kd_off[12] @148 0x1925
sb2 kd_off[13] @150 0x1b7c
sb2 kd_off[14] @152 0x1b8b
sb2 kd_off[15] @154 0x19e0
sb2 kd_off[16] @156 0x1dd0
sb2 kd_off[17] @158 0x1dad
sb2 kd_off[18] @160 0x1f09
sb2 kd_off[19] @162 0x1e32
sb2 kd_off[20] @164 0x1c7c
sb2 kd_off[21] @166 0x1ea5
sb2 kd_off[22] @168 0x1e26
sb2 kd_off[23] @170 0x1be2
sb2 kd_off[24] @172 0x1ec1
sb2 kd_off[25] @174 0x1b9a
sb2 kd_off[26] @176 0x1e7d
sb2 kd_off[27] @178 0x18de
sb2 kd_off[28] @180 0x1d6a
sb2 kd_off[29] @182 0x1cb3
sb2 kd_off[30] @184 0x1ce5
sb2 kd_off[31] @186 0x1ccf
sb2 kd_off[32] @188 0x1d03
sb2 kd_off[33] @190 0x1e63
sb2 kd_off[34] @192 0x1bf4
sb2 kd_off[35] @194 0x1c1e
sb2 kd_off[36] @196 0x1c0a
sb2 kd_off[37] @198 0x1c31
sb2 kd_off[38] @200 0x1bbd
sb2 kd_off[39] @202 0x1ba9
sb2 kd_off[40] @204 0x1bd0
sb2 kd_off[41] @206 0x17a7
sb2 kd_off[42] @208 0x17f3
sb2 kd_off[43] @210 0x1e44
sb2 kd_off[44] @212 0x19bf
sb2 kd_off[45] @214 0x1a52
sb2 kd_off[46] @216 0x1904
sb2 kd_off[47] @218 0x18f2
sb2 kd_off[48] @220 0x1c9f
sb2 kd_off[49] @222 0x1c8b
sb2 kd_off[50] @224 0x1a28
sb2 kd_off[51] @226 0x1a02
sb2 kd_off[52] @228 0x19f1
sb2 kd_off[53] @230 0x19ce
sb2 kd_off[54] @232 0x1a12
sb2 kd_off[55] @234 0x1d57
sb2 kd_off[56] @236 0x1a41
sb2 kd_off[57] @238 0x1a8e
sb2 kd_off[58] @240 0x1a7b
sb2 kd_off[59] @242 0x1a9e
sb2 kd_off[60] @244 0x1e97
sb2 kd_off[61] @246 0x186f
sb2 kd_off[62] @248 0x1882
sb2 kd_off[63] @250 0x182b
sb2 kd_off[64] @252 0x1851
sb2 kd_off[65] @254 0x1840
sb2 kd_off[66] @256 0x1f36
sb2 kd_off[67] @258 0x1d38
sb2 kd_off[68] @260 0x1f15
sb2 kd_off[69] @262 0x1d20
sb2 kd_off[70] @264 0x181d
sb2 kd_off[71] @266 0x1ede
sb2 kd_off[72] @268 0x1a60
sb2 kd_off[73] @270 0x1958
sb2 kd_off[74] @272 0x193a
sb2 kd_off[75] @274 0x19a5
sb2 kd_off[76] @276 0x1987
sb2 kd_off[77] @278 0x1916
sb2 kd_off[78] @280 0x1efa
sb2 kd_off[79] @282 0x1972
sb2 kd_off[80] @284 0x1c5c
sb2 kd_off[81] @286 0x1c46
sb2 kd_off[82] @288 0x1b70
sb2 kd_off[83] @290 0x1b4d
sb2 kd_off[84] @292 0x1b35
sb2 kd_off[85] @294 0x1b03
sb2 kd_off[86] @296 0x1abd
sb2 kd_off[87] @298 0x1adf
sb2 kd_off[88] @300 0x1aad
sb2 kd_off[89] @302 0x1797
sb2 kd_off[90] @304 0x1784
BBED> modify /x 9717 offset 304
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 304 to 367 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
9717511f 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> modify /x ad1a offset 302
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 302 to 365 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
ad1a9717 511f0000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> modify /x df1a offset 300
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 300 to 363 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
df1aad1a 9717511f 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> modify /x bd1a offset 298
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 298 to 361 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
bd1adf1a ad1a9717 511f0000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> modify /x 031b offset 296
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 296 to 359 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
031bbd1a df1aad1a 9717511f 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> modify /x 351b offset 294
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 294 to 357 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
351b031b bd1adf1a ad1a9717 511f0000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> modify /x 4d1b offset 292
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 292 to 355 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
4d1b351b 031bbd1a df1aad1a 9717511f 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> modify /x 701b offset 290
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 290 to 353 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
701b4d1b 351b031b bd1adf1a ad1a9717 511f0000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> modify /x 461c offset 288
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 288 to 351 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
461c701b 4d1b351b 031bbd1a df1aad1a 9717511f 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> modify /x 5c1c offset 286
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 286 to 349 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
5c1c461c 701b4d1b 351b031b bd1adf1a ad1a9717 511f0000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> modify /x 7219 offset 284
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 284 to 347 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
72195c1c 461c701b 4d1b351b 031bbd1a df1aad1a 9717511f 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> modify /x fa1e offset 282
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 282 to 345 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
fa1e7219 5c1c461c 701b4d1b 351b031b bd1adf1a ad1a9717 511f0000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> modify /x 1619 offset 280
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 280 to 343 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
1619fa1e 72195c1c 461c701b 4d1b351b 031bbd1a df1aad1a 9717511f 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe773, required = 0xe773
BBED> p kd_off
sb2 kd_off[0] @124 8036
sb2 kd_off[1] @126 0
sb2 kd_off[2] @128 7563
sb2 kd_off[3] @130 7006
sb2 kd_off[4] @132 6289
sb2 kd_off[5] @134 6309
sb2 kd_off[6] @136 6341
sb2 kd_off[7] @138 7274
sb2 kd_off[8] @140 7688
sb2 kd_off[9] @142 7667
sb2 kd_off[10] @144 6939
sb2 kd_off[11] @146 7974
sb2 kd_off[12] @148 6437
sb2 kd_off[13] @150 7036
sb2 kd_off[14] @152 7051
sb2 kd_off[15] @154 6624
sb2 kd_off[16] @156 7632
sb2 kd_off[17] @158 7597
sb2 kd_off[18] @160 7945
sb2 kd_off[19] @162 7730
sb2 kd_off[20] @164 7292
sb2 kd_off[21] @166 7845
sb2 kd_off[22] @168 7718
sb2 kd_off[23] @170 7138
sb2 kd_off[24] @172 7873
sb2 kd_off[25] @174 7066
sb2 kd_off[26] @176 7805
sb2 kd_off[27] @178 6366
sb2 kd_off[28] @180 7530
sb2 kd_off[29] @182 7347
sb2 kd_off[30] @184 7397
sb2 kd_off[31] @186 7375
sb2 kd_off[32] @188 7427
sb2 kd_off[33] @190 7779
sb2 kd_off[34] @192 7156
sb2 kd_off[35] @194 7198
sb2 kd_off[36] @196 7178
sb2 kd_off[37] @198 7217
sb2 kd_off[38] @200 7101
sb2 kd_off[39] @202 7081
sb2 kd_off[40] @204 7120
sb2 kd_off[41] @206 6055
sb2 kd_off[42] @208 6131
sb2 kd_off[43] @210 7748
sb2 kd_off[44] @212 6591
sb2 kd_off[45] @214 6738
sb2 kd_off[46] @216 6404
sb2 kd_off[47] @218 6386
sb2 kd_off[48] @220 7327
sb2 kd_off[49] @222 7307
sb2 kd_off[50] @224 6696
sb2 kd_off[51] @226 6658
sb2 kd_off[52] @228 6641
sb2 kd_off[53] @230 6606
sb2 kd_off[54] @232 6674
sb2 kd_off[55] @234 7511
sb2 kd_off[56] @236 6721
sb2 kd_off[57] @238 6798
sb2 kd_off[58] @240 6779
sb2 kd_off[59] @242 6814
sb2 kd_off[60] @244 7831
sb2 kd_off[61] @246 6255
sb2 kd_off[62] @248 6274
sb2 kd_off[63] @250 6187
sb2 kd_off[64] @252 6225
sb2 kd_off[65] @254 6208
sb2 kd_off[66] @256 7990
sb2 kd_off[67] @258 7480
sb2 kd_off[68] @260 7957
sb2 kd_off[69] @262 7456
sb2 kd_off[70] @264 6173
sb2 kd_off[71] @266 7902
sb2 kd_off[72] @268 6752
sb2 kd_off[73] @270 6488
sb2 kd_off[74] @272 6458
sb2 kd_off[75] @274 6565
sb2 kd_off[76] @276 6535
sb2 kd_off[77] @278 6422
sb2 kd_off[78] @280 6422
sb2 kd_off[79] @282 7930
sb2 kd_off[80] @284 6514
sb2 kd_off[81] @286 7260
sb2 kd_off[82] @288 7238
sb2 kd_off[83] @290 7024
sb2 kd_off[84] @292 6989
sb2 kd_off[85] @294 6965
sb2 kd_off[86] @296 6915
sb2 kd_off[87] @298 6845
sb2 kd_off[88] @300 6879
sb2 kd_off[89] @302 6829
sb2 kd_off[90] @304 6039
BBED> p *kd_off[89]
rowdata[811]
------------
ub1 rowdata[811] @6921 0x00
BBED> p kd_off
sb2 kd_off[0] @124 8036
sb2 kd_off[1] @126 0
sb2 kd_off[2] @128 7563
sb2 kd_off[3] @130 7006
sb2 kd_off[4] @132 6289
sb2 kd_off[5] @134 6309
sb2 kd_off[6] @136 6341
sb2 kd_off[7] @138 7274
sb2 kd_off[8] @140 7688
sb2 kd_off[9] @142 7667
sb2 kd_off[10] @144 6939
sb2 kd_off[11] @146 7974
sb2 kd_off[12] @148 6437
sb2 kd_off[13] @150 7036
sb2 kd_off[14] @152 7051
sb2 kd_off[15] @154 6624
sb2 kd_off[16] @156 7632
sb2 kd_off[17] @158 7597
sb2 kd_off[18] @160 7945
sb2 kd_off[19] @162 7730
sb2 kd_off[20] @164 7292
sb2 kd_off[21] @166 7845
sb2 kd_off[22] @168 7718
sb2 kd_off[23] @170 7138
sb2 kd_off[24] @172 7873
sb2 kd_off[25] @174 7066
sb2 kd_off[26] @176 7805
sb2 kd_off[27] @178 6366
sb2 kd_off[28] @180 7530
sb2 kd_off[29] @182 7347
sb2 kd_off[30] @184 7397
sb2 kd_off[31] @186 7375
sb2 kd_off[32] @188 7427
sb2 kd_off[33] @190 7779
sb2 kd_off[34] @192 7156
sb2 kd_off[35] @194 7198
sb2 kd_off[36] @196 7178
sb2 kd_off[37] @198 7217
sb2 kd_off[38] @200 7101
sb2 kd_off[39] @202 7081
sb2 kd_off[40] @204 7120
sb2 kd_off[41] @206 6055
sb2 kd_off[42] @208 6131
sb2 kd_off[43] @210 7748
sb2 kd_off[44] @212 6591
sb2 kd_off[45] @214 6738
sb2 kd_off[46] @216 6404
sb2 kd_off[47] @218 6386
sb2 kd_off[48] @220 7327
sb2 kd_off[49] @222 7307
sb2 kd_off[50] @224 6696
sb2 kd_off[51] @226 6658
sb2 kd_off[52] @228 6641
sb2 kd_off[53] @230 6606
sb2 kd_off[54] @232 6674
sb2 kd_off[55] @234 7511
sb2 kd_off[56] @236 6721
sb2 kd_off[57] @238 6798
sb2 kd_off[58] @240 6779
sb2 kd_off[59] @242 6814
sb2 kd_off[60] @244 7831
sb2 kd_off[61] @246 6255
sb2 kd_off[62] @248 6274
sb2 kd_off[63] @250 6187
sb2 kd_off[64] @252 6225
sb2 kd_off[65] @254 6208
sb2 kd_off[66] @256 7990
sb2 kd_off[67] @258 7480
sb2 kd_off[68] @260 7957
sb2 kd_off[69] @262 7456
sb2 kd_off[70] @264 6173
sb2 kd_off[71] @266 7902
sb2 kd_off[72] @268 6752
sb2 kd_off[73] @270 6488
sb2 kd_off[74] @272 6458
sb2 kd_off[75] @274 6565
sb2 kd_off[76] @276 6535
sb2 kd_off[77] @278 6422
sb2 kd_off[78] @280 6422
sb2 kd_off[79] @282 7930
sb2 kd_off[80] @284 6514
sb2 kd_off[81] @286 7260
sb2 kd_off[82] @288 7238
sb2 kd_off[83] @290 7024
sb2 kd_off[84] @292 6989
sb2 kd_off[85] @294 6965
sb2 kd_off[86] @296 6915
sb2 kd_off[87] @298 6845
sb2 kd_off[88] @300 6879
sb2 kd_off[89] @302 6829
sb2 kd_off[90] @304 6039
BBED> p *kd_off[89]
rowdata[811]
------------
ub1 rowdata[811] @6921 0x00
BBED> p kd_off[89]
sb2 kd_off[89] @302 6829
BBED> find /x 03535953 top
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8105 to 8168 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
03535953 00000040 00d10000 0a5f4e45 58545f55 53455200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> f
BBED-00212: search string not found
BBED> f
BBED-00212: search string not found
BBED> p *kd_off[89]
rowdata[811]
------------
ub1 rowdata[811] @6921 0x00
BBED> x /rc
rowdata[811] @6921
------------
flag@6921: 0x00 (NONE)
lock@6922: 0x00
keydata[6]: 0x00 0x40 0x00 0xd3 0x00 0x00
data key:
col 0[7] @6930: XS$NULL
BBED> x /rc offset 8096
rowdata[1986] @8096
-------------
flag@8096: 0x43 (KDXRDEL)
lock@8097: 0x01
keydata[6]: 0x00 0x00 0x40 0x00 0xd1 0x00
data key:
col 0[1] @8105: .
BBED> x /rn offset 8096
rowdata[1986] @8096
-------------
flag@8096: 0x43 (KDXRDEL)
lock@8097: 0x01
keydata[6]: 0x00 0x00 0x40 0x00 0xd1 0x00
data key:
col 0[1] @8105: #########################################
BBED> x /rc offset 8096
rowdata[1986] @8096
-------------
flag@8096: 0x43 (KDXRDEL)
lock@8097: 0x01
keydata[6]: 0x00 0x00 0x40 0x00 0xd1 0x00
data key:
col 0[1] @8105: .
BBED> find /c SYS top
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 6125 to 6188 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595354 454d0000 004000d1 00010759 474b4653 59530000 004000d5 00040a4b 5945455f 4c4f4749 4e010000 4000d500 040a4b59 45455f4c 4f47494e 01000040
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 6144 to 6207 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595300 00004000 d500040a 4b594545 5f4c4f47 494e0100 004000d5 00040a4b 5945455f 4c4f4749 4e010000 4000d500 040a4b59 45455f4c 4f47494e 01000040
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 6291 to 6354 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
5359535f 41554449 54000000 4000d400 01084f57 425f5553 45520000 004000d4 0015154f 57425f44 45534947 4e43454e 5445525f 56494557 00000040 00d40014
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 6378 to 6441 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595300 00004000 d400120b 41504558 5f303330 32303000 00004000 d4001117 41504558 5f41444d 494e4953 54524154 4f525f52 4f4c4500 00004000 d4001010
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 6523 to 6586 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
5359534d 414e0000 004000d4 000b0c43 53575f55 53525f52 4f4c4500 00004000 d4000a15 53504154 49414c5f 4353575f 41444d49 4e5f5553 52000000 4000d400
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 6763 to 6826 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595300 00004000 d300150d 4f4c4150 5f58535f 41444d49 4e000000 4000d300 14104f4c 4150495f 54524143 455f5553 45520000 004000d3 0013084f 52444144
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 6841 to 6904 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595300 00004000 d3001112 53495f49 4e464f52 4d544e5f 53434845 4d410000 004000d3 00100a4f 5244504c 5547494e 53000000 4000d300 0f074f52 44444154
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 6918 to 6981 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595300 00004000 d3000007 5853244e 554c4c00 00004000 d3000c19 5844425f 57454253 45525649 4345535f 4f564552 5f485454 50000000 4000d300 0b1b5844
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 7155 to 7218 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595300 00004000 d3000206 45584653 59530000 004000d2 00010b4a 4156415f 4445504c 4f590000 004000d2 00150a4a 4156415f 41444d49 4e000000 4000d200
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 7170 to 7233 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595300 00004000 d200010b 4a415641 5f444550 4c4f5900 00004000 d200150a 4a415641 5f41444d 494e0000 004000d2 0014094a 4d585345 52564552 00000040
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 7283 to 7346 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595350 52495600 00004000 d200100a 4a415641 49445052 49560000 004000d2 000f0c4a 41564155 53455250 52495600 00004000 d2000e0d 574d5f41 444d494e
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 7363 to 7426 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595300 00004000 d2000c09 41505051 4f535359 53000000 4000d200 0b064442 534e4d50 00000040 00d2000a 0b4f454d 5f4d4f4e 49544f52 00000040 00d20009
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 7381 to 7444 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595300 00004000 d2000b06 4442534e 4d500000 004000d2 000a0b4f 454d5f4d 4f4e4954 4f520000 004000d2 00090b4f 454d5f41 44564953 4f520000 004000d2
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 7638 to 7701 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595354 454d5f53 54415449 53544943 53000000 4000d100 14194144 4d5f5041 52414c4c 454c5f45 58454355 54455f54 41534b00 00004000 d100131a 44415441
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8031 to 8094 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595354 454d0000 004000d1 00050344 42410000 004000d1 00040852 45534f55 52434500 00004000 d1000307 434f4e4e 45435400 00004000 d1000206 5055424c
<64 bytes per line>
BBED> f
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8106 to 8169 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
53595300 00004000 d100000a 5f4e4558 545f5553 45520000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> f
BBED-00212: search string not found
BBED> x /rc offset 8097
rowdata[1987] @8097
-------------
flag@8097: 0x01 (KDXRDEL)
lock@8098: 0x00
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x01
data key:
col 0[3] @8106: SYS
BBED> p kd_off
sb2 kd_off[0] @124 8036
sb2 kd_off[1] @126 0
sb2 kd_off[2] @128 7563
sb2 kd_off[3] @130 7006
sb2 kd_off[4] @132 6289
sb2 kd_off[5] @134 6309
sb2 kd_off[6] @136 6341
sb2 kd_off[7] @138 7274
sb2 kd_off[8] @140 7688
sb2 kd_off[9] @142 7667
sb2 kd_off[10] @144 6939
sb2 kd_off[11] @146 7974
sb2 kd_off[12] @148 6437
sb2 kd_off[13] @150 7036
sb2 kd_off[14] @152 7051
sb2 kd_off[15] @154 6624
sb2 kd_off[16] @156 7632
sb2 kd_off[17] @158 7597
sb2 kd_off[18] @160 7945
sb2 kd_off[19] @162 7730
sb2 kd_off[20] @164 7292
sb2 kd_off[21] @166 7845
sb2 kd_off[22] @168 7718
sb2 kd_off[23] @170 7138
sb2 kd_off[24] @172 7873
sb2 kd_off[25] @174 7066
sb2 kd_off[26] @176 7805
sb2 kd_off[27] @178 6366
sb2 kd_off[28] @180 7530
sb2 kd_off[29] @182 7347
sb2 kd_off[30] @184 7397
sb2 kd_off[31] @186 7375
sb2 kd_off[32] @188 7427
sb2 kd_off[33] @190 7779
sb2 kd_off[34] @192 7156
sb2 kd_off[35] @194 7198
sb2 kd_off[36] @196 7178
sb2 kd_off[37] @198 7217
sb2 kd_off[38] @200 7101
sb2 kd_off[39] @202 7081
sb2 kd_off[40] @204 7120
sb2 kd_off[41] @206 6055
sb2 kd_off[42] @208 6131
sb2 kd_off[43] @210 7748
sb2 kd_off[44] @212 6591
sb2 kd_off[45] @214 6738
sb2 kd_off[46] @216 6404
sb2 kd_off[47] @218 6386
sb2 kd_off[48] @220 7327
sb2 kd_off[49] @222 7307
sb2 kd_off[50] @224 6696
sb2 kd_off[51] @226 6658
sb2 kd_off[52] @228 6641
sb2 kd_off[53] @230 6606
sb2 kd_off[54] @232 6674
sb2 kd_off[55] @234 7511
sb2 kd_off[56] @236 6721
sb2 kd_off[57] @238 6798
sb2 kd_off[58] @240 6779
sb2 kd_off[59] @242 6814
sb2 kd_off[60] @244 7831
sb2 kd_off[61] @246 6255
sb2 kd_off[62] @248 6274
sb2 kd_off[63] @250 6187
sb2 kd_off[64] @252 6225
sb2 kd_off[65] @254 6208
sb2 kd_off[66] @256 7990
sb2 kd_off[67] @258 7480
sb2 kd_off[68] @260 7957
sb2 kd_off[69] @262 7456
sb2 kd_off[70] @264 6173
sb2 kd_off[71] @266 7902
sb2 kd_off[72] @268 6752
sb2 kd_off[73] @270 6488
sb2 kd_off[74] @272 6458
sb2 kd_off[75] @274 6565
sb2 kd_off[76] @276 6535
sb2 kd_off[77] @278 6422
sb2 kd_off[78] @280 6422
sb2 kd_off[79] @282 7930
sb2 kd_off[80] @284 6514
sb2 kd_off[81] @286 7260
sb2 kd_off[82] @288 7238
sb2 kd_off[83] @290 7024
sb2 kd_off[84] @292 6989
sb2 kd_off[85] @294 6965
sb2 kd_off[86] @296 6915
sb2 kd_off[87] @298 6845
sb2 kd_off[88] @300 6879
sb2 kd_off[89] @302 6829
sb2 kd_off[90] @304 6039
BBED> modify /x 451f offset 278
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 278 to 341 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
451f1619 fa1e7219 5c1c461c 701b4d1b 351b031b bd1adf1a ad1a9717 511f0000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe120, required = 0xe120
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** kdxcofbo = 216 != 214
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p *kd_off[77]
rowdata[1987]
-------------
ub1 rowdata[1987] @8097 0x01
BBED> x /rc
rowdata[1987] @8097
-------------
flag@8097: 0x01 (KDXRDEL)
lock@8098: 0x00
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x01
data key:
col 0[3] @8106: SYS
BBED> modify /x 00 offset 8097
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8097 to 8160 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
00000040 00d10001 03535953 00000040 00d10000 0a5f4e45 58545f55 53455200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe020, required = 0xe020
BBED> p kd_off
sb2 kd_off[0] @124 8036
sb2 kd_off[1] @126 0
sb2 kd_off[2] @128 7563
sb2 kd_off[3] @130 7006
sb2 kd_off[4] @132 6289
sb2 kd_off[5] @134 6309
sb2 kd_off[6] @136 6341
sb2 kd_off[7] @138 7274
sb2 kd_off[8] @140 7688
sb2 kd_off[9] @142 7667
sb2 kd_off[10] @144 6939
sb2 kd_off[11] @146 7974
sb2 kd_off[12] @148 6437
sb2 kd_off[13] @150 7036
sb2 kd_off[14] @152 7051
sb2 kd_off[15] @154 6624
sb2 kd_off[16] @156 7632
sb2 kd_off[17] @158 7597
sb2 kd_off[18] @160 7945
sb2 kd_off[19] @162 7730
sb2 kd_off[20] @164 7292
sb2 kd_off[21] @166 7845
sb2 kd_off[22] @168 7718
sb2 kd_off[23] @170 7138
sb2 kd_off[24] @172 7873
sb2 kd_off[25] @174 7066
sb2 kd_off[26] @176 7805
sb2 kd_off[27] @178 6366
sb2 kd_off[28] @180 7530
sb2 kd_off[29] @182 7347
sb2 kd_off[30] @184 7397
sb2 kd_off[31] @186 7375
sb2 kd_off[32] @188 7427
sb2 kd_off[33] @190 7779
sb2 kd_off[34] @192 7156
sb2 kd_off[35] @194 7198
sb2 kd_off[36] @196 7178
sb2 kd_off[37] @198 7217
sb2 kd_off[38] @200 7101
sb2 kd_off[39] @202 7081
sb2 kd_off[40] @204 7120
sb2 kd_off[41] @206 6055
sb2 kd_off[42] @208 6131
sb2 kd_off[43] @210 7748
sb2 kd_off[44] @212 6591
sb2 kd_off[45] @214 6738
sb2 kd_off[46] @216 6404
sb2 kd_off[47] @218 6386
sb2 kd_off[48] @220 7327
sb2 kd_off[49] @222 7307
sb2 kd_off[50] @224 6696
sb2 kd_off[51] @226 6658
sb2 kd_off[52] @228 6641
sb2 kd_off[53] @230 6606
sb2 kd_off[54] @232 6674
sb2 kd_off[55] @234 7511
sb2 kd_off[56] @236 6721
sb2 kd_off[57] @238 6798
sb2 kd_off[58] @240 6779
sb2 kd_off[59] @242 6814
sb2 kd_off[60] @244 7831
sb2 kd_off[61] @246 6255
sb2 kd_off[62] @248 6274
sb2 kd_off[63] @250 6187
sb2 kd_off[64] @252 6225
sb2 kd_off[65] @254 6208
sb2 kd_off[66] @256 7990
sb2 kd_off[67] @258 7480
sb2 kd_off[68] @260 7957
sb2 kd_off[69] @262 7456
sb2 kd_off[70] @264 6173
sb2 kd_off[71] @266 7902
sb2 kd_off[72] @268 6752
sb2 kd_off[73] @270 6488
sb2 kd_off[74] @272 6458
sb2 kd_off[75] @274 6565
sb2 kd_off[76] @276 6535
sb2 kd_off[77] @278 8005
sb2 kd_off[78] @280 6422
sb2 kd_off[79] @282 7930
sb2 kd_off[80] @284 6514
sb2 kd_off[81] @286 7260
sb2 kd_off[82] @288 7238
sb2 kd_off[83] @290 7024
sb2 kd_off[84] @292 6989
sb2 kd_off[85] @294 6965
sb2 kd_off[86] @296 6915
sb2 kd_off[87] @298 6845
sb2 kd_off[88] @300 6879
sb2 kd_off[89] @302 6829
sb2 kd_off[90] @304 6039
BBED> p *kd_off[90]
rowdata[21]
-----------
ub1 rowdata[21] @6131 0x00
BBED> x /rc
rowdata[21] @6131
-----------
flag@6131: 0x00 (NONE)
lock@6132: 0x00
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x01
data key:
col 0[7] @6140: YGKFSYS
BBED> modify /x 01 offset 6131
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 6131 to 6194 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
01000040 00d10001 0759474b 46535953 00000040 00d50004 0a4b5945 455f4c4f 47494e01 00004000 d500040a 4b594545 5f4c4f47 494e0100 004000d5 00040a4b
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe120, required = 0xe120
BBED> p *kd_off[80]
rowdata[496]
------------
ub1 rowdata[496] @6606 0x00
BBED> x /rc
rowdata[496] @6606
------------
flag@6606: 0x00 (NONE)
lock@6607: 0x00
keydata[6]: 0x00 0x40 0x00 0xd4 0x00 0x08
data key:
col 0[12] @6615: WFS_USR_ROLE
BBED> p *kd_off[81]
rowdata[1242]
-------------
ub1 rowdata[1242] @7352 0x00
BBED> x /rc
rowdata[1242] @7352
-------------
flag@7352: 0x00 (NONE)
lock@7353: 0x00
keydata[6]: 0x00 0x40 0x00 0xd2 0x00 0x0d
data key:
col 0[5] @7361: WMSYS
BBED> p *kd_off[78]
rowdata[404]
------------
ub1 rowdata[404] @6514 0x00
BBED> x /rc
rowdata[404] @6514
------------
flag@6514: 0x00 (NONE)
lock@6515: 0x00
keydata[6]: 0x00 0x40 0x00 0xd4 0x00 0x0c
data key:
col 0[6] @6523: SYSMAN
BBED> p *kd_off[79]
rowdata[1912]
-------------
ub1 rowdata[1912] @8022 0x01
BBED> x /rc
rowdata[1912] @8022
-------------
flag@8022: 0x01 (KDXRDEL)
lock@8023: 0x02
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x06
data key:
col 0[6] @8031: SYSTEM
BBED> modify /x 00 offset 8022
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8022 to 8085 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
00020040 00d10006 06535953 54454d00 00004000 d1000503 44424100 00004000 d1000408 5245534f 55524345 00000040 00d10003 07434f4e 4e454354 00000040
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe121, required = 0xe121
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** kdxcofbo = 216 != 214
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> map
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Dba:0x004001a1
------------------------------------------------------------
KTB Data Block (Index Leaf)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdxle, 32 bytes @92
sb2 kd_off[91] @124
ub1 freespace[5804] @306
ub1 rowdata[2012] @6110
ub4 tailchk @8188
BBED> p ktbbh
struct ktbbh, 72 bytes @20
ub1 ktbbhtyp @20 0x02 (KDDBTINDEX)
union ktbbhsid, 4 bytes @24
ub4 ktbbhsg1 @24 0x0000002e
ub4 ktbbhod1 @24 0x0000002e
struct ktbbhcsc, 8 bytes @28
ub4 kscnbas @28 0x37274b5c
ub2 kscnwrp @32 0x0000
sb2 ktbbhict @36 -2046
ub1 ktbbhflg @38 0x02 (NONE)
ub1 ktbbhfsl @39 0x00
ub4 ktbbhfnx @40 0x00000000
struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0x0000
ub2 kxidslt @46 0x0000
ub4 kxidsqn @48 0x00000000
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00000000
ub2 kubaseq @56 0x0000
ub1 kubarec @58 0x00
ub2 ktbitflg @60 0x0000 (NONE)
union _ktbitun, 2 bytes @62
sb2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0x00000000
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0013
ub2 kxidslt @70 0x0015
ub4 kxidsqn @72 0x0000080a
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00c02081
ub2 kubaseq @80 0x0185
ub1 kubarec @82 0x05
ub2 ktbitflg @84 0x2002 (KTBFUPB)
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 17
ub2 _ktbitwrp @86 0x0011
ub4 ktbitbas @88 0x37274b5e
BBED> map
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Dba:0x004001a1
------------------------------------------------------------
KTB Data Block (Index Leaf)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdxle, 32 bytes @92
sb2 kd_off[91] @124
ub1 freespace[5804] @306
ub1 rowdata[2012] @6110
ub4 tailchk @8188
BBED> p kdxle
struct kdxle, 32 bytes @92
struct kdxlexco, 16 bytes @92
ub1 kdxcolev @92 0x00
ub1 kdxcolok @93 0x00
ub1 kdxcoopc @94 0x80
ub1 kdxconco @95 0x01
ub4 kdxcosdc @96 0x00000000
sb2 kdxconro @100 91
sb2 kdxcofbo @102 216
sb2 kdxcofeo @104 6020
sb2 kdxcoavs @106 5892
sb2 kdxlespl @108 0
sb2 kdxlende @110 1
ub4 kdxlenxt @112 0x00000000
ub4 kdxleprv @116 0x00000000
ub1 kdxledsz @120 0x06
ub1 kdxleflg @121 0x00 (NONE)
BBED> modify /x d6 offset 102
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 102 to 165 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
d6008417 04170000 01000000 00000000 00000600 0000641f 00008b1d 5e1b9118 a518c518 6a1c081e f31d1b1b 261f2519 7c1b8b1b e019d01d ad1d091f 321e7c1c
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe12f, required = 0xe12f
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 1 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p *kd_off[90]
rowdata[19]
-----------
ub1 rowdata[19] @6131 0x01
BBED> x /rc
rowdata[19] @6131
-----------
flag@6131: 0x01 (KDXRDEL)
lock@6132: 0x00
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x01
data key:
col 0[7] @6140: YGKFSYS
BBED> p *kd_off[77]
rowdata[1985]
-------------
ub1 rowdata[1985] @8097 0x00
BBED> x /rc
rowdata[1985] @8097
-------------
flag@8097: 0x00 (NONE)
lock@8098: 0x00
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x01
data key:
col 0[3] @8106: SYS
BBED> p *kd_off[78]
rowdata[402]
------------
ub1 rowdata[402] @6514 0x00
BBED> x /rc
rowdata[402] @6514
------------
flag@6514: 0x00 (NONE)
lock@6515: 0x00
keydata[6]: 0x00 0x40 0x00 0xd4 0x00 0x0c
data key:
col 0[6] @6523: SYSMAN
BBED> p *kd_off[79]
rowdata[1910]
-------------
ub1 rowdata[1910] @8022 0x00
BBED> x /rc
rowdata[1910] @8022
-------------
flag@8022: 0x00 (NONE)
lock@8023: 0x02
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x06
data key:
col 0[6] @8031: SYSTEM
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 1 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> map
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Dba:0x004001a1
------------------------------------------------------------
KTB Data Block (Index Leaf)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdxle, 32 bytes @92
sb2 kd_off[91] @124
ub1 freespace[5806] @306
ub1 rowdata[2012] @6112
ub4 tailchk @8188
BBED> p ktbbh
struct ktbbh, 72 bytes @20
ub1 ktbbhtyp @20 0x02 (KDDBTINDEX)
union ktbbhsid, 4 bytes @24
ub4 ktbbhsg1 @24 0x0000002e
ub4 ktbbhod1 @24 0x0000002e
struct ktbbhcsc, 8 bytes @28
ub4 kscnbas @28 0x37274b5c
ub2 kscnwrp @32 0x0000
sb2 ktbbhict @36 -2046
ub1 ktbbhflg @38 0x02 (NONE)
ub1 ktbbhfsl @39 0x00
ub4 ktbbhfnx @40 0x00000000
struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0x0000
ub2 kxidslt @46 0x0000
ub4 kxidsqn @48 0x00000000
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00000000
ub2 kubaseq @56 0x0000
ub1 kubarec @58 0x00
ub2 ktbitflg @60 0x0000 (NONE)
union _ktbitun, 2 bytes @62
sb2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0x00000000
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0013
ub2 kxidslt @70 0x0015
ub4 kxidsqn @72 0x0000080a
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00c02081
ub2 kubaseq @80 0x0185
ub1 kubarec @82 0x05
ub2 ktbitflg @84 0x2002 (KTBFUPB)
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 17
ub2 _ktbitwrp @86 0x0011
ub4 ktbitbas @88 0x37274b5e
BBED> p kd_off
sb2 kd_off[0] @124 8036
sb2 kd_off[1] @126 0
sb2 kd_off[2] @128 7563
sb2 kd_off[3] @130 7006
sb2 kd_off[4] @132 6289
sb2 kd_off[5] @134 6309
sb2 kd_off[6] @136 6341
sb2 kd_off[7] @138 7274
sb2 kd_off[8] @140 7688
sb2 kd_off[9] @142 7667
sb2 kd_off[10] @144 6939
sb2 kd_off[11] @146 7974
sb2 kd_off[12] @148 6437
sb2 kd_off[13] @150 7036
sb2 kd_off[14] @152 7051
sb2 kd_off[15] @154 6624
sb2 kd_off[16] @156 7632
sb2 kd_off[17] @158 7597
sb2 kd_off[18] @160 7945
sb2 kd_off[19] @162 7730
sb2 kd_off[20] @164 7292
sb2 kd_off[21] @166 7845
sb2 kd_off[22] @168 7718
sb2 kd_off[23] @170 7138
sb2 kd_off[24] @172 7873
sb2 kd_off[25] @174 7066
sb2 kd_off[26] @176 7805
sb2 kd_off[27] @178 6366
sb2 kd_off[28] @180 7530
sb2 kd_off[29] @182 7347
sb2 kd_off[30] @184 7397
sb2 kd_off[31] @186 7375
sb2 kd_off[32] @188 7427
sb2 kd_off[33] @190 7779
sb2 kd_off[34] @192 7156
sb2 kd_off[35] @194 7198
sb2 kd_off[36] @196 7178
sb2 kd_off[37] @198 7217
sb2 kd_off[38] @200 7101
sb2 kd_off[39] @202 7081
sb2 kd_off[40] @204 7120
sb2 kd_off[41] @206 6055
sb2 kd_off[42] @208 6131
sb2 kd_off[43] @210 7748
sb2 kd_off[44] @212 6591
sb2 kd_off[45] @214 6738
sb2 kd_off[46] @216 6404
sb2 kd_off[47] @218 6386
sb2 kd_off[48] @220 7327
sb2 kd_off[49] @222 7307
sb2 kd_off[50] @224 6696
sb2 kd_off[51] @226 6658
sb2 kd_off[52] @228 6641
sb2 kd_off[53] @230 6606
sb2 kd_off[54] @232 6674
sb2 kd_off[55] @234 7511
sb2 kd_off[56] @236 6721
sb2 kd_off[57] @238 6798
sb2 kd_off[58] @240 6779
sb2 kd_off[59] @242 6814
sb2 kd_off[60] @244 7831
sb2 kd_off[61] @246 6255
sb2 kd_off[62] @248 6274
sb2 kd_off[63] @250 6187
sb2 kd_off[64] @252 6225
sb2 kd_off[65] @254 6208
sb2 kd_off[66] @256 7990
sb2 kd_off[67] @258 7480
sb2 kd_off[68] @260 7957
sb2 kd_off[69] @262 7456
sb2 kd_off[70] @264 6173
sb2 kd_off[71] @266 7902
sb2 kd_off[72] @268 6752
sb2 kd_off[73] @270 6488
sb2 kd_off[74] @272 6458
sb2 kd_off[75] @274 6565
sb2 kd_off[76] @276 6535
sb2 kd_off[77] @278 8005
sb2 kd_off[78] @280 6422
sb2 kd_off[79] @282 7930
sb2 kd_off[80] @284 6514
sb2 kd_off[81] @286 7260
sb2 kd_off[82] @288 7238
sb2 kd_off[83] @290 7024
sb2 kd_off[84] @292 6989
sb2 kd_off[85] @294 6965
sb2 kd_off[86] @296 6915
sb2 kd_off[87] @298 6845
sb2 kd_off[88] @300 6879
sb2 kd_off[89] @302 6829
sb2 kd_off[90] @304 6039
BBED> map
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Dba:0x004001a1
------------------------------------------------------------
KTB Data Block (Index Leaf)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdxle, 32 bytes @92
sb2 kd_off[91] @124
ub1 freespace[5806] @306
ub1 rowdata[2012] @6112
ub4 tailchk @8188
BBED> p kdxle
struct kdxle, 32 bytes @92
struct kdxlexco, 16 bytes @92
ub1 kdxcolev @92 0x00
ub1 kdxcolok @93 0x00
ub1 kdxcoopc @94 0x80
ub1 kdxconco @95 0x01
ub4 kdxcosdc @96 0x00000000
sb2 kdxconro @100 91
sb2 kdxcofbo @102 214
sb2 kdxcofeo @104 6020
sb2 kdxcoavs @106 5892
sb2 kdxlespl @108 0
sb2 kdxlende @110 1
ub4 kdxlenxt @112 0x00000000
ub4 kdxleprv @116 0x00000000
ub1 kdxledsz @120 0x06
ub1 kdxleflg @121 0x00 (NONE)
BBED> modify /x 5a offset 100
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 100 to 163 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
5a00d600 84170417 00000100 00000000 00000000 06000000 641f0000 8b1d5e1b 9118a518 c5186a1c 081ef31d 1b1b261f 25197c1b 8b1be019 d01dad1d 091f321e
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe12e, required = 0xe12e
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** kdxcofbo = 214 != 212
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p kdxle
struct kdxle, 32 bytes @92
struct kdxlexco, 16 bytes @92
ub1 kdxcolev @92 0x00
ub1 kdxcolok @93 0x00
ub1 kdxcoopc @94 0x80
ub1 kdxconco @95 0x01
ub4 kdxcosdc @96 0x00000000
sb2 kdxconro @100 90
sb2 kdxcofbo @102 214
sb2 kdxcofeo @104 6020
sb2 kdxcoavs @106 5892
sb2 kdxlespl @108 0
sb2 kdxlende @110 1
ub4 kdxlenxt @112 0x00000000
ub4 kdxleprv @116 0x00000000
ub1 kdxledsz @120 0x06
ub1 kdxleflg @121 0x00 (NONE)
BBED> modify /x d4 offset 102
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 102 to 165 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
d4008417 04170000 01000000 00000000 00000600 0000641f 00008b1d 5e1b9118 a518c518 6a1c081e f31d1b1b 261f2519 7c1b8b1b e019d01d ad1d091f 321e7c1c
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe12c, required = 0xe12c
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 1 != # in trans. header = 2
**** actual rows marked deleted = 0 != kdxlende = 1
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p kdxle
struct kdxle, 32 bytes @92
struct kdxlexco, 16 bytes @92
ub1 kdxcolev @92 0x00
ub1 kdxcolok @93 0x00
ub1 kdxcoopc @94 0x80
ub1 kdxconco @95 0x01
ub4 kdxcosdc @96 0x00000000
sb2 kdxconro @100 90
sb2 kdxcofbo @102 212
sb2 kdxcofeo @104 6020
sb2 kdxcoavs @106 5892
sb2 kdxlespl @108 0
sb2 kdxlende @110 1
ub4 kdxlenxt @112 0x00000000
ub4 kdxleprv @116 0x00000000
ub1 kdxledsz @120 0x06
ub1 kdxleflg @121 0x00 (NONE)
BBED> modify /x 00 offset 110
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 110 to 173 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
00000000 00000000 00000600 0000641f 00008b1d 5e1b9118 a518c518 6a1c081e f31d1b1b 261f2519 7c1b8b1b e019d01d ad1d091f 321e7c1c a51e261e e21bc11e
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe12d, required = 0xe12d
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 1 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p *kd_off[79]
rowdata[1910]
-------------
ub1 rowdata[1910] @8022 0x00
BBED> x /rc
rowdata[1910] @8022
-------------
flag@8022: 0x00 (NONE)
lock@8023: 0x02
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x06
data key:
col 0[6] @8031: SYSTEM
BBED> modify /x 01 offset 8023
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8023 to 8086 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
01004000 d1000606 53595354 454d0000 004000d1 00050344 42410000 004000d1 00040852 45534f55 52434500 00004000 d1000307 434f4e4e 45435400 00004000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe22d, required = 0xe22d
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 1 = 1 != # in trans. header = 0
**** actual rows locked by itl 2 = 0 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> modify /x 02 offset 8023
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8023 to 8086 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
02004000 d1000606 53595354 454d0000 004000d1 00050344 42410000 004000d1 00040852 45534f55 52434500 00004000 d1000307 434f4e4e 45435400 00004000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe12d, required = 0xe12d
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 1 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> modify /x 00 offset 8023
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8023 to 8086 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
00004000 d1000606 53595354 454d0000 004000d1 00050344 42410000 004000d1 00040852 45534f55 52434500 00004000 d1000307 434f4e4e 45435400 00004000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe32d, required = 0xe32d
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 0 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p *kd_off[77]
rowdata[1985]
-------------
ub1 rowdata[1985] @8097 0x00
BBED> x /rc
rowdata[1985] @8097
-------------
flag@8097: 0x00 (NONE)
lock@8098: 0x00
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x01
data key:
col 0[3] @8106: SYS
BBED> p *kd_off[79]
rowdata[1910]
-------------
ub1 rowdata[1910] @8022 0x00
BBED> x /rc
rowdata[1910] @8022
-------------
flag@8022: 0x00 (NONE)
lock@8023: 0x00
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x06
data key:
col 0[6] @8031: SYSTEM
BBED> map
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Dba:0x004001a1
------------------------------------------------------------
KTB Data Block (Index Leaf)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdxle, 32 bytes @92
sb2 kd_off[90] @124
ub1 freespace[5808] @304
ub1 rowdata[2012] @6112
ub4 tailchk @8188
BBED> p kdxle
struct kdxle, 32 bytes @92
struct kdxlexco, 16 bytes @92
ub1 kdxcolev @92 0x00
ub1 kdxcolok @93 0x00
ub1 kdxcoopc @94 0x80
ub1 kdxconco @95 0x01
ub4 kdxcosdc @96 0x00000000
sb2 kdxconro @100 90
sb2 kdxcofbo @102 212
sb2 kdxcofeo @104 6020
sb2 kdxcoavs @106 5892
sb2 kdxlespl @108 0
sb2 kdxlende @110 0
ub4 kdxlenxt @112 0x00000000
ub4 kdxleprv @116 0x00000000
ub1 kdxledsz @120 0x06
ub1 kdxleflg @121 0x00 (NONE)
BBED> p ktbbh
struct ktbbh, 72 bytes @20
ub1 ktbbhtyp @20 0x02 (KDDBTINDEX)
union ktbbhsid, 4 bytes @24
ub4 ktbbhsg1 @24 0x0000002e
ub4 ktbbhod1 @24 0x0000002e
struct ktbbhcsc, 8 bytes @28
ub4 kscnbas @28 0x37274b5c
ub2 kscnwrp @32 0x0000
sb2 ktbbhict @36 -2046
ub1 ktbbhflg @38 0x02 (NONE)
ub1 ktbbhfsl @39 0x00
ub4 ktbbhfnx @40 0x00000000
struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0x0000
ub2 kxidslt @46 0x0000
ub4 kxidsqn @48 0x00000000
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00000000
ub2 kubaseq @56 0x0000
ub1 kubarec @58 0x00
ub2 ktbitflg @60 0x0000 (NONE)
union _ktbitun, 2 bytes @62
sb2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0x00000000
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0013
ub2 kxidslt @70 0x0015
ub4 kxidsqn @72 0x0000080a
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00c02081
ub2 kubaseq @80 0x0185
ub1 kubarec @82 0x05
ub2 ktbitflg @84 0x2002 (KTBFUPB)
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 17
ub2 _ktbitwrp @86 0x0011
ub4 ktbitbas @88 0x37274b5e
BBED> modify /x 00 offset 86
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 86 to 149 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
00005e4b 27370000 80010000 00005a00 d4008417 04170000 00000000 00000000 00000600 0000641f 00008b1d 5e1b9118 a518c518 6a1c081e f31d1b1b 261f2519
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe33c, required = 0xe33c
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 0 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p *kd_off[90]
BBED-00401: out of range array index (90)
BBED> p *kd_off[89]
rowdata[809]
------------
ub1 rowdata[809] @6921 0x00
BBED> x /rc
rowdata[809] @6921
------------
flag@6921: 0x00 (NONE)
lock@6922: 0x00
keydata[6]: 0x00 0x40 0x00 0xd3 0x00 0x00
data key:
col 0[7] @6930: XS$NULL
BBED> p *kd_off[90]
BBED-00401: out of range array index (90)
BBED> p kdxle
struct kdxle, 32 bytes @92
struct kdxlexco, 16 bytes @92
ub1 kdxcolev @92 0x00
ub1 kdxcolok @93 0x00
ub1 kdxcoopc @94 0x80
ub1 kdxconco @95 0x01
ub4 kdxcosdc @96 0x00000000
sb2 kdxconro @100 90
sb2 kdxcofbo @102 212
sb2 kdxcofeo @104 6020
sb2 kdxcoavs @106 5892
sb2 kdxlespl @108 0
sb2 kdxlende @110 0
ub4 kdxlenxt @112 0x00000000
ub4 kdxleprv @116 0x00000000
ub1 kdxledsz @120 0x06
ub1 kdxleflg @121 0x00 (NONE)
BBED> modify /x 5b offset 100
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 100 to 163 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
5b00d400 84170417 00000000 00000000 00000000 06000000 641f0000 8b1d5e1b 9118a518 c5186a1c 081ef31d 1b1b261f 25197c1b 8b1be019 d01dad1d 091f321e
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe33d, required = 0xe33d
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** kdxcofbo = 212 != 214
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p *kd_off[90]
rowdata[17]
-----------
ub1 rowdata[17] @6131 0x01
BBED> x /rc
rowdata[17] @6131
-----------
flag@6131: 0x01 (KDXRDEL)
lock@6132: 0x00
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x01
data key:
col 0[7] @6140: YGKFSYS
BBED> modify /x 00 offset 6131
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 6131 to 6194 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
00000040 00d10001 0759474b 46535953 00000040 00d50004 0a4b5945 455f4c4f 47494e01 00004000 d500040a 4b594545 5f4c4f47 494e0100 004000d5 00040a4b
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe23d, required = 0xe23d
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** kdxcofbo = 212 != 214
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p kdxle
struct kdxle, 32 bytes @92
struct kdxlexco, 16 bytes @92
ub1 kdxcolev @92 0x00
ub1 kdxcolok @93 0x00
ub1 kdxcoopc @94 0x80
ub1 kdxconco @95 0x01
ub4 kdxcosdc @96 0x00000000
sb2 kdxconro @100 91
sb2 kdxcofbo @102 212
sb2 kdxcofeo @104 6020
sb2 kdxcoavs @106 5892
sb2 kdxlespl @108 0
sb2 kdxlende @110 0
ub4 kdxlenxt @112 0x00000000
ub4 kdxleprv @116 0x00000000
ub1 kdxledsz @120 0x06
ub1 kdxleflg @121 0x00 (NONE)
BBED> modify /x d6 offset 102
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 102 to 165 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
d6008417 04170000 00000000 00000000 00000600 0000641f 00008b1d 5e1b9118 a518c518 6a1c081e f31d1b1b 261f2519 7c1b8b1b e019d01d ad1d091f 321e7c1c
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe23f, required = 0xe23f
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 0 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p *kd_off[90]
rowdata[19]
-----------
ub1 rowdata[19] @6131 0x00
BBED> x /rc
rowdata[19] @6131
-----------
flag@6131: 0x00 (NONE)
lock@6132: 0x00
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x01
data key:
col 0[7] @6140: YGKFSYS
BBED> modify /x 02 offset 6132
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 6132 to 6195 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
02004000 d1000107 59474b46 53595300 00004000 d500040a 4b594545 5f4c4f47 494e0100 004000d5 00040a4b 5945455f 4c4f4749 4e010000 4000d500 040a4b59
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe23d, required = 0xe23d
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 1 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> map
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Dba:0x004001a1
------------------------------------------------------------
KTB Data Block (Index Leaf)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdxle, 32 bytes @92
sb2 kd_off[91] @124
ub1 freespace[5806] @306
ub1 rowdata[2012] @6112
ub4 tailchk @8188
BBED> p ktbbh
struct ktbbh, 72 bytes @20
ub1 ktbbhtyp @20 0x02 (KDDBTINDEX)
union ktbbhsid, 4 bytes @24
ub4 ktbbhsg1 @24 0x0000002e
ub4 ktbbhod1 @24 0x0000002e
struct ktbbhcsc, 8 bytes @28
ub4 kscnbas @28 0x37274b5c
ub2 kscnwrp @32 0x0000
sb2 ktbbhict @36 -2046
ub1 ktbbhflg @38 0x02 (NONE)
ub1 ktbbhfsl @39 0x00
ub4 ktbbhfnx @40 0x00000000
struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0x0000
ub2 kxidslt @46 0x0000
ub4 kxidsqn @48 0x00000000
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00000000
ub2 kubaseq @56 0x0000
ub1 kubarec @58 0x00
ub2 ktbitflg @60 0x0000 (NONE)
union _ktbitun, 2 bytes @62
sb2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0x00000000
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0013
ub2 kxidslt @70 0x0015
ub4 kxidsqn @72 0x0000080a
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00c02081
ub2 kubaseq @80 0x0185
ub1 kubarec @82 0x05
ub2 ktbitflg @84 0x2002 (KTBFUPB)
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 0
ub2 _ktbitwrp @86 0x0000
ub4 ktbitbas @88 0x37274b5e
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 1 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p kd_off[90]
sb2 kd_off[90] @304 6039
BBED> x /rc
kd_off[90] @304
----------
BBED-00210: no row at this offset
BBED> p *kd_off[90]
rowdata[19]
-----------
ub1 rowdata[19] @6131 0x00
BBED> x /rc
rowdata[19] @6131
-----------
flag@6131: 0x00 (NONE)
lock@6132: 0x02
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x01
data key:
col 0[7] @6140: YGKFSYS
BBED> modify /x 00 offset 6132
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 6132 to 6195 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
00004000 d1000107 59474b46 53595300 00004000 d500040a 4b594545 5f4c4f47 494e0100 004000d5 00040a4b 5945455f 4c4f4749 4e010000 4000d500 040a4b59
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe23f, required = 0xe23f
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 0 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p kdxle
struct kdxle, 32 bytes @92
struct kdxlexco, 16 bytes @92
ub1 kdxcolev @92 0x00
ub1 kdxcolok @93 0x00
ub1 kdxcoopc @94 0x80
ub1 kdxconco @95 0x01
ub4 kdxcosdc @96 0x00000000
sb2 kdxconro @100 91
sb2 kdxcofbo @102 214
sb2 kdxcofeo @104 6020
sb2 kdxcoavs @106 5892
sb2 kdxlespl @108 0
sb2 kdxlende @110 0
ub4 kdxlenxt @112 0x00000000
ub4 kdxleprv @116 0x00000000
ub1 kdxledsz @120 0x06
ub1 kdxleflg @121 0x00 (NONE)
BBED> modify /x 5a offset 100
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 100 to 163 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
5a00d600 84170417 00000000 00000000 00000000 06000000 641f0000 8b1d5e1b 9118a518 c5186a1c 081ef31d 1b1b261f 25197c1b 8b1be019 d01dad1d 091f321e
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe23e, required = 0xe23e
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** kdxcofbo = 214 != 212
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p kdxle
struct kdxle, 32 bytes @92
struct kdxlexco, 16 bytes @92
ub1 kdxcolev @92 0x00
ub1 kdxcolok @93 0x00
ub1 kdxcoopc @94 0x80
ub1 kdxconco @95 0x01
ub4 kdxcosdc @96 0x00000000
sb2 kdxconro @100 90
sb2 kdxcofbo @102 214
sb2 kdxcofeo @104 6020
sb2 kdxcoavs @106 5892
sb2 kdxlespl @108 0
sb2 kdxlende @110 0
ub4 kdxlenxt @112 0x00000000
ub4 kdxleprv @116 0x00000000
ub1 kdxledsz @120 0x06
ub1 kdxleflg @121 0x00 (NONE)
BBED> modify /x offset d4 offset 102
BBED-00209: invalid number (offset)
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe23e, required = 0xe23e
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** kdxcofbo = 214 != 212
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p kdxle
struct kdxle, 32 bytes @92
struct kdxlexco, 16 bytes @92
ub1 kdxcolev @92 0x00
ub1 kdxcolok @93 0x00
ub1 kdxcoopc @94 0x80
ub1 kdxconco @95 0x01
ub4 kdxcosdc @96 0x00000000
sb2 kdxconro @100 90
sb2 kdxcofbo @102 214
sb2 kdxcofeo @104 6020
sb2 kdxcoavs @106 5892
sb2 kdxlespl @108 0
sb2 kdxlende @110 0
ub4 kdxlenxt @112 0x00000000
ub4 kdxleprv @116 0x00000000
ub1 kdxledsz @120 0x06
ub1 kdxleflg @121 0x00 (NONE)
BBED> modify /x d4 offset 102
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 102 to 165 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
d4008417 04170000 00000000 00000000 00000600 0000641f 00008b1d 5e1b9118 a518c518 6a1c081e f31d1b1b 261f2519 7c1b8b1b e019d01d ad1d091f 321e7c1c
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe23c, required = 0xe23c
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 0 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p *kd_off[77]
rowdata[1985]
-------------
ub1 rowdata[1985] @8097 0x00
BBED> x /rc
rowdata[1985] @8097
-------------
flag@8097: 0x00 (NONE)
lock@8098: 0x00
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x01
data key:
col 0[3] @8106: SYS
BBED> modify /x 01 offset 8098
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8098 to 8161 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
01004000 d1000103 53595300 00004000 d100000a 5f4e4558 545f5553 45520000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe23d, required = 0xe23d
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 1 = 1 != # in trans. header = 0
**** actual rows locked by itl 2 = 0 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p *kd_off[79]
rowdata[1910]
-------------
ub1 rowdata[1910] @8022 0x00
BBED> x /rc
rowdata[1910] @8022
-------------
flag@8022: 0x00 (NONE)
lock@8023: 0x00
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x06
data key:
col 0[6] @8031: SYSTEM
BBED> modify /x 02 offset 8023
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8023 to 8086 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
02004000 d1000606 53595354 454d0000 004000d1 00050344 42410000 004000d1 00040852 45534f55 52434500 00004000 d1000307 434f4e4e 45435400 00004000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe03d, required = 0xe03d
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 1 = 1 != # in trans. header = 0
**** actual rows locked by itl 2 = 1 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p *kd_off[77]
rowdata[1985]
-------------
ub1 rowdata[1985] @8097 0x00
BBED> x /rc
rowdata[1985] @8097
-------------
flag@8097: 0x00 (NONE)
lock@8098: 0x01
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x01
data key:
col 0[3] @8106: SYS
BBED> modify /x 00 offset 8098
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8098 to 8161 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
00004000 d1000103 53595300 00004000 d100000a 5f4e4558 545f5553 45520000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe03c, required = 0xe03c
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 1 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p *kd_off[79]
rowdata[1910]
-------------
ub1 rowdata[1910] @8022 0x00
BBED> x /rc
rowdata[1910] @8022
-------------
flag@8022: 0x00 (NONE)
lock@8023: 0x02
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x06
data key:
col 0[6] @8031: SYSTEM
BBED> modify /x 03 offset 8023
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8023 to 8086 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
03004000 d1000606 53595354 454d0000 004000d1 00050344 42410000 004000d1 00040852 45534f55 52434500 00004000 d1000307 434f4e4e 45435400 00004000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe13c, required = 0xe13c
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** row 79: lock value 3 is larger than maximum itl 2
**** actual rows locked by itl 2 = 0 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p *kd_off[79]
rowdata[1910]
-------------
ub1 rowdata[1910] @8022 0x00
BBED> x /rc
rowdata[1910] @8022
-------------
flag@8022: 0x00 (NONE)
lock@8023: 0x03
keydata[6]: 0x00 0x40 0x00 0xd1 0x00 0x06
data key:
col 0[6] @8031: SYSTEM
BBED> modify /x 00 offset 8023
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 8023 to 8086 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
00004000 d1000606 53595354 454d0000 004000d1 00050344 42410000 004000d1 00040852 45534f55 52434500 00004000 d1000307 434f4e4e 45435400 00004000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xe23c, required = 0xe23c
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 0 != # in trans. header = 2
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p kdbbh
BBED-00207: invalid offset specifier (kdbbh)
BBED> p kdbh
BBED-00207: invalid offset specifier (kdbh)
BBED> map
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Dba:0x004001a1
------------------------------------------------------------
KTB Data Block (Index Leaf)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdxle, 32 bytes @92
sb2 kd_off[90] @124
ub1 freespace[5808] @304
ub1 rowdata[2012] @6112
ub4 tailchk @8188
BBED> p ktbbh
struct ktbbh, 72 bytes @20
ub1 ktbbhtyp @20 0x02 (KDDBTINDEX)
union ktbbhsid, 4 bytes @24
ub4 ktbbhsg1 @24 0x0000002e
ub4 ktbbhod1 @24 0x0000002e
struct ktbbhcsc, 8 bytes @28
ub4 kscnbas @28 0x37274b5c
ub2 kscnwrp @32 0x0000
sb2 ktbbhict @36 -2046
ub1 ktbbhflg @38 0x02 (NONE)
ub1 ktbbhfsl @39 0x00
ub4 ktbbhfnx @40 0x00000000
struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0x0000
ub2 kxidslt @46 0x0000
ub4 kxidsqn @48 0x00000000
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00000000
ub2 kubaseq @56 0x0000
ub1 kubarec @58 0x00
ub2 ktbitflg @60 0x0000 (NONE)
union _ktbitun, 2 bytes @62
sb2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0x00000000
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0013
ub2 kxidslt @70 0x0015
ub4 kxidsqn @72 0x0000080a
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00c02081
ub2 kubaseq @80 0x0185
ub1 kubarec @82 0x05
ub2 ktbitflg @84 0x2002 (KTBFUPB)
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 0
ub2 _ktbitwrp @86 0x0000
ub4 ktbitbas @88 0x37274b5e
BBED> modify /x 8000 offset 84
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 84 to 147 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
80000000 5e4b2737 00008001 00000000 5a00d400 84170417 00000000 00000000 00000000 06000000 641f0000 8b1d5e1b 9118a518 c5186a1c 081ef31d 1b1b261f
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xc2be, required = 0xc2be
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 0 != # in trans. header = 128
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p ktbbh
struct ktbbh, 72 bytes @20
ub1 ktbbhtyp @20 0x02 (KDDBTINDEX)
union ktbbhsid, 4 bytes @24
ub4 ktbbhsg1 @24 0x0000002e
ub4 ktbbhod1 @24 0x0000002e
struct ktbbhcsc, 8 bytes @28
ub4 kscnbas @28 0x37274b5c
ub2 kscnwrp @32 0x0000
sb2 ktbbhict @36 -2046
ub1 ktbbhflg @38 0x02 (NONE)
ub1 ktbbhfsl @39 0x00
ub4 ktbbhfnx @40 0x00000000
struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0x0000
ub2 kxidslt @46 0x0000
ub4 kxidsqn @48 0x00000000
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00000000
ub2 kubaseq @56 0x0000
ub1 kubarec @58 0x00
ub2 ktbitflg @60 0x0000 (NONE)
union _ktbitun, 2 bytes @62
sb2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0x00000000
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0013
ub2 kxidslt @70 0x0015
ub4 kxidsqn @72 0x0000080a
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00c02081
ub2 kubaseq @80 0x0185
ub1 kubarec @82 0x05
ub2 ktbitflg @84 0x0080 (NONE)
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 0
ub2 _ktbitwrp @86 0x0000
ub4 ktbitbas @88 0x37274b5e
BBED> modify /x 8000 offset 84
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 84 to 147 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
80000000 5e4b2737 00008001 00000000 5a00d400 84170417 00000000 00000000 00000000 06000000 641f0000 8b1d5e1b 9118a518 c5186a1c 081ef31d 1b1b261f
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xc2be, required = 0xc2be
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
**** actual rows locked by itl 2 = 0 != # in trans. header = 128
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> p ktbbh
struct ktbbh, 72 bytes @20
ub1 ktbbhtyp @20 0x02 (KDDBTINDEX)
union ktbbhsid, 4 bytes @24
ub4 ktbbhsg1 @24 0x0000002e
ub4 ktbbhod1 @24 0x0000002e
struct ktbbhcsc, 8 bytes @28
ub4 kscnbas @28 0x37274b5c
ub2 kscnwrp @32 0x0000
sb2 ktbbhict @36 -2046
ub1 ktbbhflg @38 0x02 (NONE)
ub1 ktbbhfsl @39 0x00
ub4 ktbbhfnx @40 0x00000000
struct ktbbhitl[0], 24 bytes @44
struct ktbitxid, 8 bytes @44
ub2 kxidusn @44 0x0000
ub2 kxidslt @46 0x0000
ub4 kxidsqn @48 0x00000000
struct ktbituba, 8 bytes @52
ub4 kubadba @52 0x00000000
ub2 kubaseq @56 0x0000
ub1 kubarec @58 0x00
ub2 ktbitflg @60 0x0000 (NONE)
union _ktbitun, 2 bytes @62
sb2 _ktbitfsc @62 0
ub2 _ktbitwrp @62 0x0000
ub4 ktbitbas @64 0x00000000
struct ktbbhitl[1], 24 bytes @68
struct ktbitxid, 8 bytes @68
ub2 kxidusn @68 0x0013
ub2 kxidslt @70 0x0015
ub4 kxidsqn @72 0x0000080a
struct ktbituba, 8 bytes @76
ub4 kubadba @76 0x00c02081
ub2 kubaseq @80 0x0185
ub1 kubarec @82 0x05
ub2 ktbitflg @84 0x0080 (NONE)
union _ktbitun, 2 bytes @86
sb2 _ktbitfsc @86 0
ub2 _ktbitwrp @86 0x0000
ub4 ktbitbas @88 0x37274b5e
BBED> modify /x 0000 offset 84
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 84 to 147 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
00000000 5e4b2737 00008001 00000000 5a00d400 84170417 00000000 00000000 00000000 06000000 641f0000 8b1d5e1b 9118a518 c5186a1c 081ef31d 1b1b261f
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xc23e, required = 0xc23e
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> map
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Dba:0x004001a1
------------------------------------------------------------
KTB Data Block (Index Leaf)
struct kcbh, 20 bytes @0
struct ktbbh, 72 bytes @20
struct kdxle, 32 bytes @92
sb2 kd_off[90] @124
ub1 freespace[5808] @304
ub1 rowdata[2012] @6112
ub4 tailchk @8188
BBED> d /v offset 212 count 5892
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 212 to 6103 Dba:0x004001a1
-----------------------------------------------------------------------------------------------------------
bf19521a 0419f218 9f1c8b1c 281a021a f119ce19 121a571d 411a8e1a 7b1a9e1a l ..R.........(.........W.A...{...
971e6f18 82182b18 51184018 361f381d 151f201d 1d18de1e 601a5819 3a19a519 l ..o...+.Q.@.6.8... .....`.X.:...
8719451f 1619fa1e 72195c1c 461c701b 4d1b351b 031bbd1a df1aad1a 9717511f l ..E.....r.\.F.p.M.5...........Q.
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 l ................................
00000000 l ....
<32 bytes per line>
BBED> d /v offset 304 count 24
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 304 to 327 Dba:0x004001a1
-----------------------------------------------------------------------------------------------------------
9717511f 00000000 00000000 00000000 00000000 00000000 l ..Q.....................
<32 bytes per line>
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
Block Checking: DBA = 4194721, Block Type = KTB-managed data block
**** row 1: row offset 0 out of valid range
---- end index block validation
Block 417 failed with check code 6401
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
Total Blocks Failing (Index): 1
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 0
Total Blocks Influx : 0
Message 531 not found; product=RDBMS; facility=BBED
BBED> d /v offset 304 count 20
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 304 to 323 Dba:0x004001a1
-----------------------------------------------------------------------------------------------------------
8417511f 00000000 00000000 00000000 00000000 l ..Q.................
<32 bytes per line>
BBED> modify /x d8 offset 102
File: /home/oracle/SYSTEM01.DBF (1)
Block: 417 Offsets: 102 to 113 Dba:0x004001a1
------------------------------------------------------------------------------------------------------------------------------------------------
d8008417 04170000 00000000
<64 bytes per line>
BBED> sum apply
Check value for File 1, Block 417:
current = 0xc232, required = 0xc232
BBED> verify
DBVERIFY - Verification starting
FILE = /home/oracle/SYSTEM01.DBF
BLOCK = 417
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 1
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
最后对修复后的文件重新放到windows下直接启动数据库，完美修复，没有任何问题(这个库除了这2个字典对象有问题外，没有任何损坏)，如下：
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 8 23:42:18 2019
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 3156725760 bytes
Fixed Size 2179896 bytes
Variable Size 1728056520 bytes
Database Buffers 1409286144 bytes
Redo Buffers 17203200 bytes
SQL> alter database mount
2 ;
Database altered.
SQL> alter database open;
alert日志如下：
Database Characterset is ZHS16GBK
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5048_10046trace.trc (incident=130276):
ORA-00600: internal error code, arguments: [kokasgi1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: e:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_130276\orcl_ora_5048_i130276.trc
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5048_10046trace.trc:
ORA-00600: internal error code, arguments: [kokasgi1], [], [], [], [], [], [], [], [], [], [], []
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5048_10046trace.trc:
ORA-00600: internal error code, arguments: [kokasgi1], [], [], [], [], [], [], [], [], [], [], []
Error 600 happened during db open, shutting down database
USER (ospid: 5048): terminating the instance due to error 600
Instance terminated by USER, pid = 5048
ORA-1092 signalled during: alter database open...
opiodr aborting process unknown ospid (5048) as a result of ORA-1092
Sun Dec 08 21:30:35 2019
ORA-1092 : opitsk aborting process
Sun Dec 08 23:42:23 2019
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes = 150
memory_target = 3024M
control_files = "E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "E:\app\Administrator\flash_recovery_area"
db_recovery_file_dest_size= 3912M
undo_tablespace = "undotbs1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
audit_file_dest = "E:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 300
diagnostic_dest = "E:\APP\ADMINISTRATOR"
Sun Dec 08 23:42:23 2019
PMON started with pid=2, OS id=5448
Sun Dec 08 23:42:23 2019
VKTM started with pid=3, OS id=5876 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Sun Dec 08 23:42:23 2019
GEN0 started with pid=4, OS id=4600
Sun Dec 08 23:42:23 2019
DIAG started with pid=5, OS id=3592
Sun Dec 08 23:42:23 2019
DBRM started with pid=6, OS id=5928
Sun Dec 08 23:42:23 2019
PSP0 started with pid=7, OS id=3896
Sun Dec 08 23:42:23 2019
DIA0 started with pid=8, OS id=5832
Sun Dec 08 23:42:23 2019
MMAN started with pid=9, OS id=3824
Sun Dec 08 23:42:23 2019
DBW0 started with pid=10, OS id=4356
Sun Dec 08 23:42:23 2019
LGWR started with pid=11, OS id=3888
Sun Dec 08 23:42:23 2019
CKPT started with pid=12, OS id=5552
Sun Dec 08 23:42:24 2019
SMON started with pid=13, OS id=5960
Sun Dec 08 23:42:24 2019
RECO started with pid=14, OS id=3844
Sun Dec 08 23:42:24 2019
MMON started with pid=15, OS id=2328
Sun Dec 08 23:42:24 2019
MMNL started with pid=16, OS id=4020
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = E:\app\Administrator
Sun Dec 08 23:42:27 2019
Sweep [inc][130276]: completed
Sweep [inc2][130276]: completed
Sun Dec 08 23:43:31 2019
alter database mount
Sun Dec 08 23:43:35 2019
Successful mount of redo thread 1, with mount id 1554319907
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Sun Dec 08 23:43:42 2019
alter database open
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Started redo scan
Completed redo scan
read 63 KB redo, 41 data blocks need recovery
Started redo application at
Thread 1: logseq 6, block 2, scn 929876870
Recovery of Online Redo Log: Thread 1 Group 3 Seq 6 Reading mem 0
Mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Completed redo application of 0.04MB
Completed crash recovery at
Thread 1: logseq 6, block 129, scn 929897022
41 data blocks read, 41 data blocks written, 63 redo k-bytes read
Thread 1 advanced to log sequence 7 (thread open)
Thread 1 opened at log sequence 7
Current log# 1 seq# 7 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Dec 08 23:43:42 2019
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sun Dec 08 23:43:43 2019
QMNC started with pid=23, OS id=3372
Completed: alter database open
Sun Dec 08 23:43:45 2019
db_recovery_file_dest_size of 3912 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sun Dec 08 23:43:46 2019
Starting background process CJQ0
Sun Dec 08 23:43:46 2019
CJQ0 started with pid=24, OS id=3852
Setting Resource Manager plan SCHEDULER[0x3009]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sun Dec 08 23:43:49 2019
Starting background process VKRM
Sun Dec 08 23:43:49 2019
VKRM started with pid=26, OS id=3600
Sun Dec 08 23:43:52 2019
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Sun Dec 08 23:44:21 2019
Thread 1 cannot allocate new log, sequence 8
Private strand flush not complete
Current log# 1 seq# 7 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
Thread 1 advanced to log sequence 8 (LGWR switch)
Current log# 2 seq# 8 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Sun Dec 08 23:45:23 2019
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16807927/viewspace-2667456/ ，如需转载，请注明出处，否则将追究法律责任。
