最新版oracle dul工具----惜分飞

文章描述了使用OracleDataUnloader(DUL)工具的12.2.0.2.5版本进行数据库恢复的过程,包括初始化参数文件、显示数据文件信息以及遇到的警告,如无法打开参数文件,兼容性设置,以及在处理数据文件时遇到的软损坏块问题。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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>

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值