联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
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 open parameter file <init.dul> DUL: Warning: Compatible is set to 11 Values can be 6|7|8|9|10|11|12|17|18 DUL: Warning: no parameter file means 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 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$ 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 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 591, file 1 block 4000
INDPART$: segobjno 596, file 1 block 4040
TABCOMPART$: segobjno 613, file 1 block 4176
INDCOMPART$: segobjno 618, file 1 block 4216
TABSUBPART$: segobjno 603, file 1 block 4096
INDSUBPART$: segobjno 608, file 1 block 4136
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 518, tabno 1, file 1 block 3464
COLLECTION$: segobjno 518, tabno 2, file 1 block 3464
ATTRIBUTE$: segobjno 518, tabno 3, file 1 block 3464
LOBFRAG$: segobjno 624, file 1 block 4264
LOBCOMPPART$: segobjno 627, file 1 block 4288
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"
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 set is ZHS16GBK
Database national character set is AL16UTF16
DUL>