Migrate Non-ASM Oracle Database into ASM System
In this post, I have created a simplified approach to migrate the Non-ASM database into ASM environment. Though this might be a rare case that, we either decide the database system to have non-ASM nature initially and there would be a need to upgrade the system in order to increase the manageability. Here we go,
Steps to Migrate the Database to ASM instance
Step1: start the asm instance
Step2: start oracle database and make it as archive mode,
Step3: take image copy of oracle database backup as below,
Step4: change the controlfile parameter location,
Step5: change the datafile and logfile location,
Step6: Change the flash recovery area to fast recovery area in nomount state,
Step7: check the changes updated appropriately,
Step8: connect to rman and restore the controlfile
Note: database should be in nomount
This will copy the controlfile physically from oradata to +DATA
Step9: mount the database,
Step10: move the datafiles from oracle point to ASM
Step11: recover and open the database,
Step12: check the location of datafile , controlfile
To migrate the tempfile and logfiles,
As we know rman doesn’t take backup of temp and logfiles,
Step13: create a new temp file and make it as default, then delete the existing one,
Step14: drop the existing log file and add it,
Drop the inactive and create the exact same as it was,
And the shifted logfiles will be in unused state,
Step15: to move current redo online, switch it and do checkpoint then drop,
We are not supposed to drop active redo as it may require for crash recovery, so do checkpoint and drop,
Congratulations!!. We have migrated the Non-ASM Database into ASM System. Please do visit other posts. Thank You.