IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    Oracle 23ai依旧支持bbed

    惜分飞发表于 2024-07-27 10:05:45
    love 0

    联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

    标题:Oracle 23ai依旧支持bbed

    作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

    bbed作为oracle恢复利器,在最新版的oracle 23ai中,依旧可以编译成功,并且正常使用

    [oracle@xifenfei db_1]$ make -f ./rdbms/lib/ins_rdbms.mk BBED=./bin/bbed ./bin/bbed
    
    Linking BBED utility (bbed)
    rm -f bin/bbed
    /u01/app/oracle/product/23ai/db_1/bin/orald -o bin/bbed -m64 -z 
    …………
    blist` -ldl -lm   -L/u01/app/oracle/product/23ai/db_1/lib
    [oracle@xifenfei db_1]$ 
    [oracle@xifenfei db_1]$ 
    [oracle@xifenfei db_1]$ bbed
    Password: 
    
    BBED: Release 2.0.0.0.0 - for Oracle Cloud and Engineered Systems on Sun Jul 28 01:50:44 2024
    
    Copyright (c) 1982, 2024, Oracle and/or its affiliates.  All rights reserved.
    
    ************* !!! For Oracle Internal Use only !!! ***************
    
    BBED> set filename '/u01/app/oracle/oradata/ORA23AI/system01.dbf'
            FILENAME        /u01/app/oracle/oradata/ORA23AI/system01.dbf
    
    BBED> set blocksize 8192
            BLOCKSIZE       8192
    
    BBED> set block 1
            BLOCK#          1
    
    BBED> map
     File: /u01/app/oracle/oradata/ORA23AI/system01.dbf (0)
     Block: 1                                     Dba:0x00000000
    ------------------------------------------------------------
     Data File Header
    
     struct kcvfh, 1272 bytes                   @0       
    
     ub4 tailchk                                @8188    
    
    
    BBED> p kcvfh
    struct kcvfh, 1272 bytes                    @0       
       struct kcvfhbfh, 20 bytes                @0       
          ub1 type_kcbh                         @0        0x0b
          ub1 frmt_kcbh                         @1        0xa2
          ub2 wrp2_kcbh                         @2        0x0000
          ub4 rdba_kcbh                         @4        0x00000001
          ub4 bas_kcbh                          @8        0x00000000
          ub2 wrp_kcbh                          @12       0x0000
          ub1 seq_kcbh                          @14       0x01
          ub1 flg_kcbh                          @15       0x04 (KCBHFCKV)
          ub2 chkval_kcbh                       @16       0xed1e
          ub2 spare3_kcbh                       @18       0x0000
       struct kcvfhhdr, 76 bytes                @20      
          ub4 kccfhswv                          @20       0x00000000
          ub4 kccfhcvn                          @24       0x17040000
          ub4 kccfhdbi                          @28       0x8fe89c42
          text kccfhdbn[0]                      @32      O
          text kccfhdbn[1]                      @33      R
          text kccfhdbn[2]                      @34      A
          text kccfhdbn[3]                      @35      2
          text kccfhdbn[4]                      @36      3
          text kccfhdbn[5]                      @37      A
          text kccfhdbn[6]                      @38      I
          text kccfhdbn[7]                      @39       
          ub4 kccfhcsq                          @40       0x000002db
          ub4 kccfhfsz                          @44       0x00020300
          s_blkz kccfhbsz                       @48       0x00
          ub2 kccfhfno                          @52       0x0001
          ub2 kccfhtyp                          @54       0x0003
          ub4 kccfhacid                         @56       0x00000000
          ub4 kccfhcks                          @60       0x00000000
          text kccfhtag[0]                      @64       
          text kccfhtag[1]                      @65       
          text kccfhtag[2]                      @66       
          text kccfhtag[3]                      @67       
          text kccfhtag[4]                      @68       
          text kccfhtag[5]                      @69       
          text kccfhtag[6]                      @70       
          text kccfhtag[7]                      @71       
          text kccfhtag[8]                      @72       
          text kccfhtag[9]                      @73       
          text kccfhtag[10]                     @74       
          text kccfhtag[11]                     @75       
          text kccfhtag[12]                     @76       
          text kccfhtag[13]                     @77       
          text kccfhtag[14]                     @78       
          text kccfhtag[15]                     @79       
          text kccfhtag[16]                     @80       
          text kccfhtag[17]                     @81       
          text kccfhtag[18]                     @82       
          text kccfhtag[19]                     @83       
          text kccfhtag[20]                     @84       
          text kccfhtag[21]                     @85       
          text kccfhtag[22]                     @86       
          text kccfhtag[23]                     @87       
          text kccfhtag[24]                     @88       
          text kccfhtag[25]                     @89       
          text kccfhtag[26]                     @90       
          text kccfhtag[27]                     @91       
          text kccfhtag[28]                     @92       
          text kccfhtag[29]                     @93       
          text kccfhtag[30]                     @94       
          text kccfhtag[31]                     @95       
       ub4 kcvfhrdb                             @96       0x00000208
       struct kcvfhcrs, 8 bytes                 @100     
          ub4 kscnbas                           @100      0x00000008
          ub2 kscnwrp                           @104      0x8000
          ub2 kscnwrp2                          @106      0x0000
       ub4 kcvfhcrt                             @108      0x45fa1056
       ub4 kcvfhrlc                             @112      0x460f5f02
       struct kcvfhrls, 8 bytes                 @116     
          ub4 kscnbas                           @116      0x001f315f
          ub2 kscnwrp                           @120      0x8000
          ub2 kscnwrp2                          @122      0x0000
       ub4 kcvfhbti                             @124      0x00000000
       struct kcvfhbsc, 8 bytes                 @128     
          ub4 kscnbas                           @128      0x00000000
          ub2 kscnwrp                           @132      0x0000
          ub2 kscnwrp2                          @134      0x0000
       ub2 kcvfhbth                             @136      0x0000
       ub2 kcvfhsta                             @138      0x2004 (KCVFHOFZ)
       struct kcvfhckp, 36 bytes                @484     
          struct kcvcpscn, 8 bytes              @484     
             ub4 kscnbas                        @484      0x001f76c3
             ub2 kscnwrp                        @488      0x8000
             ub2 kscnwrp2                       @490      0x0000
          ub4 kcvcptim                          @492      0x460f5f87
          ub2 kcvcpthr                          @496      0x0001
          union u, 12 bytes                     @500     
             struct kcvcprba, 12 bytes          @500     
                ub4 kcrbaseq                    @500      0x00000001
                ub4 kcrbabno                    @504      0x0001ea34
                ub2 kcrbabof                    @508      0x0010
          ub1 kcvcpetb[0]                       @512      0x02
          ub1 kcvcpetb[1]                       @513      0x00
          ub1 kcvcpetb[2]                       @514      0x00
          ub1 kcvcpetb[3]                       @515      0x00
          ub1 kcvcpetb[4]                       @516      0x00
          ub1 kcvcpetb[5]                       @517      0x00
          ub1 kcvcpetb[6]                       @518      0x00
          ub1 kcvcpetb[7]                       @519      0x00
       ub4 kcvfhcpc                             @140      0x0000002d
       ub4 kcvfhrts                             @144      0x460f5edf
       ub4 kcvfhccc                             @148      0x0000002c
       struct kcvfhbcp, 36 bytes                @152     
          struct kcvcpscn, 8 bytes              @152     
             ub4 kscnbas                        @152      0x00000000
             ub2 kscnwrp                        @156      0x0000
             ub2 kscnwrp2                       @158      0x0000
          ub4 kcvcptim                          @160      0x00000000
          ub2 kcvcpthr                          @164      0x0000
          union u, 12 bytes                     @168     
             struct kcvcprba, 12 bytes          @168     
                ub4 kcrbaseq                    @168      0x00000000
                ub4 kcrbabno                    @172      0x00000000
                ub2 kcrbabof                    @176      0x0000
          ub1 kcvcpetb[0]                       @180      0x00
          ub1 kcvcpetb[1]                       @181      0x00
          ub1 kcvcpetb[2]                       @182      0x00
          ub1 kcvcpetb[3]                       @183      0x00
          ub1 kcvcpetb[4]                       @184      0x00
          ub1 kcvcpetb[5]                       @185      0x00
          ub1 kcvcpetb[6]                       @186      0x00
          ub1 kcvcpetb[7]                       @187      0x00
       ub4 kcvfhbhz                             @312      0x00000000
       struct kcvfhxcd, 16 bytes                @316     
          ub4 space_kcvmxcd[0]                  @316      0x00000000
          ub4 space_kcvmxcd[1]                  @320      0x00000000
          ub4 space_kcvmxcd[2]                  @324      0x00000000
          ub4 space_kcvmxcd[3]                  @328      0x00000000
       sword kcvfhtsn                           @332      0
       ub2 kcvfhtln                             @336      0x0006
       text kcvfhtnm[0]                         @338     S
       text kcvfhtnm[1]                         @339     Y
       text kcvfhtnm[2]                         @340     S
       text kcvfhtnm[3]                         @341     T
       text kcvfhtnm[4]                         @342     E
       text kcvfhtnm[5]                         @343     M
       text kcvfhtnm[6]                         @344      
       text kcvfhtnm[7]                         @345      
       text kcvfhtnm[8]                         @346      
       text kcvfhtnm[9]                         @347      
       text kcvfhtnm[10]                        @348      
       text kcvfhtnm[11]                        @349      
       text kcvfhtnm[12]                        @350      
       text kcvfhtnm[13]                        @351      
       text kcvfhtnm[14]                        @352      
       text kcvfhtnm[15]                        @353      
       text kcvfhtnm[16]                        @354      
       text kcvfhtnm[17]                        @355      
       text kcvfhtnm[18]                        @356      
       text kcvfhtnm[19]                        @357      
       text kcvfhtnm[20]                        @358      
       text kcvfhtnm[21]                        @359      
       text kcvfhtnm[22]                        @360      
       text kcvfhtnm[23]                        @361      
       text kcvfhtnm[24]                        @362      
       text kcvfhtnm[25]                        @363      
       text kcvfhtnm[26]                        @364      
       text kcvfhtnm[27]                        @365      
       text kcvfhtnm[28]                        @366      
       text kcvfhtnm[29]                        @367      
       ub4 kcvfhrfn                             @368      0x00000400
       struct kcvfhrfs, 8 bytes                 @372     
          ub4 kscnbas                           @372      0x00000000
          ub2 kscnwrp                           @376      0x0000
          ub2 kscnwrp2                          @378      0x0000
       ub4 kcvfhrft                             @380      0x00000000
       struct kcvfhafs, 8 bytes                 @384     
          ub4 kscnbas                           @384      0x00000000
          ub2 kscnwrp                           @388      0x0000
          ub2 kscnwrp2                          @390      0x0000
       ub4 kcvfhbbc                             @392      0x00000000
       ub4 kcvfhncb                             @396      0x00000000
       ub4 kcvfhmcb                             @400      0x00000000
       ub4 kcvfhlcb                             @404      0x00000000
       ub4 kcvfhbcs                             @408      0x00000000
       ub2 kcvfhofb                             @412      0x000a
       ub2 kcvfhnfb                             @414      0x000a
       ub4 kcvfhprc                             @416      0x45fa1051
       struct kcvfhprs, 8 bytes                 @420     
          ub4 kscnbas                           @420      0x00000001
          ub2 kscnwrp                           @424      0x0000
          ub2 kscnwrp2                          @426      0x0000
       struct kcvfhprfs, 8 bytes                @428     
          ub4 kscnbas                           @428      0x00000000
          ub2 kscnwrp                           @432      0x0000
          ub2 kscnwrp2                          @434      0x0000
       ub4 kcvfhtrt                             @444      0x00000000
    

    以前类似文章:
    bbed依旧支持Oracle 21c
    Oracle 19C 依旧支持bbed
    oracle 12.2依旧支持bbed
    ORACLE 12C 依然支持 bbed
    在win 64位平台上运行bbed(支持ORACLE 10g 11g 12c)

    • Oracle 19C 依旧支持bbed
    • bbed依旧支持Oracle 21c
    • oracle 18c依旧支持bbed
    • 使用bbed修复损坏datafile header
    • oracle 12.2依旧支持bbed
    • 拷贝windows中datafile header方法(ocopy)
    • ORACLE 12C 依然支持 bbed
    • 模拟enq: TX – allocate ITL entry等待
    • bbed模拟提交事务一之修改itl
    • bbed 修改datafile header
    • ORA-00600 [ktbdchk1: bad dscn] 解决
    • ORACLE AWR使用


沪ICP备19023445号-2号
友情链接