How to Move a Datafile from Filesystem to ASM Using ASMCMD CP Command

SQL> select file_id , file_name from dba_data_files ;

   FILE_ID FILE_NAME
---------- ----------------------------------------------------------------------------------------------------
4 +DATA/orcl/datafile/users.279.875242649
3 +DATA/orcl/datafile/undotbs1.278.875242649
2 +DATA/orcl/datafile/sysaux.277.875242649
1 +DATA/orcl/datafile/system.276.875242649
5 +DATA2/orcl/datafile/users.294.875976397
6 /data01/app/oracle/product/11.2.0.3/db_1/dbs/user02.dbf

6 rows selected.


SQL> alter system switch logfile;

System altered.

SQL> alter database datafile 6 offline;

Database altered.

SQL> select file_name, file_id, online_status from dba_data_files where file_id=6;

FILE_NAME                           FILE_ID   ONLINE_STATUS
---------------------------------------------------------------------------------------------------- ------
/data01/app/oracle/product/11.2.0.3/db_1/dbs/user02.dbf      6      RECOVER


ASMCMD> cp /data01/app/oracle/product/11.2.0.3/db_1/dbs/user02.dbf +DATA/ORCL/DATAFILE/user02.dbf
copying /data01/app/oracle/product/11.2.0.3/db_1/dbs/user02.dbf -> +DATA/ORCL/DATAFILE/user02.dbf

MOUNTED  EXTERN  N      DATA2/
ASMCMD> cd DATA/ORCL/DATAFILE
ASMCMD> pwd
+DATA/ORCL/DATAFILE
ASMCMD> ls -lt
Type      Redund  Striped  Time             Sys  Name
                                            N    user02.dbf => +DATA/ASM/DATAFILE/user02.dbf.258.880490555
DATAFILE  UNPROT  COARSE   MAY 23 20:00:00  Y    USERS.279.875242649
DATAFILE  UNPROT  COARSE   MAY 23 20:00:00  Y    UNDOTBS1.278.875242649
DATAFILE  UNPROT  COARSE   MAY 23 20:00:00  Y    SYSTEM.276.875242649
DATAFILE  UNPROT  COARSE   MAY 23 20:00:00  Y    SYSAUX.277.875242649

SQL> select file_name, file_id, online_status from dba_data_files where file_id=6 ;

FILE_NAME                    FILE_ID ONLINE_STATUS
--------------------------------------------------------------------------
+DATA/orcl/datafile/user02.dbf 6     ONLINE    

SQL> select file_name, file_id, online_status from dba_data_files
  FILE_ID FILE_NAME
---------- -------------------------------------------------------------
4 +DATA/orcl/datafile/users.279.875242649
3 +DATA/orcl/datafile/undotbs1.278.875242649
2 +DATA/orcl/datafile/sysaux.277.875242649
1 +DATA/orcl/datafile/system.276.875242649
5 +DATA2/orcl/datafile/users.294.875976397
6 +DATA/orcl/datafile/user02.dbf