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.
About the Author Muhammad Rawish Siddiqui
Master in Computer Science and Post-Graduation in MIS. EDRP (EC-Council Disaster Recovery Professional), Security+, OCP 7.3, 10, 11g, 12c, 11i, R12, OCE 11i System Administration, Linux and RAC 10g, 11g, and OCS in Performance Tuning. More than 18 years’ Information Technology consecutive hands-on experience, possess diversified business and technical background on a wide variety platforms, hardware and operating systems, in the Capacity of Sr. Team Lead Consultant, Sr. Database Administrator, Sr. Applications DBA, Sr. Resident Consultant and Manager Systems. Extensive experience in managing ERP environments and large Databases including Space Management, Backup and Recover, Performance Tuning, Routine Tasks Automation and Database/Applications Health Checks. Started Oracle related Career from Oracle 6. Worked on 7, 8, 9i, 10g, 11g, 12c & e-Business 11.0.3, 11.5.9, 11.5.10.2, R12 and R12.2. Distinct Technical Jobs such as installation, migration, implementation, upgrade, cloning, and maintenance were performed hundreds number of times. Database and Applications (Security & Performance) related Health Checks, RAC & Data Guard Implementation/Troubleshooting Switchover/Failover were also made during the tenure on the basis of As-When-Needed. Contact Me for Database/Applications Installation, Upgrade, Migration, Disaster Recovery, Troubleshooting and Health Checks.