STEP BY STEP PROCEDURE FOR NON ASM TO ASM

Step 1: Start the ASM instance.
export ORACLE_SID=+ASM
sqlplus "/as sysdba"
startup
ASM diskgroup mounted

Step 2: Take one more TERMINAL and list all the pysical files 
details.
export ORACLE_SID=prod
startup
select instance_name,status from v$instance;
select name from v$controlfile;
/../.../control01.ctl
/../.../control02.ctl
/../.../control03.ctl
select member from v$logfile;
select name from v$datafile;
show parameter db_reco
db_recovery_file_dest string /.../.../flash_recovery
db_recovery_file_dest_size big integer 2G
show parameter db_create_file
show parameter control
control_file_record_keep_time integer 7
control_files string /../.../.../../control01.ctl,...02.ctl,...03.ctl
archive log list;
archive log should be enabled.
select name,total_mb,free_mb from v$ASM_DISKGROUP; (export ORACLE_SID=+ASM)
NAME TOTAL_MB FREE_MB
DATA 4094 3900
RECO 4094 3900
alter system set control_files= '+DATA' scope=spfile;
alter system set db_create_file_dest='+DATA';
rman
connect target sys/sys
rman>
backup current controlfile format '/u01/control.ctl'
rman>
shutdown immediate;
rman>
startup nomount
rman>
restore controlfile from '/u01/control.ctl';
rman>
alter database mount;
rman>
backup as copy database format '+DATA';
WARNING CONTROLFILE IS NOT CURRENT CONTROLFILE AUTOBACKUP SKIPPED
rman> 
report schema
it will show non asm datafiles 
rman>
switch database to copy;
datafile1 switched to datafile copy "+DATA/prod/../.././/
datafile2 switched to datafile copy "+DATA/prod/../.././/
datafile3 switched to datafile copy "+DATA/prod/../.././/
datafile4 switched to datafile copy "+DATA/prod/../.././/
rman> 
report schema;
It will show asm datafiles ....
rman>
alter database open resetlogs; 
error
rman> 
recover database;
rmam> 
alter database open resetlogs;
database open
select member from v$logfile;
select name from v$datafile;
select name from v$controlfile;
above command will show asm diskgroup file only.
select name from v$tempfile;
/u01/.../...temp01.dbf
alter database tempfile '/u01/.../...temp01.dbf' drop including datafiles;
alter databae add tempfile "+DATA" size 100m;
select name from v$tempfile;
col for a50
select group,member,from v$logfile;
it will show non asm files
select group#,status,from v$log;
GROUP# STATUS
------- ---------------
1 UNUSED
2 CURRENT
3 UNUSED
ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE ADD LOGFILE GROUP 1 "+DATA" SIZE 10M;
select group#,status,from v$log;
GROUP# STATUS
1 UNUSED
2 CURRENT
3 UNUSED
ALTER DATABASE DROP LOGFILE GROUP 3;
ALTER DATABASE ADD LOGFILE GROUP 3 "+DATA" SIZE 10M;
ALTER SYSTEM SWITCH LOGFILE;
ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE ADD LOGFILE GROUP 2 "+DATA" SIZE 10M;
select group#,status,from v$log;
select group,member,from v$logfile;
Now it will show asm logfile.
sql>
create spfile="+DATA" FROM pfile;
sql>
cretae spfile='+DATA/prod/spfile+prod.ora' from pfile;
sql>
shut immediate;
sql>
startup
sql>
alter system set db_recovery_dest='+FLASH';
__________________________________________________________________________________________________________________________________