itspace
- 浏览: 978466 次
- 性别:
- 来自: 杭州
-
文章分类
最新评论
-
孤星119：
好熟悉的数据库字段啊， 上家公司做的项目每天都跟这些字段打招呼 ...
Oracle exp compress参数引起的空间浪费 -
itspace：
quxiaoyong 写道遇到个问题，网上一搜，全他妈这篇文章 ...
数据库连接错误ORA-28547 -
quxiaoyong：
遇到个问题，网上一搜，全他妈这篇文章。你转来转去的有意思吗？
数据库连接错误ORA-28547 -
hctech：
关于version count过高的问题，不知博主是否看过ey ...
某客户数据库性能诊断报告 -
itspace：
invalid 写道写的不错，我根据这个来安装，有点理解错误了 ...
AIX 配置vncserver
前几天碰到一客户，磁盘已格式化，拿到恢复数据公司几近折腾，终于将磁盘数据拿回，但数据文件均已损坏，所幸还有dmp备份，但如果没有任何备份，只能用上dul了，并祈祷自己运气不错，下面是dul的初步使用方法，环境为linux 4 32bit for oracle 9i。
在测试数据库中差得ts#，rfile#，用于创建control.txt
创建init.dul
创建control.txt
创建dul导出数据字典脚本
导出数据字典
进行数据字典导出，其过程会记录在dul.log中
在dul.log中某一表格的导出文件为：
将导出脚本取出，在dul中进行导出
导至Oracle 10g库中
可以看到数据已经导出，但字段表名均用代号显示，如果没有建表语句，那工作量就大了
在测试数据库中差得ts#，rfile#，用于创建control.txt
引用
SQL> col ts# for 9999
SQL> col rfile# for 999
SQL> set head off
SQL> set pagesize 0
SQL> select ts#, rfile#, name from v$datafile;
0 1 /oradata/ora9i/system01.dbf
1 2 /oradata/ora9i/undotbs01.dbf
3 3 /oradata/ora9i/cwmlite01.dbf
4 4 /oradata/ora9i/drsys01.dbf
5 5 /oradata/ora9i/example01.dbf
6 6 /oradata/ora9i/indx01.dbf
7 7 /oradata/ora9i/odm01.dbf
17 8 /oradata/ora9i/xup01.dbf
9 9 /oradata/ora9i/users01.dbf
10 10 /oradata/ora9i/xdb01.dbf
12 11 /oradata/ora9i/STREAM01.dbf
0 12 /oradata/ora9i/system02.dbf
18 14 /oradata/ora9i/xu2_01.dbf
SQL> col rfile# for 999
SQL> set head off
SQL> set pagesize 0
SQL> select ts#, rfile#, name from v$datafile;
0 1 /oradata/ora9i/system01.dbf
1 2 /oradata/ora9i/undotbs01.dbf
3 3 /oradata/ora9i/cwmlite01.dbf
4 4 /oradata/ora9i/drsys01.dbf
5 5 /oradata/ora9i/example01.dbf
6 6 /oradata/ora9i/indx01.dbf
7 7 /oradata/ora9i/odm01.dbf
17 8 /oradata/ora9i/xup01.dbf
9 9 /oradata/ora9i/users01.dbf
10 10 /oradata/ora9i/xdb01.dbf
12 11 /oradata/ora9i/STREAM01.dbf
0 12 /oradata/ora9i/system02.dbf
18 14 /oradata/ora9i/xu2_01.dbf
创建init.dul
引用
vi init.dul
osd_big_endian_flag=false
osd_dba_file_bits=10
osd_c_struct_alignment=32
osd_file_leader_size=1
osd_word_size = 32
dc_columns=2000000
dc_tables=10000
dc_objects=1000000
dc_users=400
dc_segments=100000
control_file = /oracle/control.txt
db_block_size=8192
export_mode=false
COMPATIBLE=9
LDR_PHYS_REC_SIZE =0
osd_big_endian_flag=false
osd_dba_file_bits=10
osd_c_struct_alignment=32
osd_file_leader_size=1
osd_word_size = 32
dc_columns=2000000
dc_tables=10000
dc_objects=1000000
dc_users=400
dc_segments=100000
control_file = /oracle/control.txt
db_block_size=8192
export_mode=false
COMPATIBLE=9
LDR_PHYS_REC_SIZE =0
创建control.txt
引用
[oracle@mcprod oracle]$ vi control.txt
0 1 /oradata/ora9i/system01.dbf
1 2 /oradata/ora9i/undotbs01.dbf
3 3 /oradata/ora9i/cwmlite01.dbf
4 4 /oradata/ora9i/drsys01.dbf
5 5 /oradata/ora9i/example01.dbf
6 6 /oradata/ora9i/indx01.dbf
7 7 /oradata/ora9i/odm01.dbf
17 8 /oradata/ora9i/xup01.dbf
9 9 /oradata/ora9i/users01.dbf
10 10 /oradata/ora9i/xdb01.dbf
12 11 /oradata/ora9i/STREAM01.dbf
0 12 /oradata/ora9i/system02.dbf
18 14 /oradata/ora9i/xu2_01.dbf
0 1 /oradata/ora9i/system01.dbf
1 2 /oradata/ora9i/undotbs01.dbf
3 3 /oradata/ora9i/cwmlite01.dbf
4 4 /oradata/ora9i/drsys01.dbf
5 5 /oradata/ora9i/example01.dbf
6 6 /oradata/ora9i/indx01.dbf
7 7 /oradata/ora9i/odm01.dbf
17 8 /oradata/ora9i/xup01.dbf
9 9 /oradata/ora9i/users01.dbf
10 10 /oradata/ora9i/xdb01.dbf
12 11 /oradata/ora9i/STREAM01.dbf
0 12 /oradata/ora9i/system02.dbf
18 14 /oradata/ora9i/xu2_01.dbf
创建dul导出数据字典脚本
引用
[oracle@mcprod oracle]$vi dictv8.ddl
REM DDL Script to unload the dictionary cache for DUL8 (Oracle8)
REM force the settings, so I know what happens
alter session set export_mode = false;
alter session set ldr_phys_rec_size = 0;
alter session set ldr_enclose_char = """" ;
alter session set file = "" ;
unload table OBJ$ ( OBJ# number, DATAOBJ# ignore, OWNER# number,
NAME varchar2(30), NAMESPACE ignore, SUBNAME varchar2(30), TYPE# number)
storage( segobjno 18 file 1);
unload table TAB$( OBJ# number, DATAOBJ# number,
TS# number, FILE# number, BLOCK# number,
BOBJ# number, TAB# number, COLS number, CLUCOLS number,
pctfree$ ignore, pctused$ ignore, initrans ignore, maxtrans ignore,
flags ignore, audit$ ignore, rowcnt ignore, blkcnt ignore,
empcnt ignore, avgspc ignore, chncnt ignore, avgrln ignore,
avgspc_flb ignore, flbcnt ignore,
analyzetime ignore, samplesize ignore,
degree ignore, instances ignore,
intcols ignore, kernelcols ignore, property number)
cluster C_OBJ#(OBJ#)
storage ( tabno 1 segobjno 2 file 1)
;
unload table COL$ ( OBJ# number, COL# number , SEGCOL# number,
SEGCOLLENGTH ignore, OFFSET ignore, NAME char(30),
TYPE# number, LENGTH number, FIXEDSTORAGE ignore,
PRECISION# ignore, SCALE ignore, NULL$ ignore, DEFLENGTH ignore,
DEFAULT$ ignore, INTCOL# number, PROPERTY number)
cluster C_OBJ#(OBJ#)
storage( tabno 5 segobjno 2 file 1)
;
unload table USER$( USER# number, NAME varchar2(30))
cluster C_USER#(USER#)
storage(tabno 1 segobjno 10 file 1)
;
ECHO exit and restart DUL to load the first four dictionary tables in the cache
ECHO OPTIONALLY for partitioned tables, indexes or lobs or for MIGRATED
ECHO use bootstrap procedure
ECHO for full bootstrap start with the following commands:
ECHO scan database;
ECHO bootstrap; (and follow the instructions)
REM DDL Script to unload the dictionary cache for DUL8 (Oracle8)
REM force the settings, so I know what happens
alter session set export_mode = false;
alter session set ldr_phys_rec_size = 0;
alter session set ldr_enclose_char = """" ;
alter session set file = "" ;
unload table OBJ$ ( OBJ# number, DATAOBJ# ignore, OWNER# number,
NAME varchar2(30), NAMESPACE ignore, SUBNAME varchar2(30), TYPE# number)
storage( segobjno 18 file 1);
unload table TAB$( OBJ# number, DATAOBJ# number,
TS# number, FILE# number, BLOCK# number,
BOBJ# number, TAB# number, COLS number, CLUCOLS number,
pctfree$ ignore, pctused$ ignore, initrans ignore, maxtrans ignore,
flags ignore, audit$ ignore, rowcnt ignore, blkcnt ignore,
empcnt ignore, avgspc ignore, chncnt ignore, avgrln ignore,
avgspc_flb ignore, flbcnt ignore,
analyzetime ignore, samplesize ignore,
degree ignore, instances ignore,
intcols ignore, kernelcols ignore, property number)
cluster C_OBJ#(OBJ#)
storage ( tabno 1 segobjno 2 file 1)
;
unload table COL$ ( OBJ# number, COL# number , SEGCOL# number,
SEGCOLLENGTH ignore, OFFSET ignore, NAME char(30),
TYPE# number, LENGTH number, FIXEDSTORAGE ignore,
PRECISION# ignore, SCALE ignore, NULL$ ignore, DEFLENGTH ignore,
DEFAULT$ ignore, INTCOL# number, PROPERTY number)
cluster C_OBJ#(OBJ#)
storage( tabno 5 segobjno 2 file 1)
;
unload table USER$( USER# number, NAME varchar2(30))
cluster C_USER#(USER#)
storage(tabno 1 segobjno 10 file 1)
;
ECHO exit and restart DUL to load the first four dictionary tables in the cache
ECHO OPTIONALLY for partitioned tables, indexes or lobs or for MIGRATED
ECHO use bootstrap procedure
ECHO for full bootstrap start with the following commands:
ECHO scan database;
ECHO bootstrap; (and follow the instructions)
导出数据字典
引用
[oracle@mcprod oracle]$ ./dul dictv8.ddl
Data UnLoader 9.2.4.1 - Internal Use Only - on Wed Oct 13 07:58:22 2010
with 64-bit io functions
Copyright (c) 1994 2003 Bernard van Duijnen All rights reserved.
DUL: Warning: Recreating file "dul.log"
Parameter altered
Parameter altered
Parameter altered
Parameter altered
. unloading table OBJ$ 32266 rows unloaded
. unloading table TAB$ 1074 rows unloaded
. unloading table COL$ 38658 rows unloaded
. unloading table USER$ 80 rows unloaded
exit and restart DUL to load the first four dictionary tables in the cache
OPTIONALLY for partitioned tables, indexes or lobs or for MIGRATED
use bootstrap procedure
for full bootstrap start with the following commands:
scan database;
bootstrap; (and follow the instructions)
Data UnLoader 9.2.4.1 - Internal Use Only - on Wed Oct 13 07:58:22 2010
with 64-bit io functions
Copyright (c) 1994 2003 Bernard van Duijnen All rights reserved.
DUL: Warning: Recreating file "dul.log"
Parameter altered
Parameter altered
Parameter altered
Parameter altered
. unloading table OBJ$ 32266 rows unloaded
. unloading table TAB$ 1074 rows unloaded
. unloading table COL$ 38658 rows unloaded
. unloading table USER$ 80 rows unloaded
exit and restart DUL to load the first four dictionary tables in the cache
OPTIONALLY for partitioned tables, indexes or lobs or for MIGRATED
use bootstrap procedure
for full bootstrap start with the following commands:
scan database;
bootstrap; (and follow the instructions)
进行数据字典导出，其过程会记录在dul.log中
引用
[oracle@mcprod oracle]$ ./dul
Data UnLoader 9.2.4.1 - Internal Use Only - on Wed Oct 13 08:01:04 2010
with 64-bit io functions
Copyright (c) 1994 2003 Bernard van Duijnen All rights reserved.
DUL: Warning: Recreating file "dul.log"
Reading USER.dat 80 entries loaded
Reading OBJ.dat
DUL: Error: File OBJ.dat, line 1: token missing
DUL: Warning: Ignoring file OBJ.dat cache
Reading TAB.dat 1074 entries loaded
Reading COL.dat 38658 entries loaded
DUL> scan database;
tablespace 0, data file 1: 153599 blocks scanned
tablespace 1, data file 2: 25599 blocks scanned
tablespace 3, data file 3: 2559 blocks scanned
tablespace 4, data file 4: 2559 blocks scanned
tablespace 5, data file 5: 19039 blocks scanned
tablespace 6, data file 6: 3199 blocks scanned
tablespace 7, data file 7: 2559 blocks scanned
tablespace 17, data file 8: 12799 blocks scanned
tablespace 9, data file 9: 39519 blocks scanned
tablespace 10, data file 10: 5759 blocks scanned
tablespace 12, data file 11: 12799 blocks scanned
tablespace 0, data file 12: 69887 blocks scanned
tablespace 18, data file 14: 12799 blocks scanned
Reading EXT.dat 4183 entries loaded and sorted
Reading SEG.dat 3089 entries loaded
Reading COMPATSEG.dat 1 entries loaded
DUL> bootstrap;
Compatibility segment found at file = 1, block = 417
database version 9 bootstrap$ at file 1, block 377
. unloading table BOOTSTRAP$ 57 rows unloaded
Reading BOOTSTRAP.dat 57 entries loaded
Parsing Bootstrap$ contents
Generating dict.ddl for version 9
OBJ$: segobjno 18, file 1
TAB$: segobjno 2, tabno 1, file 1
COL$: segobjno 2, tabno 5, file 1
USER$: segobjno 10, tabno 1, file 1
Running generated file "@dict.ddl" to unload the dictionary tables
. unloading table OBJ$
DUL: Warning: Recreating file "OBJ.ctl"
32266 rows unloaded
. unloading table TAB$
DUL: Warning: Recreating file "TAB.ctl"
1074 rows unloaded
. unloading table COL$
DUL: Warning: Recreating file "COL.ctl"
38658 rows unloaded
. unloading table USER$
DUL: Warning: Recreating file "USER.ctl"
80 rows unloaded
Reading USER.dat 80 entries loaded
Reading OBJ.dat 32266 entries loaded
Reading TAB.dat 1074 entries loaded
Reading COL.dat 38658 entries loaded
Reading SEG.dat 3089 entries loaded
Reading EXT.dat 4183 entries loaded and sorted
Reading COMPATSEG.dat 1 entries loaded
Reading BOOTSTRAP.dat 57 entries loaded
DUL: Warning: Recreating file "dict.ddl"
Generating dict.ddl for version 9
OBJ$: segobjno 18, file 1
TAB$: segobjno 2, tabno 1, file 1
COL$: segobjno 2, tabno 5, file 1
USER$: segobjno 10, tabno 1, file 1
TABPART$: segobjno 230, file 1
INDPART$: segobjno 234, file 1
TABCOMPART$: segobjno 249, file 1
INDCOMPART$: segobjno 253, file 1
TABSUBPART$: segobjno 240, file 1
INDSUBPART$: segobjno 245, file 1
IND$: segobjno 2, tabno 3, file 1
ICOL$: segobjno 2, tabno 4, file 1
LOB$: segobjno 2, tabno 6, file 1
Running generated file "@dict.ddl" to unload the dictionary tables
. unloading table OBJ$
DUL: Warning: Recreating file "OBJ.ctl"
32266 rows unloaded
. unloading table TAB$
DUL: Warning: Recreating file "TAB.ctl"
1074 rows unloaded
. unloading table COL$
DUL: Warning: Recreating file "COL.ctl"
38658 rows unloaded
. unloading table USER$
DUL: Warning: Recreating file "USER.ctl"
80 rows unloaded
. unloading table TABPART$ 157 rows unloaded
. unloading table INDPART$ 202 rows unloaded
. unloading table TABCOMPART$ 0 rows unloaded
. unloading table INDCOMPART$ 0 rows unloaded
. unloading table TABSUBPART$ 0 rows unloaded
. unloading table INDSUBPART$ 0 rows unloaded
. unloading table IND$ 1510 rows unloaded
. unloading table ICOL$ 2147 rows unloaded
. unloading table LOB$ 432 rows unloaded
Reading USER.dat 80 entries loaded
Reading OBJ.dat 32266 entries loaded
Reading TAB.dat 1074 entries loaded
Reading COL.dat 38658 entries loaded
Reading SEG.dat 3089 entries loaded
Reading EXT.dat 4183 entries loaded and sorted
Reading TABPART.dat 157 entries loaded and sorted
Reading TABCOMPART.dat 0 entries loaded and sorted
Reading TABSUBPART.dat 0 entries loaded and sorted
Reading INDPART.dat 202 entries loaded and sorted
Reading INDCOMPART.dat 0 entries loaded and sorted
Reading INDSUBPART.dat 0 entries loaded and sorted
Reading IND.dat 1510 entries loaded
Reading LOB.dat 432 entries loaded
Reading ICOL.dat 2147 entries loaded
Reading COMPATSEG.dat 1 entries loaded
Reading BOOTSTRAP.dat 57 entries loaded
DUL>SCAN TABLES;
Data UnLoader 9.2.4.1 - Internal Use Only - on Wed Oct 13 08:01:04 2010
with 64-bit io functions
Copyright (c) 1994 2003 Bernard van Duijnen All rights reserved.
DUL: Warning: Recreating file "dul.log"
Reading USER.dat 80 entries loaded
Reading OBJ.dat
DUL: Error: File OBJ.dat, line 1: token missing
DUL: Warning: Ignoring file OBJ.dat cache
Reading TAB.dat 1074 entries loaded
Reading COL.dat 38658 entries loaded
DUL> scan database;
tablespace 0, data file 1: 153599 blocks scanned
tablespace 1, data file 2: 25599 blocks scanned
tablespace 3, data file 3: 2559 blocks scanned
tablespace 4, data file 4: 2559 blocks scanned
tablespace 5, data file 5: 19039 blocks scanned
tablespace 6, data file 6: 3199 blocks scanned
tablespace 7, data file 7: 2559 blocks scanned
tablespace 17, data file 8: 12799 blocks scanned
tablespace 9, data file 9: 39519 blocks scanned
tablespace 10, data file 10: 5759 blocks scanned
tablespace 12, data file 11: 12799 blocks scanned
tablespace 0, data file 12: 69887 blocks scanned
tablespace 18, data file 14: 12799 blocks scanned
Reading EXT.dat 4183 entries loaded and sorted
Reading SEG.dat 3089 entries loaded
Reading COMPATSEG.dat 1 entries loaded
DUL> bootstrap;
Compatibility segment found at file = 1, block = 417
database version 9 bootstrap$ at file 1, block 377
. unloading table BOOTSTRAP$ 57 rows unloaded
Reading BOOTSTRAP.dat 57 entries loaded
Parsing Bootstrap$ contents
Generating dict.ddl for version 9
OBJ$: segobjno 18, file 1
TAB$: segobjno 2, tabno 1, file 1
COL$: segobjno 2, tabno 5, file 1
USER$: segobjno 10, tabno 1, file 1
Running generated file "@dict.ddl" to unload the dictionary tables
. unloading table OBJ$
DUL: Warning: Recreating file "OBJ.ctl"
32266 rows unloaded
. unloading table TAB$
DUL: Warning: Recreating file "TAB.ctl"
1074 rows unloaded
. unloading table COL$
DUL: Warning: Recreating file "COL.ctl"
38658 rows unloaded
. unloading table USER$
DUL: Warning: Recreating file "USER.ctl"
80 rows unloaded
Reading USER.dat 80 entries loaded
Reading OBJ.dat 32266 entries loaded
Reading TAB.dat 1074 entries loaded
Reading COL.dat 38658 entries loaded
Reading SEG.dat 3089 entries loaded
Reading EXT.dat 4183 entries loaded and sorted
Reading COMPATSEG.dat 1 entries loaded
Reading BOOTSTRAP.dat 57 entries loaded
DUL: Warning: Recreating file "dict.ddl"
Generating dict.ddl for version 9
OBJ$: segobjno 18, file 1
TAB$: segobjno 2, tabno 1, file 1
COL$: segobjno 2, tabno 5, file 1
USER$: segobjno 10, tabno 1, file 1
TABPART$: segobjno 230, file 1
INDPART$: segobjno 234, file 1
TABCOMPART$: segobjno 249, file 1
INDCOMPART$: segobjno 253, file 1
TABSUBPART$: segobjno 240, file 1
INDSUBPART$: segobjno 245, file 1
IND$: segobjno 2, tabno 3, file 1
ICOL$: segobjno 2, tabno 4, file 1
LOB$: segobjno 2, tabno 6, file 1
Running generated file "@dict.ddl" to unload the dictionary tables
. unloading table OBJ$
DUL: Warning: Recreating file "OBJ.ctl"
32266 rows unloaded
. unloading table TAB$
DUL: Warning: Recreating file "TAB.ctl"
1074 rows unloaded
. unloading table COL$
DUL: Warning: Recreating file "COL.ctl"
38658 rows unloaded
. unloading table USER$
DUL: Warning: Recreating file "USER.ctl"
80 rows unloaded
. unloading table TABPART$ 157 rows unloaded
. unloading table INDPART$ 202 rows unloaded
. unloading table TABCOMPART$ 0 rows unloaded
. unloading table INDCOMPART$ 0 rows unloaded
. unloading table TABSUBPART$ 0 rows unloaded
. unloading table INDSUBPART$ 0 rows unloaded
. unloading table IND$ 1510 rows unloaded
. unloading table ICOL$ 2147 rows unloaded
. unloading table LOB$ 432 rows unloaded
Reading USER.dat 80 entries loaded
Reading OBJ.dat 32266 entries loaded
Reading TAB.dat 1074 entries loaded
Reading COL.dat 38658 entries loaded
Reading SEG.dat 3089 entries loaded
Reading EXT.dat 4183 entries loaded and sorted
Reading TABPART.dat 157 entries loaded and sorted
Reading TABCOMPART.dat 0 entries loaded and sorted
Reading TABSUBPART.dat 0 entries loaded and sorted
Reading INDPART.dat 202 entries loaded and sorted
Reading INDCOMPART.dat 0 entries loaded and sorted
Reading INDSUBPART.dat 0 entries loaded and sorted
Reading IND.dat 1510 entries loaded
Reading LOB.dat 432 entries loaded
Reading ICOL.dat 2147 entries loaded
Reading COMPATSEG.dat 1 entries loaded
Reading BOOTSTRAP.dat 57 entries loaded
DUL>SCAN TABLES;
在dul.log中某一表格的导出文件为：
引用
Analyzing segment: data object id=37981 segment header at ( file=14 block=6041)
heap organized table
This is probably XU2.D21
DUL: Warning: Column 1: type based on heuristic guessing
DUL: Warning: Column 8: type based on heuristic guessing
DUL: Warning: Column 9: type based on heuristic guessing
DUL: Warning: Column 10: type based on heuristic guessing
DUL: Warning: Column 14: type based on heuristic guessing
DUL: Warning: Column 18: type based on heuristic guessing
DUL: Warning: Column 22: type based on heuristic guessing
DUL: Warning: Column 24: type based on heuristic guessing
DUL: Warning: Column 26: type based on heuristic guessing
Col Seen Max PCT PRINT NUMBERS DATES TIMESTAMP WITH TZ INTRVAL ROWIDS LOB
no count Size NUL 75%100% AnyNice AnyNice AnyNice AnyNice Y2M D2S AnyNice
1 1 6 0 0 0 100 100 0 0 0 0 0 0 0 0 100 0 0
2 1 5 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
3 1 7 0 0 0 0 0 100 100 0 0 0 0 0 0 0 0 0
4 1 5 0 0 0 100 100 0 0 0 0 0 0 0 0 0 0 0
5 1 7 0 0 0 0 0 100 100 0 0 0 0 0 0 0 0 0
6 1 4 0 0 0 100 100 0 0 0 0 0 0 0 0 0 0 0
7 1 7 0 0 0 0 0 100 100 0 0 0 0 0 0 0 0 0
8 1 10 0 100 100 0 0 0 0 0 0 0 0 0 0 100 0 0
9 1 8 0 0 0 100 100 0 0 0 0 0 0 0 0 100 0 0
10 1 8 0 0 0 100 100 0 0 0 0 0 0 0 0 100 0 0
11 1 7 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
12 1 7 0 0 0 0 0 100 100 0 0 0 0 0 0 0 0 0
13 1 4 0 0 0 100 100 0 0 0 0 0 0 0 0 0 0 0
14 1 8 0 0 0 100 100 0 0 0 0 0 0 0 0 100 0 0
15 1 7 0 0 0 0 0 100 100 0 0 0 0 0 0 0 0 0
16 1 11 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
17 1 7 0 0 0 0 0 100 100 0 0 0 0 0 0 0 0 0
18 1 10 0 100 100 0 0 0 0 0 0 0 0 0 0 100 0 0
19 1 19 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
20 1 19 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
21 1 7 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
22 1 6 0 0 0 100 100 0 0 0 0 0 0 0 0 100 0 0
23 1 7 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
24 1 8 0 0 0 100 100 0 0 0 0 0 0 0 0 100 0 0
25 1 15 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
26 1 8 0 100 100 0 0 0 0 0 0 0 0 0 0 100 0 0
27 1 4 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
28 1 2 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
29 1 2 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
30 1 2 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
31 1 2 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
"2494723682" "ORA9I" "17-AUG-2009 AD 04:48:34" "36030548" "12-APR-2010 AD 08:31:11" "174968" "17-AUG-2009 AD 04:48:35" "ARCHIVELOG" "10783291662686" "10783291662683" "CURRENT" "17-AUG-2009 AD 04:48:35" "45745" "10783291662686" "26-JUL-2010 AD 11:42:56" "NOT ALLOWED" "26-JUL-2010 AD 07:36:03" "READ WRITE" "MAXIMUM PERFORMANCE" "MAXIMUM PERFORMANCE" "ENABLED" "2524999166" "PRIMARY" "10783291662686" "SESSIONS ACTIVE" "DISABLED" "NONE" "NO" "NO" "NO" "NO"
UNLOAD TABLE OBJNO37981 ( COL001 NUMBER, COL002 CHAR(5), COL003 DATE
, COL004 NUMBER, COL005 DATE, COL006 NUMBER, COL007 DATE
, COL008 CHAR(10), COL009 NUMBER, COL010 NUMBER, COL011 CHAR(7)
, COL012 DATE, COL013 NUMBER, COL014 NUMBER, COL015 DATE
, COL016 CHAR(11), COL017 DATE, COL018 CHAR(10), COL019 CHAR(19)
, COL020 CHAR(19), COL021 CHAR(7), COL022 NUMBER, COL023 CHAR(7)
, COL024 NUMBER, COL025 CHAR(15), COL026 CHAR(8), COL027 CHAR(4)
, COL028 CHAR(2), COL029 CHAR(2), COL030 CHAR(2), COL031 CHAR(2) )
STORAGE( DATAOBJNO 37981 );
heap organized table
This is probably XU2.D21
DUL: Warning: Column 1: type based on heuristic guessing
DUL: Warning: Column 8: type based on heuristic guessing
DUL: Warning: Column 9: type based on heuristic guessing
DUL: Warning: Column 10: type based on heuristic guessing
DUL: Warning: Column 14: type based on heuristic guessing
DUL: Warning: Column 18: type based on heuristic guessing
DUL: Warning: Column 22: type based on heuristic guessing
DUL: Warning: Column 24: type based on heuristic guessing
DUL: Warning: Column 26: type based on heuristic guessing
Col Seen Max PCT PRINT NUMBERS DATES TIMESTAMP WITH TZ INTRVAL ROWIDS LOB
no count Size NUL 75%100% AnyNice AnyNice AnyNice AnyNice Y2M D2S AnyNice
1 1 6 0 0 0 100 100 0 0 0 0 0 0 0 0 100 0 0
2 1 5 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
3 1 7 0 0 0 0 0 100 100 0 0 0 0 0 0 0 0 0
4 1 5 0 0 0 100 100 0 0 0 0 0 0 0 0 0 0 0
5 1 7 0 0 0 0 0 100 100 0 0 0 0 0 0 0 0 0
6 1 4 0 0 0 100 100 0 0 0 0 0 0 0 0 0 0 0
7 1 7 0 0 0 0 0 100 100 0 0 0 0 0 0 0 0 0
8 1 10 0 100 100 0 0 0 0 0 0 0 0 0 0 100 0 0
9 1 8 0 0 0 100 100 0 0 0 0 0 0 0 0 100 0 0
10 1 8 0 0 0 100 100 0 0 0 0 0 0 0 0 100 0 0
11 1 7 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
12 1 7 0 0 0 0 0 100 100 0 0 0 0 0 0 0 0 0
13 1 4 0 0 0 100 100 0 0 0 0 0 0 0 0 0 0 0
14 1 8 0 0 0 100 100 0 0 0 0 0 0 0 0 100 0 0
15 1 7 0 0 0 0 0 100 100 0 0 0 0 0 0 0 0 0
16 1 11 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
17 1 7 0 0 0 0 0 100 100 0 0 0 0 0 0 0 0 0
18 1 10 0 100 100 0 0 0 0 0 0 0 0 0 0 100 0 0
19 1 19 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
20 1 19 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
21 1 7 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
22 1 6 0 0 0 100 100 0 0 0 0 0 0 0 0 100 0 0
23 1 7 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
24 1 8 0 0 0 100 100 0 0 0 0 0 0 0 0 100 0 0
25 1 15 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
26 1 8 0 100 100 0 0 0 0 0 0 0 0 0 0 100 0 0
27 1 4 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
28 1 2 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
29 1 2 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
30 1 2 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
31 1 2 0 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0
"2494723682" "ORA9I" "17-AUG-2009 AD 04:48:34" "36030548" "12-APR-2010 AD 08:31:11" "174968" "17-AUG-2009 AD 04:48:35" "ARCHIVELOG" "10783291662686" "10783291662683" "CURRENT" "17-AUG-2009 AD 04:48:35" "45745" "10783291662686" "26-JUL-2010 AD 11:42:56" "NOT ALLOWED" "26-JUL-2010 AD 07:36:03" "READ WRITE" "MAXIMUM PERFORMANCE" "MAXIMUM PERFORMANCE" "ENABLED" "2524999166" "PRIMARY" "10783291662686" "SESSIONS ACTIVE" "DISABLED" "NONE" "NO" "NO" "NO" "NO"
UNLOAD TABLE OBJNO37981 ( COL001 NUMBER, COL002 CHAR(5), COL003 DATE
, COL004 NUMBER, COL005 DATE, COL006 NUMBER, COL007 DATE
, COL008 CHAR(10), COL009 NUMBER, COL010 NUMBER, COL011 CHAR(7)
, COL012 DATE, COL013 NUMBER, COL014 NUMBER, COL015 DATE
, COL016 CHAR(11), COL017 DATE, COL018 CHAR(10), COL019 CHAR(19)
, COL020 CHAR(19), COL021 CHAR(7), COL022 NUMBER, COL023 CHAR(7)
, COL024 NUMBER, COL025 CHAR(15), COL026 CHAR(8), COL027 CHAR(4)
, COL028 CHAR(2), COL029 CHAR(2), COL030 CHAR(2), COL031 CHAR(2) )
STORAGE( DATAOBJNO 37981 );
将导出脚本取出，在dul中进行导出
引用
DUL> UNLOAD TABLE OBJNO37981 ( COL001 NUMBER, COL002 CHAR(5), COL003 DATE
2 , COL004 NUMBER, COL005 DATE, COL006 NUMBER, COL007 DATE
3 , COL008 CHAR(10), COL009 NUMBER, COL010 NUMBER, COL011 CHAR(7)
4 , COL012 DATE, COL013 NUMBER, COL014 NUMBER, COL015 DATE
5 , COL016 CHAR(11), COL017 DATE, COL018 CHAR(10), COL019 CHAR(19)
6 , COL020 CHAR(19), COL021 CHAR(7), COL022 NUMBER, COL023 CHAR(7)
7 , COL024 NUMBER, COL025 CHAR(15), COL026 CHAR(8), COL027 CHAR(4)
8 , COL028 CHAR(2), COL029 CHAR(2), COL030 CHAR(2), COL031 CHAR(2) )
9 STORAGE( DATAOBJNO 37981 );
. unloading table OBJNO37981 1 row unloaded
2 , COL004 NUMBER, COL005 DATE, COL006 NUMBER, COL007 DATE
3 , COL008 CHAR(10), COL009 NUMBER, COL010 NUMBER, COL011 CHAR(7)
4 , COL012 DATE, COL013 NUMBER, COL014 NUMBER, COL015 DATE
5 , COL016 CHAR(11), COL017 DATE, COL018 CHAR(10), COL019 CHAR(19)
6 , COL020 CHAR(19), COL021 CHAR(7), COL022 NUMBER, COL023 CHAR(7)
7 , COL024 NUMBER, COL025 CHAR(15), COL026 CHAR(8), COL027 CHAR(4)
8 , COL028 CHAR(2), COL029 CHAR(2), COL030 CHAR(2), COL031 CHAR(2) )
9 STORAGE( DATAOBJNO 37981 );
. unloading table OBJNO37981 1 row unloaded
导至Oracle 10g库中
引用
[ora10g@mcprod oracle]$ imp \"sys/oracle as sysdba\" file=OBJNO37981.dmp full=y
Import: Release 10.2.0.3.0 - Production on Wed Oct 13 08:27:33 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V07.00.07 via conventional path
Warning: the objects were exported by Bernard's DUL, not by you
. importing Bernard's DUL's objects into SYS
. importing Bernard's DUL's objects into SYS
. . importing table "OBJNO37981" 1 rows imported
Import terminated successfully without warnings.
Import: Release 10.2.0.3.0 - Production on Wed Oct 13 08:27:33 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V07.00.07 via conventional path
Warning: the objects were exported by Bernard's DUL, not by you
. importing Bernard's DUL's objects into SYS
. importing Bernard's DUL's objects into SYS
. . importing table "OBJNO37981" 1 rows imported
Import terminated successfully without warnings.
可以看到数据已经导出，但字段表名均用代号显示，如果没有建表语句，那工作量就大了
引用
SQL> desc OBJNO37981
Name Null? Type
----------------------------------------- -------- ----------------------------
COL001 NUMBER
COL002 CHAR(5)
COL003 DATE
COL004 NUMBER
COL005 DATE
COL006 NUMBER
COL007 DATE
COL008 CHAR(10)
COL009 NUMBER
COL010 NUMBER
COL011 CHAR(7)
COL012 DATE
COL013 NUMBER
COL014 NUMBER
COL015 DATE
COL016 CHAR(11)
COL017 DATE
COL018 CHAR(10)
COL019 CHAR(19)
COL020 CHAR(19)
COL021 CHAR(7)
COL022 NUMBER
COL023 CHAR(7)
COL024 NUMBER
COL025 CHAR(15)
COL026 CHAR(8)
COL027 CHAR(4)
COL028 CHAR(2)
COL029 CHAR(2)
COL030 CHAR(2)
COL031 CHAR(2)
SQL> select count(*) from OBJNO37981;
COUNT(*)
----------
1
Name Null? Type
----------------------------------------- -------- ----------------------------
COL001 NUMBER
COL002 CHAR(5)
COL003 DATE
COL004 NUMBER
COL005 DATE
COL006 NUMBER
COL007 DATE
COL008 CHAR(10)
COL009 NUMBER
COL010 NUMBER
COL011 CHAR(7)
COL012 DATE
COL013 NUMBER
COL014 NUMBER
COL015 DATE
COL016 CHAR(11)
COL017 DATE
COL018 CHAR(10)
COL019 CHAR(19)
COL020 CHAR(19)
COL021 CHAR(7)
COL022 NUMBER
COL023 CHAR(7)
COL024 NUMBER
COL025 CHAR(15)
COL026 CHAR(8)
COL027 CHAR(4)
COL028 CHAR(2)
COL029 CHAR(2)
COL030 CHAR(2)
COL031 CHAR(2)
SQL> select count(*) from OBJNO37981;
COUNT(*)
----------
1
分享到：
发表评论
-
buffer cache 的内部结构
2020-03-18 14:21 576BUFFER CACHE作为数据块的 ... -
Oracle OMC介绍
2020-03-18 13:19 484Oracle管理云服务（OMC）的大数据平台，自动收集的企业 ... -
参加Oracle勒索病毒防范专题培训会议
2019-09-27 17:15 5112019年7月22日，受邀参加Oracle勒索病毒防范专题培训 ... -
记一次内存换IO的Oracle优化
2019-09-27 16:50 826某客户数据库从P595物理 ... -
如何定位Oracle SQL执行计划变化的原因
2019-07-03 14:49 1458性能优化最难的是能够 ... -
如何定位Oracle SQL执行计划变化的原因
2018-10-30 09:24 1185性能优化最难的是能够 ... -
数据库性能优化目标
2018-10-08 10:59 518从数据库性能优化的场 ... -
数据库无法打开的原因及解决办法
2018-10-05 20:45 2117数据库的启动是一个相当复杂的过程。比如，Oracle在启动之前 ... -
怎么样彻底删除数据库？
2018-09-18 11:10 598Oracle提供了drop database命令用来删除数据库 ... -
Oracle减少日志量的方法
2018-09-10 10:17 865LGWR进程将LOG BUFFER中的 ... -
如何快速关闭数据库
2018-09-09 13:14 1231“一朝被蛇咬，十年怕井绳”。在没被“蛇”咬之前，很多DBA喜欢 ... -
关于《如何落地智能化运维》PPT
2018-05-17 10:19 1128在DTCC 2018发表《如何落地智能化运维》演讲，主要内容如 ... -
记录在redhat5.8平台安装oracle11.2容易忽视的几个问题
2018-05-11 19:58 577问题一：ping不通问题 在虚拟机上安装好linux系统后， ... -
《Oracle DBA实战攻略》第一章
2018-05-11 10:42 945即日起，不定期更新《OracleDBA实战攻略》一书电子版，请 ... -
Oracle 12c新特性
2018-05-11 10:33 898查询所有pdb [oracle@gj4 ~]$ sqlplu ... -
关于修改memory_target的值后数据库无法启动的问题
2017-02-28 12:24 3981操作系统：RHEL6.5 数据库版本：11.2.0.4 ... -
10g rac安装error while loading shared libraries libpthread.so.0 问题
2017-02-28 12:22 69311g rac安装在二节点跑脚本一般会报此错误： 解决这个问 ... -
记一次Oracle会话共享模式故障处理过程
2017-02-27 19:16 798故障简述 XXX第八人民医院HIS数据库7月13日11点左右从 ... -
RESMGR:cpu quantum等待事件处理过程
2017-02-27 18:23 2615由于数据库上线过程中出现大量的RESMGR:cpu quant ... -
谈谈log file sync
2014-03-19 14:18 1757数据库中的log file sync等待事件指的是，当user ...
相关推荐
Oracle数据库是全球广泛使用的大型企业级关系型数据库管理系统，它在数据存储、处理和管理方面具有高度的稳定性和可靠性。然而，数据丢失或系统故障在所难免，这就需要强大的恢复工具来确保数据的安全。"Oracle恢复...
同时也有单库超过10TB的使用例子，这得益于PRM-DUL 内置了小型嵌入式数据库，当索要恢复的ORACLE数据库很大时，PRM-DUL采用嵌入的数据库来存放找到的ORACLE 源数据，这样可以对源数据做索引和灵活的查询。...
Oracle DUL，全称为Data Recovery Utility，是Oracle数据库系统中的一款强大的数据恢复工具。它主要用于处理数据库的物理层恢复，特别是在遇到数据文件损坏、误删除或其他严重问题时，DUL能够帮助数据库管理员进行...
Oracle DUL全称Oracle Data Unloader，泛指作为Oracle数据库文件的数据导出工具，可以在Oracle数据库无法正常启动的情况下对数据文件进行扫描和数据导出。 除了Oracle内部使用服务程序外，市面上还有可选择的第三方...
Oracle DUL的使用不仅需要对Oracle数据库的内部结构有深入理解，还需要熟悉其数据存储和恢复的原理。源码的公开使得技术爱好者和专业人士有机会研究Oracle的数据恢复机制，提升故障排查和数据安全能力。同时，这也为...
本文将详细介绍Oracle DUL工具的使用方法、操作步骤，并结合相关资源进行探讨。 首先，Oracle DUL工具的核心功能在于其对数据库的直接访问能力，它能够绕过Oracle的SQL接口，直接读取和修改数据文件，从而在不启动...
PRM-DUL Oracle数据库恢复工具（简称PRM-DUL）是一款专为Oracle数据救援而研发的企业级工具。可在多个操作平台（AIX/HPUX/SOLARIS/Linux/Windows）使用并支持对Oracle 9i/10g/11g/12c各版本数据库的数据救援工作。...
PRM可以再无备份的情况下恢复被truncated掉的表，也可以恢复无法打开的Oracle数据库(Alter database open... PRM是图形化增强版的Oracle DUL工具，同时具备很多Oracle DUL不具备的特性。 而且PRM无需学任何新命令。
Oracle Data Unloader（DUL）是Oracle数据库管理工具的一个组件，用于高效地导出大量数据。这个源代码可能包含了用于批量卸载Oracle数据库表数据到文件的程序逻辑。OracleBlock.java很可能是源代码中的关键部分，它...
然而DUL并非一个商业工具，这个工具仅在Oracle内部流通，但是逐渐的，DUL也开始流入民间，被一些资深Oracle工程师所使用。 随着数据库版本的变化，DUL工具也在逐渐升级之中，对应Oracle8 / Oracle8i / Oracle9i / ...
Oracle DUL工具，全称Data Utility for Oracle，是Oracle数据库恢复领域的一款重要工具，尤其在数据丢失或遇到坏块问题，且没有可用备份时，它成为拯救数据的最后防线。这款工具适用于Oracle数据库的8i和9i版本，...
本文主要涉及的是Oracle数据库的灾难恢复（DUL，Database Utility Library）和高可用性集群管理软件HACMP（High Availability Cluster Multi-Processing）的使用，特别是在AIX操作系统上的应用。以下是对相关知识点...
本文将详细介绍如何使用Oracle DUL工具来恢复一张被误删除的表——`account.al_bill_dtl`。 根据描述，“数据抽取工具，可以将丢失的文件再次找回！”这里的“数据抽取工具”即指Oracle DUL工具，它能够在不完全...
同时也有单库超过10TB的使用例子，这得益于PRM-DUL 内置了小型嵌入式数据库，当索要恢复的ORACLE数据库很大时，PRM-DUL采用嵌入的数据库来存放找到的ORACLE 源数据，这样可以对源数据做索引和灵活的查询。
dul 9.2 for oracle win
Oracle DUL全称Oracle Data Unloader，泛指作为Oracle数据库文件的数据导出工具，可以在Oracle数据库无法正常启动的情况下对数据文件进行扫描和数据导出。除了Oracle内部使用服务程序外，市面
PRM-DUL Oracle数据库恢复工具，一款专为Oracle数据救援而研发的企业级工具。可在多个操作平台（AIX/HPUX/SOLARIS/Linux/Windows）使用并支持对Oracle 9i/10g/11g/12c各版本数据库的数据救援工作。软件基于JAVA 开发...
在使用Oracle DUL进行数据恢复时，一般遵循以下步骤： 1. **备份与验证**：首先确保有最新的数据库备份，并验证其完整性，以防万一恢复过程中出现问题。 2. **获取相关文件**：包括控制文件、redo logs、数据文件等...
《Oracle DUL工具详解——数据恢复利器》 Oracle数据库作为全球广泛使用的数据库系统之一，其稳定性和安全性备受赞誉。然而，任何系统都有可能出现故障，当遇到Oracle数据库无法正常启动或严重损坏的情况时，数据...