|
联系：手机(+86 13429648788)QQ(107644445)
标题：oracle dul 11 正式发布
作者：惜分飞?版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
千呼万唤oracle dul 11终于发布了,迫不及待的下载来测试,现在版本号为dul 11.2.0.0.1,目前只发布了for linux,其他版本估计要等等.期待该版本有引进新功能
oracle dul 11发布
dul 11 测试恢复oracle 12c版本
|
[root@ora1221 dul11]
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应该在不久的将来即可修复。当然这个问题,可以通过一些人工技巧绕过去
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
