11g OS文件移动到ASM

SQL> col file_name format a30
SQL> select file_name,file_id,tablespace_name from dba_data_files where file_id=37;

FILE_NAME             FILE_ID TABLESPACE_NAME
------------------------------ ---------- ------------------------------
/oracle/oradata/TEMP03.DBF         37 APP_DATA


SQL> select file_name from dba_data_files where tablespace_name='APP_DATA';

FILE_NAME
------------------------------
+DATA/devrac/datafile/app_data
01.dbf

+DATA/devrac/datafile/app_data
02.dbf

+DATA/devrac/datafile/app_data
03.dbf

+DATA/devrac/datafile/app_data
04.dbf

FILE_NAME
------------------------------

/oracle/oradata/TEMP03.DB



ASMCMD> cp /oracle/oradata/TEMP03.DBF app_data05.dbf  
copying /oracle/oradata/TEMP03.DBF -> +DATA/DEVRAC/DATAFILE/app_data05.dbf


SQL> alter database rename file '/oracle/oradata/TEMP03.DBF'  to  '+DATA/devrac/datafile/app_data05.dbf';

Database altered.

SQL> alter database open;