In this post, we can perform Convert Single Instance Database to Oracle RAC in Oracle 11gR2.

Prerequisites:

  • we already have single instance ASM database up and running.
  • we have already have second node with ASM running.

If you want to how to convert non asm database to asm database with duplicate command: Click Here

RAC Database name RAC Instance Node RAC Instance Name  RAC node name
testdb Node 1 testdb1 RAC1
Node 2 testdb2 RAC2

Step 1 : Check details of Single Instance  ASM database :

Step 2 : Add redo and undo for second node

Step 3: Add cluster related parameter

  • We need to set cluster_database =true
  • some more cluster related parameters as shown below

Optionally, check controlfile parameter created with OMF and set that in parameter file.

Step 4: Change init file names from inittestdb.ora to inittestdb1.ora and inittestdb2.ora

Step 5 : Shutdown database

Step 6 : Start database on RAC1 node with new pfile

Here we can check database name as TESTDB and instance_name as testdb1.

Step 7 :Now transfer inittestdb2.ora file to rac2 node

Step 8: Start database on RAC2 node

Step 9 : Register the database instances with CRS framework using following command:

Step 10 : stop and start database using srvctl :

Check the status of all instances converted RAC database:

Check status of cluster resources :

Stay tuned for More articles on Oracle RAC 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.