Hi ,
How to migrate a database from ASM to Non ASM?
This question was asked in Interview. I told them below steps but not sure if it was correct. So could you please check and confirm?
Here are the steps to migrate from ASM to NON-ASM.
Step 1 : Take the RMAN Full Backup of Database (not mandatory).
Step 3 : Create pfile from spfile.
Step 5 : Startup database at nomount.
Step 8 : Use RMAN to copy the database from ASM to NON-ASM.
Step 10 : Migrate redo-log file to file system location.
Finally they asked me if there is any parameter needs to be changed during the migration. I didn't know the answer to this question.
But based on the steps provided in the document ( Doc ID 252219.1) , it seems there is no parameter to change. Could you please confirm from your end?
Regards,
Balaji