my notes: Moving Datafiles within ASM from DATA to DATA

startup database as mount
startup mount #both node for using parallelism

To check location of datafile
SQL> select distinct substr(file_name, 0,60) AS DATAFILES from dba_data_files;

DATAFILES
------------------------------------------------------------
+DATA/AGAP/DATAFILE/sysaux.271.955306735
+DATA/AGAP/DATAFILE/system.267.955306645
+DATA/AGAP/DATAFILE/undotbs1.275.955306755
+DATA/AGAP/DATAFILE/users.277.955306777

To made script dynamically
set pagesize 200
select distinct 'backup as copy datafile '||file#||' format '||chr(39)||'+DATA_GRUP'||chr(39)||';'|| chr(10)||'switch datafile '||file#||' to copy;' from v$datafile;

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

backup as copy datafile 1 format '+DATA_GRUP';
switch datafile 1 to copy;

backup as copy datafile 2 format '+DATA_GRUP';
switch datafile 2 to copy;

backup as copy datafile 3 format '+DATA_GRUP';
switch datafile 3 to copy;

backup as copy datafile 4 format '+DATA_GRUP';
switch datafile 4 to copy;

backup as copy datafile 5 format '+DATA_GRUP';
switch datafile 5 to copy;

backup as copy datafile 6 format '+DATA_GRUP';
switch datafile 6 to copy;

backup as copy datafile 7 format '+DATA_GRUP';
switch datafile 7 to copy;

backup as copy datafile 8 format '+DATA_GRUP';
switch datafile 8 to copy;

backup as copy datafile 9 format '+DATA_GRUP';
switch datafile 9 to copy;

9 rows selected.

To backup and Switch datafile to other location

rman target /

copy and paste or create script and run in a node or in parallel

backup as copy datafile 1 format '+DATA_GRUP';
switch datafile 1 to copy;
backup as copy datafile 2 format '+DATA_GRUP';
switch datafile 2 to copy;
backup as copy datafile 3 format '+DATA_GRUP';
switch datafile 3 to copy;
backup as copy datafile 4 format '+DATA_GRUP';
switch datafile 4 to copy;
backup as copy datafile 5 format '+DATA_GRUP';
switch datafile 5 to copy;
backup as copy datafile 6 format '+DATA_GRUP';
switch datafile 6 to copy;
backup as copy datafile 7 format '+DATA_GRUP';
switch datafile 7 to copy;
backup as copy datafile 8 format '+DATA_GRUP';
switch datafile 8 to copy;
backup as copy datafile 9 format '+DATA_GRUP';
switch datafile 9 to copy;

To check the result

SQL> select distinct substr(file_name, 0,60) AS DATAFILES from dba_data_files;

DATAFILES
------------------------------------------------------------
+DATA_GRUP/AGAP/DATAFILE/sysaux.271.955306735
+DATA_GRUP/AGAP/DATAFILE/system.267.955306645
+DATA_GRUP/AGAP/DATAFILE/undotbs1.275.955306755

+DATA_GRUP/AGAP/DATAFILE/users.277.955306777

To set up parameter for creating datafile by using OMF
show parameter db_create_file_dest
NAME TYPE VALUE
------------------------------------ ----------- -------------------
db_create_file_dest string +DATA

alter system set db_create_file_dest='+DATA_GRUP' scope=both sid='*';

show parameter db_create_file_dest

NAME TYPE VALUE
------------------------------------ ----------- -------------------

db_create_file_dest string +DATA_GRUP

Moving Datafiles within ASM from DATA to DATA_GROUP