asm拷贝文件到文件系统

最新推荐文章于 2024-01-01 20:29:29 发布

cri3224

最新推荐文章于 2024-01-01 20:29:29 发布

阅读量244

点赞数

文章标签：数据库

SQL> create or replace directory SOURCE_DIR as '+DATA_DG/racdb/datafile/';

Directory created.

SQL> create or replace directory ORACLE_DEST as '/home/oracle/';

Directory created.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
+DATA_DG/racdb/datafile/system.256.805972643
+DATA_DG/racdb/datafile/sysaux.257.805972643
+DATA_DG/racdb/datafile/undotbs1.258.805972645
+DATA_DG/racdb/datafile/users.259.805972645
+DATA_DG/racdb/datafile/undotbs2.267.805972815

SQL> BEGIN
2 dbms_file_transfer.copy_file(source_directory_object =>'SOURCE_DIR', source_file_name => 'system.256.805972643',destination_directory_object => 'ORACLE_DEST',destination_file_name => 'system.256.805972643');
END; 3
4 /

PL/SQL procedure successfully completed.

SQL> !ls -l
total 779412
-rw-r--r-- 1 oracle oinstall     34657 Apr 9 2013 ashrpt_1_0409_1029.html
-rw-r--r-- 1 oracle oinstall   1139345 Apr 9 2013 awrdiff_1_1122_1_1130.html
-rw-r--r-- 1 oracle oinstall      1577 Apr 12 2013 droptable.sql
-rw-r--r-- 1 oracle asmadmin      1968 Jun 9 2013 pfileracdb.ora
-rw-r----- 1 oracle asmadmin 796925952 Dec 18 14:21 system.256.805972643
真的好简单。

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

转载于:http://blog.itpub.net/24500180/viewspace-1063576/