ITPub博客

首页 > Linux操作系统 > Linux操作系统 > gdul 1.0.2

gdul 1.0.2

原创 Linux操作系统 作者:fengjin821 时间:2009-06-26 22:05:34 0 删除 编辑
目前支持.dmp,.ctl两种输出格式,支持blob,clob,
1.0.2已经支持跨平台恢复、IOT表。

# ./gdul
Geng's Data Unloader for Oracle 8i/9i/10g, release 1.0.

Copyright (c) 2007-2008,Andy Geng.  All Rights Reserved.
If you have any advises and suggestions,
please contact me:gengyonghui@hotmail.com.

GDUL>bootstrap
bootstrap finished.
GDUL>list user
Id      Name
0       SYS
5       SYSTEM
11      OUTLN
19      DIP
21      TSMSYS
24      DBSNMP
25      ORACLE_OCM
26      SYSMAN
28      MGMT_VIEW
30      GYH
GDUL>set user gyh
GDUL>list table  
Id      Name
12091   BIN$XPjT/Aq0ldHgQAB/AQBKWg==$0
12092   T_NUMBER
12098   T_NUM
12109   T_LONG
12187   T_BLOB1
12190   T_BLOB2
12193   T_CLOB5
12196   T_CLOB8
GDUL>unload table t_num
2008-12-02 10:28:09...unloading table T_NUM 0rows unloaded.
GDUL>unload table t_blob1
2008-12-02 10:30:35...unloading table T_BLOB1 1rows unloaded.
GDUL>unload user gyh
About to unload GYH's tables...

2008-12-02 10:30:39...unloading table BIN$XPjT/Aq0ldHgQAB/AQBKWg==$0 33rows unloaded.
2008-12-02 10:30:39...unloading table T_NUMBER 0rows unloaded.
2008-12-02 10:30:39...unloading table T_NUM 0rows unloaded.
2008-12-02 10:30:39...unloading table T_LONG 0rows unloaded.
2008-12-02 10:30:39...unloading table T_BLOB1 1rows unloaded.
2008-12-02 10:30:39...unloading table T_BLOB2 0rows unloaded.
2008-12-02 10:30:39...unloading table T_CLOB5 2rows unloaded.
2008-12-02 10:30:39...unloading table T_CLOB8 16rows unloaded.
GDUL>help
USAGE:
bootstrap:init dictionary,you should run bootstrap command first
help
desc
exit|quit
list datafile
list user:list users of database
list table: list table of current user
unload table :unload table rows to TXT
unload user
rowid
rdba <0xnnnnnnnn>
show user:show current user
show table
set user
version
GDUL>




gengyonghui 上传了这个附件:
2008-12-4 08:34
  下载次数: 148
gdul_linux.zip (78.39 KB)
 
2008-12-4 18:02
  下载次数: 174
gdul_win.rar (165.42 KB)
 
2008-12-5 10:22
  下载次数: 114
gdul_linux_static.zip (552.08 KB)
  这个是静态链接版本,不需要linux的动态库
 
 
 
 
使用方法:
 
::::::::::::::
control.gdul
::::::::::::::
1,/software/app/oracle/oradata/test/system01.dbf
2,/software/app/oracle/oradata/test/undotbs01.dbf
3,/software/app/oracle/oradata/test/sysaux01.dbf
4,/software/app/oracle/oradata/test/users01.dbf
上面这个文件是写明相对文件号和文件名
::::::::::::::
init.gdul
::::::::::::::
db_block_size=8192
osd_big_endian_flag=false
block_checksum=true
export_mode=true
ldr_enclose_char=|
file_leader_size=0
上面这个文件是指定参数,export_mode=true会导出成dmp,否则导出成文本。
 
 
 
 
 
加了基本的块调试,全部数据块,你看一下调试后的输出,是否正常,包括相对文件号和块号

# ./gdul
Geng's Data Unloader for Oracle 8i/9i/10g, release 1.0.2.

Copyright (c) 2007-2008,Andy Geng.  All Rights Reserved.
If you have any advises and suggestions,
please contact me:gengyonghui@hotmail.com.

GDUL>bootstrap
bootstrap finished.
GDUL>set debug on        
GDUL>unload table t_test3
Unload block<4,1257> 0Rows
Unload block<4,1258> 0Rows
Unload block<4,1259> 0Rows
Unload block<4,1260> 1Rows
2008-12-10 10:47:08...unloading table T_TEST3 1rows unloaded.
GDUL>




gengyonghui 上传了这个附件:
2008-12-10 10:48
  下载次数: 50
gdul_linux.zip (552.95 KB)
 
2008-12-10 10:48
  下载次数: 63
gdul_win.zip (208.83 KB)
 
 
 
 
 
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13165828/viewspace-607689/,如需转载,请注明出处,否则将追究法律责任。

上一篇: truncate的问题
请登录后发表评论 登录
全部评论

注册时间:2009-04-29

  • 博文量
    191
  • 访问量
    505156