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.

Leave a Comment:

4 comments
Steeve says November 19, 2008

What about the online redo log?

Reply
John says November 19, 2008

I would like to see other bits with ASM like , what is ASM ? when to use and when not to use ?
Issues around ASM and configuration with E-Business

Reply
Muhammad Rawish Siddiqui says November 22, 2008

ASM is one of the new features of Oracle 10g in order to simplify Storage of Oracle Database Files such as datafiles, redolog files and controlfiles. The feature of Stripping and Mirroring are also included in the ASM. In ASM, One can use RAW file system in order to boost the performance.

To some extend, we can say that ASM is extension of OMF.

Reply
User says December 9, 2010

Hi Rawish,

Nice article. Can you tell me is using backup as copy comand mandatory ?

As it will take so long time. Is there any way to increase the performance

Let me know

Reply
Add Your Reply

Not found