ASM 中的所有文件由oracle 系统来管理,想要从asm中拷贝到文件系统中可以使用如下方法:
create or replace directory SOURCE_DIR as '+USER_DATA/ORCL/DATAFILE/';
create or replace directory ORACLE_DEST as '/tmp/datafile/dest';
BEGIN
dbms_file_transfer.copy_file(source_directory_object =>
'SOURCE_DIR', source_file_name => 'group.257.695065683',
destination_directory_object => 'ORACLE_DEST',
destination_file_name => 'user.dbf');
END;
/