Steps / How to Migrate Non ASM Instance Database to ASM Instance

NOTE: Always Do Exercise on Test Environment, First. 

Assumptions : 

1. ASM Instance is already Created and Ready to Use.

2. DB Instance was Started using ‘spfile’

3. Disk Group Name : ‘+DGDATA’ 

– Set the Parameter ‘db_create_file_dest’ to ‘+DGDATA’  

alter system set db_create_file_dest=’+DGDATA’ scope=spfile;

– Set the Parameter ‘control_file’ to the destination in ASM

alter system set control_files=” scope=spfile;

 – Bounce/Open the Database with ‘NoMount’ Clause
startup nomount

– Restore Control File from the Previous Destination
restore controlfile from ‘/u001/oracle/data/control001.ctl’;

– Mount the Database
alter database mount;

-Do the following :

backup as copy database format ‘+DGDATA’;

switch database to copy;

recover database;

alter database open;

alter tablespace TEMP add TEMPFILE;

alter database tempfile ‘/u001/oracle/data/temp001.dbf’ drop; 

Best of Luck.