oracle dul 11

Oracle 2020-06-17

千呼万唤oracle dul 11终于发布了,迫不及待的下载来测试,现在版本号为dul 11.2.0.0.1,目前只发布了for linux,其他版本估计要等等.期待该版本有引进新功能
oracle dul 11发布

dul 11 测试恢复oracle 12c版本

 
        [root@ora1221 dul11] 
        # ./dul 
       
        Data UnLoader: 11.2.0.0.1 - Internal Only - on Mon Jun 13 00:04:50 2016 
       
        with 64-bit io functions 
       
        Copyright (c) 1994 2016 Bernard van Duijnen All rights reserved. 
       
        Strictly Oracle Internal Use Only 
       
        DUL: Warning: Recreating  
        file 
         "dul.log" 
       
        Found db_id = 1414800805 
       
        Found db_name = ORCL 
       
        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 
       
        60 rows unloaded 
       
        DUL: Warning: Dictionary cache DC_BOOTSTRAP is empty 
       
        Reading BOOTSTRAP.dat 60 entries loaded 
       
        Parsing Bootstrap$ contents 
       
         "dict.ddl" 
       
        Generating dict.ddl  
        for 
         version 12 
       
        OBJ$: segobjno 18, 
         1 block 240 
       
        TAB$: segobjno 2,tabno 1,monospace!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; width:auto!important; direction:ltr!important; display:inline!important"> 1 block 144 
       
        COL$: segobjno 2,tabno 5,monospace!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; width:auto!important; direction:ltr!important; display:inline!important"> 1 block 144 
       
        USER$: segobjno 10,monospace!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; width:auto!important; direction:ltr!important; display:inline!important"> 1 block 208 
       
        Running generated  
         "@dict.ddl" 
         to unload the dictionary tables 
       
        . unloading table OBJ$ 72547 rows unloaded 
       
        . unloading table TAB$ 2137 rows unloaded 
       
        . unloading table COL$ 115645 rows unloaded 
       
        . unloading table USER$ 129 rows unloaded 
       
        Reading USER.dat 129 entries loaded 
       
        Reading OBJ.dat 
       
        DUL: FATAL Error: File OBJ.dat,line 22094: identifier too long

dul 11 恢复oracle 12c 报错分析
看报错OBJ.dat报错数据,从定义上判断是长度过长

 
  # vi OBJ.dat  
        22091  
        "22435" 
         "" 
         "0" 
         "JVMFCB" 
         "9" 
         "" 
       
        22092  
        "22436" 
         "11" 
         "" 
       
        22093  
        "22437" 
         "56417" 
         "JAVA$CBOBJ$" 
         "2" 
         "" 
       
        ---- 22094  
        "22439" 
         "sun/util/xml/PlatformXmlPropertiesProvider$Resolver" 
         "29" 
         "" 
       
        22095  
        "22440" 
         "sun/util/xml/PlatformXmlPropertiesProvider$EH" 
         "" 
       
        22096  
        "22441" 
         "sun/util/xml/PlatformXmlPropertiesProvider$1" 
         "" 
       
        22097  
        "22442" 
         "sun/util/resources/LocaleNamesBundle" 
         ""

对象名长度分析

 
        [oracle@ora1221 ~]$ ss 
       
        sql*Plus: Release 12.2.0.0.3 Production  
        on 
         Fri Aug 7 02:50:35 2015 
       
        Copyright (c) 1982,2016,Oracle.  
        All 
         rights reserved. 
       
        Connected  
        to 
        : 
       
        Oracle  
        Database 
         12c Enterprise Edition Release 12.2.0.0.3 - 64bit Production 
       
        sql>  
        select 
         length(object_name)  
        from 
         dba_objects  
       
        2  
        where 
         object_name= 
        'sun/util/xml/PlatformXmlPropertiesProvider$Resolver' 
        ; 
       
        LENGTH(OBJECT_NAME) 
       
        ------------------- 
       
        51 
       
        select 
         max 
        (length(object_name))  
         dba_objects; 
       
        MAX 
        (LENGTH(OBJECT_NAME)) 
       
        ------------------------ 
       
        123 
       
        desc 
         dba_objects 
       
        Name 
         Null 
        ? Type 
       
        ----------------------------------------- -------- ---------------------------- 
       
        OWNER VARCHAR2(128) 
       
        OBJECT_NAME VARCHAR2(128) 
       
        SUBOBJECT_NAME VARCHAR2(128) 
       
        OBJECT_ID NUMBER 
       
        DATA_OBJECT_ID NUMBER 
       
        OBJECT_TYPE VARCHAR2(23) 
       
        CREATED  
        DATE 
       
        LAST_DDL_TIME  
        DATE 
       
        TIMESTAMP 
         VARCHAR2(19) 
       
        STATUS VARCHAR2(7) 
       
        TEMPORARY 
         VARCHAR2(1) 
       
        GENERATED VARCHAR2(1) 
       
        SECONDARY VARCHAR2(1) 
       
        NAMESPACE NUMBER 
       
        EDITION_NAME VARCHAR2(128) 
       
        SHARING VARCHAR2(18) 
       
        EDITIONABLE VARCHAR2(1) 
       
        ORACLE_MAINTAINED VARCHAR2(1) 
       
        APPLICATION VARCHAR2(1) 
       
        DEFAULT_COLLATION VARCHAR2(100) 
       
        DUPLICATED VARCHAR2(1) 
       
        SHARDED VARCHAR2(1) 
       
        CREATED_APPID NUMBER 
       
        CREATED_VSNID NUMBER 
       
        MODIFIED_APPID NUMBER 
       
        MODIFIED_VSNID NUMBER

在oracle 12c中对象名长度已经变为128,但是dul依旧不能支持列长度，既然作者已经在init.dul的Compatible参数曾增加了对12c的支持,那对这样明显的bug应该在不久的将来即可修复。当然这个问题,可以通过一些人工技巧绕过去

[Oracle]记一次由sequence引发的enq sv-contention等待事件

数据库版本：11.2.0.4 RAC(1)问题现象从EM里面可以看到，在23号早上8：45~8：55时，数据库等待会话暴增...

oracle统计信息的锁定与解锁

（一）问题背景最近在对一个大约200万行数据的表查看执行计划时，发现存在异常，理论上应该返回100多万...

【转】RMAN删除过期备份或非过期备份

（一）删除备份--DELETE命令用于删除RMAN备份记录及相应的物理文件。当使用RMAN执行备份操作时，会在RM...

数据恢复顾问（DRA）

（1）DRA介绍数据恢复顾问（Data Recovery Advise）是一个诊断和修复数据库的工具，DRA能够修复数据文...

RMAN备份与恢复（一）--认识RMAN

RMAN（Recovery Manager）是Oracle恢复管理器的简称，是集数据库备份（backup）、修复（restore）和恢复...

oracle dul 11

相关文章