DBMS_FILE_TRANSFER用法取asm下文件

###192.168.8.115的asm里下的日志文件取到192.168.8.116所在的asm或者os下###
DBMS_FILE_TRANSFER包提供几种方法在数据库间复制和传输二进制文件

--在116上创建database link
create public database link dblk_115 connect to t_dblk identified by t_dblk using t_dblk;
create user t_dblk identified by t_dblk account unlock;
grant dba to t_dblk;
--载115创建源目录
CREATE OR REPLACE DIRECTORY test1 AS '+flashare_dg/orcl/archivelog/2014_01_03' ;
GRANT WRITE ON DIRECTORY test1 TO t_dblk;
--在116创建目标目录
CREATE DIRECTORY test3 AS '/u01/test2';
GRANT WRITE ON DIRECTORY test2 TO sys;
--利用dbms_file_transfer工具指定传输
begin
DBMS_FILE_TRANSFER.GET_FILE(source_directory_object=>'test1',
source_file_name=>'thread_1_seq_152.305.835872239',
source_database=>'dblk_115',
destination_directory_object=>'test3',
destination_file_name=>'thread2');
end;
--传输后在192.168.8.116asm上及OS上的结果
ASMCMD> ls
thread1
thread2
ASMCMD> ls -sl
Type        Redund  Striped  Time             Sys  Block_Size  Blocks     Bytes     Space  Name
                                              N                                            thread1 => +DATA_DG1/TRSEN/ARCHIVELOG/FILE_TRANSFER/thread_0_seq_0.256.835886497
                                              N                                            thread2 => +DATA_DG1/TRSEN/ARCHIVELOG/FILE_TRANSFER/thread_0_seq_0.257.835886791
ASMCMD> cd +data_dg1/trsen/archivelog/file_transfer/
ASMCMD> ls -sl
Type        Redund  Striped  Time             Sys  Block_Size  Blocks     Bytes     Space  Name
ARCHIVELOG  UNPROT  COARSE   JAN 03 14:00:00  Y           512  100057  51229184  51380224  thread_0_seq_0.256.835886497
ARCHIVELOG  UNPROT  COARSE   JAN 03 14:00:00  Y           512  100057  51229184  51380224  thread_0_seq_0.257.835886791
--OS上
[oracle@trsen test2]$ pwd
/u01/test2
[oracle@trsen test2]$ ll
total 50088
-rw-r----- 1 oracle oinstall 51229184 Jan  3 14:52 thread2
--查询删除，删除相关数据及目录
select object_name from dba_objects where object_type='DATABASE LINK';
drop directory test3 ;
drop directory test1 ;
drop user t_dblk cascade;
drop public database link dblk_115；