酷酷娱乐网

站内广告

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

时间:2020-09-07 01:00:03   作者:酷酷娱乐网   来源:www.kukuyl.com  
内容摘要:
########作者:sky QQ:654268465,转载请注明出处########

上周一......

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

本文章url:https://www.kukuyl.com/new/30000239.html

相关文章

CopyRight 2018 - 2020 http://www.kukuyl.com 酷酷娱乐网 All Rights Reserved .