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 openparameter file<init.dul> DUL: Warning: Compatible is setto 11 Values can be 6|7|8|9|10|11|12|17|18 DUL: Warning: no parameter filemeans 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 forversion 11 OBJ$: segobjno 18, file1 block 240 TAB$: segobjno 2, tabno 1, file1 block 144 COL$: segobjno 2, tabno 5, file1 block 144 USER$: segobjno 10, tabno 1, file1 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 forversion 11 OBJ$: segobjno 18, file1 block 240 TAB$: segobjno 2, tabno 1, file1 block 144 COL$: segobjno 2, tabno 5, file1 block 144 USER$: segobjno 10, tabno 1, file1 block 208 TABPART$: segobjno 591, file1 block 4000 INDPART$: segobjno 596, file1 block 4040 TABCOMPART$: segobjno 613, file1 block 4176 INDCOMPART$: segobjno 618, file1 block 4216 TABSUBPART$: segobjno 603, file1 block 4096 INDSUBPART$: segobjno 608, file1 block 4136 IND$: segobjno 2, tabno 3, file1 block 144 ICOL$: segobjno 2, tabno 4, file1 block 144 LOB$: segobjno 2, tabno 6, file1 block 144 COLTYPE$: segobjno 2, tabno 7, file1 block 144 TYPE$: segobjno 518, tabno 1, file1 block 3464 COLLECTION$: segobjno 518, tabno 2, file1 block 3464 ATTRIBUTE$: segobjno 518, tabno 3, file1 block 3464 LOBFRAG$: segobjno 624, file1 block 4264 LOBCOMPPART$: segobjno 627, file1 block 4288 UNDO$: segobjno 15, file1 block 224 TS$: segobjno 6, tabno 2, file1 block 176 PROPS$: segobjno 98, file1 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 setis ZHS16GBK Database national character setis AL16UTF16 DUL> |