How to copy a datafile from ASM to a file system not using RMAN

文章参考：http://blog.csdn.net/tianlesoftware/article/details/6342763
1.首先RAC环境下数据文件的位置

SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- +RAC_GROUP/hhpen1/datafile/system.277.856639363 +RAC_GROUP/hhpen1/datafile/undotbs1.276.856639369 +RAC_GROUP/hhpen1/datafile/sysaux.268.856639367 +RAC_GROUP/hhpen1/datafile/users.270.856639369 +RAC_GROUP/hhpen1/datafile/undotbs2.278.856639551

2.在目标数据库上创建一个源目录 source_dir

SQL> create or replace directory source_dir as '+RAC_GROUP/hhpen1/datafile'; Directory created.

3.在目标数据库上创建一个目标目录

SQL> create or replace directory data_dir as '/u01/app/arch_bak/bak_dest'; Directory created.

4. 执行DBMS_FILE_TRANSFER包

SQL> BEGIN   2    dbms_file_transfer.copy_file(   3    source_directory_object =>'source_dir',   4    source_file_name =>'system.277.856639363',   5    destination_directory_object =>'data_dir',   6    destination_file_name =>'system.277.856639363');   7  END;   8  / PL/SQL procedure successfully completed.

5.查看是否成功拷贝

[oracle@rac1 bak_dest]$ ll total 492012 -rw-r----- 1 oracle oinstall 503324672 Aug 28 16:49 system.277.856639363 [oracle@rac1 bak_dest]$ pwd /u01/app/arch_bak/bak_dest

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

转载于:http://blog.itpub.net/29634949/viewspace-1259648/