Convert Single Instance database to RAC database !!!

Home »  10g »  Convert Single Instance database to RAC database !!!

On April 17, 2016, Posted by , In 10g,11g,12c, By , , With No Comments

This article is a continuation to our previous article where we have seen how to clone a database using RMAN Active Database. Now here we will see the steps to convert single instance database to RAC database.



• Follow below steps to convert the Single Instance database to RAC database

– Shutdown the Database


– Rename init.ora and spfile.ora

$ cd $ORACLE_HOME/dbs
$ mv initORCLDB.ora initORCLDB.ora_orig
$ mv spfileORCLDB.ora spfileORCLDB.ora_orig


– Create new init.ora as below

Change local_listener IPs, DiskGroup Names according to your environment


– Start the DB using new init.ora file


– Create spfile from pfile and shutdown the database


– Rename init.ora file and create new init.ora again as shown below

$ mv initORCLDB1.ora initORCLDB1.ora_orig2

Now create new init.ora file with only spfile entry


– Start the database using SPFILE created


– Add database and instances in cluster

Once database is started using spfile, you can now add database and its instances in cluster.


– Add redo log groups for thread 2 and enable it


– Shutdown the database


– Copy init.ora on second node and create Audit dump directory


– Start DB using srvctl and change config as shown below

That’s it, we have completed the steps of single instance to rac database conversion.


Tags : , ,

Leave a Reply

Your email address will not be published. Required fields are marked *