周末修裤子-生产遭遇ORA-00600 [kokasgi1]的恢复过程

来源：这里教程网时间：2026-03-03 14:40:57 作者：

########作者: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