Dul basic usage

These days, my friend asked me how to use dul and took the time to give him an experiment. In fact, there are already many ways to use dul on the internet, and I do not recommend using tools such as dul and odu to restore data, which is physically active. and now the latest version is a time limit, it seems to be more than 40 days, the specific forgot. I hope you will not use this similar tool dul.

These days, my friend asked me how to use dul and took the time to give him an experiment. In fact, there are already many ways to use dul on the internet, and I do not recommend using tools such as dul and odu to restore data, which is physically active. and now the latest version is a time limit, it seems to be more than 40 days, the specific forgot. I hope you will not use this similar tool dul.

These days, my friend asked me how to use dul and took the time to give him an experiment. In fact, there are already many ways to use dul on the internet, and I do not recommend using tools such as dul and odu to restore data, which is physically active.
And now the latest version is a time limit, it seems to be more than 40 days, the specific forgot. I hope you will not use this similar tool.

The main dul parameter file is init. dul. The following is an example.

╭ ── Oracle @ enmotech ~ /Dul restart? Cat init. dul quota = false -- small byte platform quota = bytes = 32 # osd these parameters involve the feedback = 1000dc_columns = 2000000dc_tables = export dc_objects = 000000dc_users = 400dc_segments = parts = TRUECONTROL_FILE = file.txt -- specifies the file information to be extracted LDR_ENCLOSE_CHAR = | db_block_size = 8192export_mode = FALSE -- export the file in file format, true export dmp file compatible = 11

The second main file of dul is the file specified by the CONTROL_FILE parameter. The following is an example.

╭ ── Oracle @ enmotech ~ /Dul restart? Cat file.txt 0 1/oradata/orcl/system01.dbf 1 2/oradata/orcl/kernel 2 3/oradata/orcl/kernel 4 4/oradata/orcl/users01.dbf 30 5/oradata/orcl /test01.dbf 28 6/oradata/orcl/dbtk. dbf 29 7/oradata/orcl/ignite. dbf 5 8/oradata/orcl/golden1_01.dbf 31 9/oradata/orcl/ogg_test01.dbf 33 1024/oradata/orcl/big_test.dbf restart-oracle @ enmotech ~ /Dul you can also directly write the file name ╭ ── oracle @ enmotech ~ /Dul restart? Cat file.txt 1? /Oradata/orcl/system01.dbf/oradata/orcl/logs/oradata/orcl/users01.dbf/oradata/orcl/test01.dbf/oradata/orcl/dbtk. dbf/oradata/orcl/ignite. dbf/oradata/orcl/golden1_01.dbf/oradata/orcl/ogg_test01.dbf/oradata/orcl/big_test.dbf restart-oracle @ enmotech ~ /Dul restart?

The following code is used. If the system file exists

╭ ── Oracle @ enmotech ~ /Dul restart?. /Dul Data UnLoader: 10.2.0.5.32-Internal Only-on Tue Jul 15 12:22:17 2014 with 64-bit io functions Copyright (c) 1994 2014 Bernard van Duijnen All rights reserved. strictly Oracle Internal Use Only DUL: Warning: Recreating file "dul. log "Found db_id = 1348727197 Found db_name = ORCLDUL> show datafiles -- View data files ts # rf # start blocks offs open err file name 0 1 0 89601 0 0 0/oradata/orcl/ system01.dbf 1 2 0 409601 0 0/oradata/orcl/sysaux01.dbf 2 3 0 240225 0 0 0 0/oradata/orcl/limit 4 4 4 0 129601 0 0 0/oradata/orcl/users01.dbf 30 5 0 6401 0 0/oradata/orcl/test01.dbf 28 6 0 75537 0 0 0/oradata/orcl/dbtk. dbf 29 7 0 25601 0 0 0/oradata/orcl/ignite. dbf 5 8 0 2561 0 0 0/oradata/orcl/golden1_01.dbf 31 9 0 118537 0 1 0/oradata/orcl/ogg_test01.dbf 33 1024 0 12801 0 1 0/oradata/orcl/big_test.dbfDUL> bootstrap-data dictionary mining 2; 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 $ contentsDUL: 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 Running generated file "@ dict. ddl "to unload the dictionary tables. unloading table OBJ $14530 rows unloaded. unloading table TAB $1450 rows unloaded. unloading table COL $63476 rows unloaded. unloading table USER $45 rows unloadedReading USER. dat 45 entries loadedReading OBJ. dat 14530 entries loaded and sorted 14530 entriesReading TAB. dat 1450 entries loadedReading COL. dat 63476 entries loaded and sorted 63476 entriesReading BOOTSTRAP. dat 60 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 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 800 Running generated file "@ dict. ddl "to unload the dictionary tables. unloading table OBJ $ DUL: Warning: Recreating file "OBJ. ctl "14530 rows unloaded. unloading table TAB $ DUL: Warning: Recreating file "TAB. ctl "1450 rows unloaded. unloading table COL $ DUL: Warning: Recreating file "COL. ctl "63476 rows unloaded. unloading table USER $ DUL: Warning: Recreating file "USER. ctl "45 rows unloaded. unloading table TABPART $147 rows unloaded. unloading table INDPART $153 rows unloaded. unloading table TABCOMPART $5 rows unloaded. unloading table INDCOMPART $4 rows unloaded. unloading table TABSUBPART $38 rows unloaded. unloading table INDSUBPART $6 rows unloaded. unloading table IND $1757 rows unloaded. unloading table ICOL $3609 rows unloaded. unloading table LOB $218 rows unloaded. unloading table COLTYPE $1594 rows unloaded. unloading table TYPE $1328 rows unloaded. unloading table COLLECTION $338 rows unloaded. unloading table ATTRIBUTE $5676 rows unloaded. unloading table LOBFRAG $1 row unloaded. unloading table LOBCOMPPART $0 rows unloaded. unloading table UNDO $41 rows unloaded. unloading table TS $36 rows unloaded. unloading table PROPS $36 rows unloadedReading USER. dat 45 entries loadedReading OBJ. dat 14530 entries loaded and sorted 14530 entriesReading TAB. dat 1450 entries loadedReading COL. dat 63476 entries loaded and sorted 63476 entriesReading TABPART. dat 147 entries loaded and sorted 147 entriesReading TABCOMPART. dat 5 entries loaded and sorted 5 entriesReading TABSUBPART. dat 38 entries loaded and sorted 38 entriesReading INDPART. dat 153 entries loaded and sorted 153 entriesReading INDCOMPART. dat 4 entries loaded and sorted 4 entriesReading INDSUBPART. dat 6 entries loaded and sorted 6 entriesReading IND. dat 1757 entries loadedReading LOB. dat 218 entries loadedReading ICOL. dat 3609 entries loadedReading COLTYPE. dat 1594 entries loadedReading TYPE. dat 1328 entries loadedReading ATTRIBUTE. dat 5676 entries loadedReading COLLECTION. dat 338 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 41 entries loadedReading TS. dat 36 entries loadedReading PROPS. dat 36 entries loadedDatabase character set is ZHS16GBKDatabase national character set is AL16UTF16 DUL> show undo; -- View undous # status $ Description name segment header block0 3 KTUINUSE (in use) SYSTEM ts 0 file 1 block 1281 1 KTUINVAL (invalid) _ SYSSMU1_1369880276 $ ts 2 file 3 block 1282 1 KTUINVAL (invalid) _ region $ ts 2 file 3 block 1443 1 KTUINVAL (invalid) _ SYSSMU3_2108513962 $ ts 2 file 3 block 1604 1 KTUINVAL (invalid) _ syssmu4_3639597val $ ts 2 file 3 block 1765 1 KTUINVAL (invalid) _ SYSSMU5_3500755112 $ ts 2 file 3 block 1926 1 KTUINVAL (invalid) _ SYSSMU6_2567534412 $ ts 2 file 3 block 2087 1 KTUINVAL (invalid) _ syssmu7_3501_3778 $ ts 2 file 3 block 2248 1 KTUINVAL (invalid) _ syssmu8_00005069961 $ ts 2 file 3 block 2409 1 KTUINVAL (invalid) _ SYSSMU9_595419161 $ ts 2 file 3 block 25610 1 KTUINVAL (invalid) _ SYSSMU10_2169650900 $ ts 2 file 3 block 27211 1 KTUINVAL (invalid) _ syssmu11_00001576427 $ ts 26 file 7 block 12812 1 KTUINVAL (invalid) _ SYSSMU12_2246972428 $ ts 26 file 7 block 14413 1 KTUINVAL (invalid) _ SYSSMU13_716936117 $ ts 26 file 7 block 16014 1 KTUINVAL (invalid) _ SYSSMU14_1643483354 $ ts 26 file 7 block 17615 1 KTUINVAL (invalid) _ SYSSMU15_3959622672 $ ts 26 file 7 block 19216 1 KTUINVAL (invalid) _ SYSSMU16_1040802448 $ ts 26 file 7 block 20817 1 KTUINVAL (invalid) _ SYSSMU17_2705027949 $ ts 26 file 7 blocks 22418 1 KTUINVAL (invalid) _ SYSSMU18_1778755453 $ ts 26 file 7 block 24019 1 KTUINVAL (invalid) _ SYSSMU19_113712248 $ ts 26 file 7 block 25620 1 KTUINVAL (invalid) _ SYSSMU20_3294746070 $ ts 26 file 7 block 27221 2 KTUAVAIL (available) _ SYSSMU21_200063127 $ ts 2 file 3 block 12822 2 KTUAVAIL (available) _ SYSSMU22_2449563750 $ ts 2 file 3 block 14423 2 KTUAVAIL (available) _ syssmu23_292172.1617 $ ts 2 file 3 block 16024 2 KTUAVAIL (available) _ SYSSMU24_1606202302 $ ts 2 file 3 block 17625 2 KTUAVAIL (available) _ SYSSMU25_2650409587 $ ts 2 file 3 block 19226 2 KTUAVAIL (available) _ SYSSMU26_3913076954 $ ts 2 file 3 block 20827 2 KTUAVAIL (available) _ SYSSMU27_3238715147 $ ts 2 file 3 block 22428 2 KTUAVAIL (available) _ SYSSMU28_2600633533 $ ts 2 file 3 block 24029 2 KTUAVAIL (available) _ SYSSMU29_2643192669 $ ts 2 file 3 block 25630 2 KTUAVAIL (available) _ syssmu30_0000934135 $ ts 2 file 3 block 27231 1 KTUINVAL (invalid) _ SYSSMU31_2304516445 $ ts 27 file 6 block 12832 1 KTUINVAL (invalid) _ SYSSMU32_3887112535 $ ts 27 file 6 block 14433 1 KTUINVAL (invalid) _ SYSSMU33_88603952 $ ts 27 file 6 block 16034 1 KTUINVAL (invalid) _ SYSSMU34_1689777477 $ ts 27 file 6 block 17635 1 KTUINVAL (invalid) _ SYSSMU35_2746457455 $ ts 27 file 6 block 19236 1 KTUINVAL (invalid) _ SYSSMU36_3504890656 $ ts 27 file 6 block 20837 1 KTUINVAL (invalid) _ SYSSMU37_3917047416 $ ts 27 file 6 block 22438 1 KTUINVAL (invalid) _ SYSSMU38_1684124047 $ ts 27 file 6 block 24039 1 KTUINVAL (invalid) _ SYSSMU39_2587846914 $ ts 27 file 6 block 25640 1 KTUINVAL (invalid) _ SYSSMU40_2956833625 $ ts 27 file 6 block 272 DUL> desc travel. t1 -- View Table structure 2; Table TRAVEL. t1obj # = 17424, dataobj # = 17424, ts # = 4, file # = 4, block # = 85802 tab # = 0, segcols = 16, clucols = 0 Column 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) icol #16 segcol #16 ID len 22 type 2 NUMBER (0,-127) DUL> unload table travel. t1; -- unload table. unloading table T1 0 rows unloadedDUL> unload table travel. t2 ;. unloading table T2. unloading partition T_R_P1. unloading sub partition SYS_SUBP64. unloading partition T_R_P2. unloading sub partition sys_sub65. unloading partition T_R_P3. unloading sub partition T_R_P3_H1. unloading sub partition T_R_P3_H2. unloading sub partition T_R_P3_H3. unloading partition T_R_PD. unloading sub partition SYS_SUBP66. table T2 total 2 rows unloadedDUL> unload table travel. t3 ;. unloading table T3. 2838 rows unloaded

Original article address: Dul basic usage. Thank you for sharing it with the original author.