Migrate Oracle Database from File System to ASM

1. Migrate Redo Log into ASM

alter database add logfile member '+DATA' to group 1;
alter database add logfile member '+DATA' to group 2;
alter database add logfile member '+DATA' to group 3;

alter database drop logfile member '/u01/product/11.2.0/oradata/cat/redo01.log';
alter database drop logfile member '/u01/product/11.2.0/oradata/cat/redo02.log';
alter database drop logfile member '/u01/product/11.2.0/oradata/cat/redo03.log';

2. Migrate Temp Space into ASM

alter tablespace temp add tempfile '+DATA' size 20m;

alter database tempfile '/u01/product/11.2.0/oradata/cat/temp01.dbf' offline ;

3. Migrate ControlFile into ASM

alter system set control_files='+DATA','+DATA' scope=spfile;

restore controlfile from '/u01/product/11.2.0/oradata/cat/control01.ctl';

4. Migrate DataFile into ASM

backup as copy database format '+DATA';
switch database to copy;
recover database;