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

    最新版oracle dul工具

    惜分飞发表于 2023-03-05 07:26:24
    love 0

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

    标题:最新版oracle dul工具

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

    oracle官方dul工具继续更新,现在已经更新到12.2.0.2.5版本,可以支持oracle 6及其以上的所有版本,是oracle数据库在极端情况下恢复利器

    [oracle@xifenfei dul]$ ./dul
    
    Data UnLoader: 12.2.0.2.5 - Internal Only - on Sun Mar  5 15:12:11 2023
    with 64-bit io functions and the decompression option
    
    Copyright (c) 1994 2023 Bernard van Duijnen All rights reserved.
    
     Strictly Oracle Internal Use Only
    
    
    DUL: Warning: Could not open parameter file <init.dul>
    DUL: Warning: Compatible is set to 11 Values can be 6|7|8|9|10|11|12|17|18
    DUL: Warning: no parameter file means no logfile
    DUL> 
    

    配置init.dul文件之后

    [oracle@iZbp1hx0enix3hix1kvyrxZ dul]$ ./dul
    
    Data UnLoader: 12.2.0.2.5 - Internal Only - on Sun Mar  5 15:22:26 2023
    with 64-bit io functions and the decompression option
    
    Copyright (c) 1994 2023 Bernard van Duijnen All rights reserved.
    
     Strictly Oracle Internal Use Only
    
    
    Found db_id = 1588579327
    Found db_name = ORCL
    DUL> show datafiles;
    ts# rf# start   blocks offs open  err file name
      0   1     0    97281    0    1    0 /u01/app/oracle/oradata/orcl/system01.dbf
      1   2     0   387841    0    1    0 /u01/app/oracle/oradata/orcl/sysaux01.dbf
      2   3     0    37761    0    1    0 /u01/app/oracle/oradata/orcl/undotbs01.dbf
      4   4     0     5761    0    1    0 /u01/app/oracle/oradata/orcl/users01.dbf
      7   5     0    16385    0    1    0 /u01/app/oracle/oradata/orcl/t_xifenfei01.dbf
    DUL> bootstrap;
    Probing file = 1, block = 520
    . unloading table                BOOTSTRAP$
    DUL: Warning: block number is non zero but marked deferred trying to process it anyhow
          59 rows unloaded
    Reading BOOTSTRAP.dat 59 entries loaded
    Parsing Bootstrap$ contents
    Generating dict.ddl for version 11
     OBJ$: segobjno 18, file 1 block 240
     TAB$: segobjno 2, tabno 1, file 1  block 144
     COL$: segobjno 2, tabno 5, file 1  block 144
     USER$: segobjno 10, tabno 1, file 1  block 208
    Running generated file "@dict.ddl" to unload the dictionary tables
    . unloading table                      OBJ$   86411 rows unloaded
    . unloading table                      TAB$
    DUL: Warning: Block has been marked soft corrupt
    DUL: Error: While processing ts# 0 file# 1 block# 13335
        2904 rows unloaded
    . unloading table                      COL$
    DUL: Warning: Block has been marked soft corrupt
    DUL: Error: While processing ts# 0 file# 1 block# 13335
       94714 rows unloaded
    . unloading table                     USER$      88 rows unloaded
    Reading USER.dat 88 entries loaded
    Reading OBJ.dat 86411 entries loaded and sorted 86411 entries
    Reading TAB.dat 2904 entries loaded
    Reading COL.dat 94714 entries loaded and sorted 94714 entries
    Reading BOOTSTRAP.dat 59 entries loaded
    
    DUL: Warning: Recreating file "dict.ddl"
    Generating dict.ddl for version 11
     OBJ$: segobjno 18, file 1 block 240
     TAB$: segobjno 2, tabno 1, file 1  block 144
     COL$: segobjno 2, tabno 5, file 1  block 144
     USER$: segobjno 10, tabno 1, file 1  block 208
     TABPART$: segobjno 591, file 1 block 4000
     INDPART$: segobjno 596, file 1 block 4040
     TABCOMPART$: segobjno 613, file 1 block 4176
     INDCOMPART$: segobjno 618, file 1 block 4216
     TABSUBPART$: segobjno 603, file 1 block 4096
     INDSUBPART$: segobjno 608, file 1 block 4136
     IND$: segobjno 2, tabno 3, file 1  block 144
     ICOL$: segobjno 2, tabno 4, file 1  block 144
     LOB$: segobjno 2, tabno 6, file 1  block 144
     COLTYPE$: segobjno 2, tabno 7, file 1  block 144
     TYPE$: segobjno 518, tabno 1, file 1  block 3464
     COLLECTION$: segobjno 518, tabno 2, file 1  block 3464
     ATTRIBUTE$: segobjno 518, tabno 3, file 1  block 3464
     LOBFRAG$: segobjno 624, file 1 block 4264
     LOBCOMPPART$: segobjno 627, file 1 block 4288
     UNDO$: segobjno 15, file 1 block 224
     TS$: segobjno 6, tabno 2, file 1  block 176
     PROPS$: segobjno 98, file 1 block 800
    Running generated file "@dict.ddl" to unload the dictionary tables
    . unloading table                      OBJ$
    DUL: Warning: Recreating file "OBJ.ctl"
       86411 rows unloaded
    . unloading table                      TAB$
    DUL: Warning: Block has been marked soft corrupt
    DUL: Error: While processing ts# 0 file# 1 block# 13335
    
    DUL: Warning: Recreating file "TAB.ctl"
        2904 rows unloaded
    . unloading table                      COL$
    DUL: Warning: Block has been marked soft corrupt
    DUL: Error: While processing ts# 0 file# 1 block# 13335
    
    DUL: Warning: Recreating file "COL.ctl"
       94714 rows unloaded
    . unloading table                     USER$
    DUL: Warning: Recreating file "USER.ctl"
          88 rows unloaded
    . unloading table                  TABPART$     143 rows unloaded
    . unloading table                  INDPART$     124 rows unloaded
    . unloading table               TABCOMPART$       1 row  unloaded
    . unloading table               INDCOMPART$       0 rows unloaded
    . unloading table               TABSUBPART$      32 rows unloaded
    . unloading table               INDSUBPART$       0 rows unloaded
    . unloading table                      IND$
    DUL: Warning: Block has been marked soft corrupt
    DUL: Error: While processing ts# 0 file# 1 block# 13335
        4931 rows unloaded
    . unloading table                     ICOL$
    DUL: Warning: Block has been marked soft corrupt
    DUL: Error: While processing ts# 0 file# 1 block# 13335
        7644 rows unloaded
    . unloading table                      LOB$
    DUL: Warning: Block has been marked soft corrupt
    DUL: Error: While processing ts# 0 file# 1 block# 13335
        1031 rows unloaded
    . unloading table                  COLTYPE$
    DUL: Warning: Block has been marked soft corrupt
    DUL: Error: While processing ts# 0 file# 1 block# 13335
        2565 rows unloaded
    . unloading table                     TYPE$    2909 rows unloaded
    . unloading table               COLLECTION$    1002 rows unloaded
    . unloading table                ATTRIBUTE$   11328 rows unloaded
    . unloading table                  LOBFRAG$       1 row  unloaded
    . unloading table              LOBCOMPPART$       0 rows unloaded
    . unloading table                     UNDO$      21 rows unloaded
    . unloading table                       TS$       8 rows unloaded
    . unloading table                    PROPS$      36 rows unloaded
    Reading USER.dat 88 entries loaded
    Reading OBJ.dat 86411 entries loaded and sorted 86411 entries
    Reading TAB.dat 2904 entries loaded
    Reading COL.dat 94714 entries loaded and sorted 94714 entries
    Reading TABPART.dat 143 entries loaded and sorted 143 entries
    Reading TABCOMPART.dat 1 entries loaded and sorted 1 entries
    Reading TABSUBPART.dat 32 entries loaded and sorted 32 entries
    Reading INDPART.dat 124 entries loaded and sorted 124 entries
    Reading INDCOMPART.dat 0 entries loaded and sorted 0 entries
    Reading INDSUBPART.dat 0 entries loaded and sorted 0 entries
    Reading IND.dat 4931 entries loaded
    Reading LOB.dat
    DUL: Notice: Increased the size of DC_LOBS from 1024 to 8192 entries
     1031 entries loaded
    Reading ICOL.dat 7644 entries loaded
    Reading COLTYPE.dat 2565 entries loaded
    Reading TYPE.dat 2909 entries loaded
    Reading ATTRIBUTE.dat 11328 entries loaded
    Reading COLLECTION.dat 1002 entries loaded
    Reading BOOTSTRAP.dat 59 entries loaded
    Reading LOBFRAG.dat 1 entries loaded and sorted 1 entries
    Reading LOBCOMPPART.dat 0 entries loaded and sorted 0 entries
    Reading UNDO.dat 21 entries loaded
    Reading TS.dat 8 entries loaded
    Reading PROPS.dat 36 entries loaded
    Database character set is ZHS16GBK
    Database national character set is AL16UTF16
    DUL> 
    
    • dul 12.2完美支持Oracle 19c恢复
    • 使用 dul 挖数据文件初试
    • Oracle dul 依旧支持Oracle 21c
    • dul支持Oracle 19C
    • dul 10支持oracle 11g r2
    • DUL10直接支持ORACLE 8.0
    • 密码保护:dul扫描磁盘抢救数据
    • 最新版Oracle dul支持Oracle 7.2.3
    • Oracle dul支持Oracle 12.2(12c)
    • Oracle dul支持18c
    • 密码保护:使用dul恢复asm中数据
    • oracle dul 12 正式发布


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