[root@bspdev odu]# cd amdu_2012_02_23_11_21_34
[root@bspdev amdu_2012_02_23_11_21_34]# ls -lrt
total 39744
-rw-r–r–. 1 root root 8600 Feb 23 11:21 report.txt
-rw-r–r–. 1 root root 40640512 Feb 23 11:21 DATA_259.f
我们现在再用ODU把259号文件提出来,跟AMDU做一个对比:
[root@bspdev amdu_2012_02_23_11_21_34]# cd ..
[root@bspdev odu]# ./odu
Oracle Data Unloader:Release 4.2.1
loading default config…….
byte_order little
block_size 8192
block_buffers 1024
db_timezone -7
Invalid db timezone:-7
client_timezone 8
Invalid client timezone:8
asmfile_extract_path /odu/asmfile
data_path data
lob_path /odu/data/lob
charset_name AL32UTF8
ncharset_name AL16UTF16
output_format text
lob_storage infile
clob_byte_order big
trace_level 1
delimiter |
unload_deleted no
file_header_offset 0
is_tru64 no
record_row_addr no
convert_clob_charset yes
use_scanned_lob yes
trim_scanned_blob yes
lob_switch_dir_rows 20000
db_block_checksum yes
db_block_checking yes
rdba_file_bits 10
compatible 10
load config file ‘config.txt’ successful
loading default asm disk file ……
grp# dsk# bsize ausize disksize diskname groupname path
—- —- —– —— ——– ————— ————— ——————————————–
1 0 4096 1024K 9000 DATA_0000 DATA /dev/sda3
1 1 4096 1024K 9000 DATA_0001 DATA /dev/sda5
1 2 4096 1024K 9000 DATA_0002 DATA /dev/sda6
2 0 4096 1024K 9000 RECO_0000 RECO /dev/sda7
2 1 4096 1024K 7288 RECO_0001 RECO /dev/sda8
load asm disk file ‘asmdisk.txt’ successful
loading default control file ……
ts# fn rfn bsize blocks bf offset filename
—- —- —- —– ——– — —— ——————————————–
0 1 1 8192 112640 N 0 +DATA/ORA11G/DATAFILE/SYSTEM.256.747310449
1 2 2 8192 119040 N 0 +DATA/ORA11G/DATAFILE/SYSAUX.257.747310449
2 3 3 8192 70400 N 0 +DATA/ORA11G/DATAFILE/UNDOTBS1.258.747310451
4 4 4 8192 4960 N 0 +DATA/ORA11G/DATAFILE/USERS.259.747310451
load control file ‘oductl.dat’ successful
loading dictionary data……done
loading scanned data……done
ODU> asmcmd
Entering asmcmd module.
注意:ODU的最新版本中extract命令已被copy命令替换了:
ASMCMD> extract asmfile +DATA/ORA11G/DATAFILE/USERS.259.747310451 to /u01/app/oracle/odu/amdu_2012_02_23_11_21_34/user01.dbf
starting extract asm file ‘+DATA/ORA11G/DATAFILE/USERS.259.747310451′ to ‘/u01/app/oracle/odu/amdu_2012_02_23_11_21_34/user01.dbf’,file size is 40640512
asm file extract completed.
ASMCMD> exit
Exiting asmcmd module.
[root@bspdev odu]# cd amdu_2012_02_23_11_21_34
[root@bspdev amdu_2012_02_23_11_21_34]# ls -lrt
total 79476
-rw-r–r–. 1 root root 8600 Feb 23 11:21 report.txt
-rw-r–r–. 1 root root 40640512 Feb 23 11:21 DATA_259.f
-rw-r–r–. 1 root root 40640512 Feb 23 11:27 user01.dbf
从结果里可以看到,两者大小一模一样。
从dbv校验的结果来看,两者内容也是一模一样:
[oracle@bspdev ~]$ dbv f