oracle asm 复制文件,oracle 10g asm 文件copy--dbms_file_transfer包

SQL> col directory_path for a80;

SQL> select * from dba_directories;

OWNER          DIRECTORY_NAME        DIRECTORY_PATH

--------  ------------------------------ --------------------------------------------------------------------------------

SYS          DIR_DP         /home/oracle/back_up

SYS          EXP_DIR         /u01/app/oracle/dir/exp_dir

SYS          ORACLE_OCM_CONFIG_DIR       /u01/app/oracle/product/10.2.0/db_1/ccr/state

SYS          ASM_SPFILE        +CNDATA/educn

SYS          DATA_PUMP_DIR        /u01/app/oracle/product/10.2.0/db_1/rdbms/log/

exec dbms_file_transfer.copy_file('ASM_SPFILE', 'spfileeducn.ora', 'DIR_DP', 'spfileeducn.ora')

归档拷贝

SQL> create directory arc_log as '+ARCHIVE/educn/archivelog/2013_11_16';

sql>exec dbms_file_transfer.copy_file('arc_log', 'thread_1_seq_67.354.831642407', 'DIR_DP', '20131116.arc')

SQL> host ls -lh /home/oracle/back_up

详细参见

http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_ftran.htm

posted on 2013-11-25 17:25 snowhill 阅读(204) 评论(0)  编辑 收藏 引用 所属分类: 数据库-oracle