试验模拟导出Oracle 11G数据库中数据文件坏块中表中的数据
以前一直以为dul对应的版本只能恢复最高的数据库版本一致,今天测试发现dul 10可以恢复11g最新版的数据库.
模拟环境SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLSRTL Version 11.2.0.3.0 - ProductionSQL> select to_char(sysdate,'yyyy-mm-dd hh:mi:ss') "WWW.XIFENFEI.COM" FROM DUAL;WWW.XIFENFEI.COM-------------------2012-08-04 12:49:29SQL> create table t_xifenfei 2 as 3 select * from dba_objects;Table created.SQL> select count(*) from t_xifenfei; COUNT(*)---------- 74491SQL> alter system checkpoint;System altered.SQL> /System altered.
dul 参数配置
[oracle@xifenfei dul]$ more init.dul osd_big_endian_flag=falseosd_dba_file_bits=10osd_c_struct_alignment=32osd_file_leader_size=0osd_word_size = 32dc_columns=2000000dc_tables=10000dc_objects=1000000dc_users=400dc_segments=100000control_file = control11.duldb_block_size=8192export_mode=falsecompatible=11BUFFER=10000000LDR_ENCLOSE_CHAR=|[oracle@xifenfei dul]$ more control11.dul 0 1 /u01/oracle/oradata/ora11g/system01.dbf 1 2 /u01/oracle/oradata/ora11g/sysaux01.dbf 2 3 /u01/oracle/oradata/ora11g/undotbs01.dbf 4 4 /u01/oracle/oradata/ora11g/users01.dbf
dul恢复11g数据库
[oracle@xifenfei dul]$ ./dul10Data UnLoader: 10.2.0.5.13 - Internal Only - on Sat Aug 4 00:36:15 2012with 64-bit io functionsCopyright (c) 1994 2012 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use OnlyDUL: Warning: Recreating file "dul.log"Found db_id = 4185048347Found db_name = ORA11GDUL> 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 unloadedDUL: Warning: Dictionary cache DC_BOOTSTRAP is emptyReading BOOTSTRAP.dat 60 entries loadedParsing Bootstrap$ contentsGenerating 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 208Running generated file "@dict.ddl" to unload the dictionary tables. unloading table OBJ$ 74493 rows unloaded. unloading table TAB$ 2858 rows unloaded. unloading table COL$ 93503 rows unloaded. unloading table USER$ 88 rows unloadedReading USER.dat 88 entries loadedReading OBJ.dat 74493 entries loaded and sorted 74493 entriesReading TAB.dat 2858 entries loadedReading COL.dat 93503 entries loaded and sorted 93503 entriesReading BOOTSTRAP.dat 60 entries loadedDUL: 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 568, file 1 block 3872 INDPART$: segobjno 573, file 1 block 3912 TABCOMPART$: segobjno 590, file 1 block 4056 INDCOMPART$: segobjno 595, file 1 block 4096 TABSUBPART$: segobjno 580, file 1 block 3976 INDSUBPART$: segobjno 585, file 1 block 4016 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 495, tabno 1, file 1 block 3344 COLLECTION$: segobjno 495, tabno 2, file 1 block 3344 ATTRIBUTE$: segobjno 495, tabno 3, file 1 block 3344 LOBFRAG$: segobjno 601, file 1 block 4144 LOBCOMPPART$: segobjno 604, file 1 block 4168 UNDO$: segobjno 15, file 1 block 224 TS$: segobjno 6, tabno 2, file 1 block 176 PROPS$: segobjno 98, file 1 block 800Running generated file "@dict.ddl" to unload the dictionary tables. unloading table OBJ$DUL: Warning: Recreating file "OBJ.ctl" 74493 rows unloaded. unloading table TAB$DUL: Warning: Recreating file "TAB.ctl" 2858 rows unloaded. unloading table COL$DUL: Warning: Recreating file "COL.ctl" 93503 rows unloaded. unloading table USER$DUL: Warning: Recreating file "USER.ctl" 88 rows unloaded. unloading table TABPART$ 90 rows unloaded. unloading table INDPART$ 106 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$ 5092 rows unloaded. unloading table ICOL$ 7518 rows unloaded. unloading table LOB$ 1251 rows unloaded. unloading table COLTYPE$ 2967 rows unloaded. unloading table TYPE$ 2872 rows unloaded. unloading table COLLECTION$ 985 rows unloaded. unloading table ATTRIBUTE$ 11127 rows unloaded. unloading table LOBFRAG$ 1 row unloaded. unloading table LOBCOMPPART$ 0 rows unloaded. unloading table UNDO$ 21 rows unloaded. unloading table TS$ 6 rows unloaded. unloading table PROPS$ 36 rows unloadedReading USER.dat 88 entries loadedReading OBJ.dat 74493 entries loaded and sorted 74493 entriesReading TAB.dat 2858 entries loadedReading COL.dat 93503 entries loaded and sorted 93503 entriesReading TABPART.dat 90 entries loaded and sorted 90 entriesReading TABCOMPART.dat 1 entries loaded and sorted 1 entriesReading TABSUBPART.dat 32 entries loaded and sorted 32 entriesReading INDPART.dat 106 entries loaded and sorted 106 entriesReading INDCOMPART.dat 0 entries loaded and sorted 0 entriesReading INDSUBPART.dat 0 entries loaded and sorted 0 entriesReading IND.dat 5092 entries loadedReading LOB.datDUL: Warning: Increased the size of DC_LOBS from 1024 to 8192 entries 1251 entries loadedReading ICOL.dat 7518 entries loadedReading COLTYPE.dat 2967 entries loadedReading TYPE.dat 2872 entries loadedReading ATTRIBUTE.dat 11127 entries loadedReading COLLECTION.dat 985 entries loadedReading BOOTSTRAP.dat 60 entries loadedReading LOBFRAG.dat 1 entries loaded and sorted 1 entriesReading LOBCOMPPART.dat 0 entries loaded and sorted 0 entriesReading UNDO.dat 21 entries loadedReading TS.dat 6 entries loadedReading PROPS.dat 36 entries loadedDatabase character set is ZHS16GBKDatabase national character set is AL16UTF16DUL> desc chf.t_xifenfei;Table CHF.T_XIFENFEIobj#= 75562, dataobj#= 75562, ts#= 4, file#= 4, block#=170 tab#= 0, segcols= 15, clucols= 0Column information:icol# 01 segcol# 01 OWNER len 30 type 1 VARCHAR2 cs 852(ZHS16GBK)icol# 02 segcol# 02 OBJECT_NAME len 128 type 1 VARCHAR2 cs 852(ZHS16GBK)icol# 03 segcol# 03 SUBOBJECT_NAME len 30 type 1 VARCHAR2 cs 852(ZHS16GBK)icol# 04 segcol# 04 OBJECT_ID len 22 type 2 NUMBER(0,-127)icol# 05 segcol# 05 DATA_OBJECT_ID len 22 type 2 NUMBER(0,-127)icol# 06 segcol# 06 OBJECT_TYPE len 19 type 1 VARCHAR2 cs 852(ZHS16GBK)icol# 07 segcol# 07 CREATED len 7 type 12 DATEicol# 08 segcol# 08 LAST_DDL_TIME len 7 type 12 DATEicol# 09 segcol# 09 TIMESTAMP len 19 type 1 VARCHAR2 cs 852(ZHS16GBK)icol# 10 segcol# 10 STATUS len 7 type 1 VARCHAR2 cs 852(ZHS16GBK)icol# 11 segcol# 11 TEMPORARY len 1 type 1 VARCHAR2 cs 852(ZHS16GBK)icol# 12 segcol# 12 GENERATED len 1 type 1 VARCHAR2 cs 852(ZHS16GBK)icol# 13 segcol# 13 SECONDARY len 1 type 1 VARCHAR2 cs 852(ZHS16GBK)icol# 14 segcol# 14 NAMESPACE len 22 type 2 NUMBER(0,-127)icol# 15 segcol# 15 EDITION_NAME len 30 type 1 VARCHAR2 cs 852(ZHS16GBK)DUL> unload table chf.t_xifenfei;. unloading table T_XIFENFEI 74491 rows unloaded
通过一些列的dul 10测试,发现dul 10功能确实较9强大了很多.支持asm,支持11g,支持字符串换行+lob类型
-----------------温馨提示--------------------操作有风险，动手需谨慎http://www.oracleplus.net本文由大师惜分飞原创分享，转载请尽量保留本站网址
--------------------------------------ORACLE-DBA----------------------------------------
最权威、专业的Oracle案例资源汇总之学习笔记:Oracle dul数据挖掘 导出Oracle11G数据文件坏块中表中
原文唯一网址：