This is a post about migrating a database from NON ASM type to ASM type,it includes the screenshots also


Scenario:-suppose you have installed ASM and now you want to convert a non ASM type database into ASM type database,to do this task follow the following steps,exact screenshots are also provided for a better result


Step 1)_ON DATABASE INSTANCE PROMPT-disable block change tracking if it was enabled

Step 2)_ON DATABASE INSTANCE PROMPT-create a pfile from the spfile,this file would be created in the ORACLE_HOME\database location for windows and ORACLE_HOME/dbs location for linux

Step 3)_ON DATABASE INSTANCE PROMPT-make the following changes in the pfile which you have already created,make changes for the location of controlfile,db_create_file_dest and db_create_online_log_dest_1 parameter and make them to prompt towards the address of the ASM Diskgroup

Step 4)_ON DATABASE INSTANCE PROMPT-shutdown and startup teh database in nomount mode using newly changed pfile

Step 5)_ON RMAN PROMPT-restore the controlfile from the old control file(the controlfile of the NON ASM database)

Step 6)_ ON RMAN PROMPT -mount the database

Step 7)_ON RMAN PROMPT -backup the NON ASM database as the copy  into the diskgroup of yours,this will copy the database files into the ASM diskgroup

Step 8)_ON RMAN PROMPT-Switch all datafiles into new ASM disk group,this will rename the database files according to the diskgroup location and address

Step 12)_ ON RMAN PROMPT-open the database

Your database conversion from a NON ASM database into an ASM database have been completed

NOTE-To confirm the conversion crosscheck with the paths of the database files like controlfile and datafiles