In this article, we will see the conversion of the non-RAC database to RAC database using DBCA.

Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name
dbtest testrac Node 1 testrac1 RAC1
Node 2 testrac2 RAC2

Part 1: Create a template from existing database.

Step 1: Run DBCA from Single Instance database home.

Step 2 : Choose Single Instance database and click on next then Click on Manage Templates from given list.

Step 3 : Click on Create a database template , and choose from an existing database [Structure as well as data].

Step 4 : Choose and database instance name from which you want to create a template and click next.

Step 5 : Give the name of template , description and destination of template file :

Step 6 : Choose to maintain the file location.

Step 7: It will ask for confirmation click on ok and click Finish.

Step 8 : Check clone template generation progress.

Once it is finished it will ask for “do you want to perform another operation?” click No and then ok.

Check created template in $ORACLE_HOME/assistants/dbca/templates.

Step 9 : Transfer all files like Conversion_non_RAC-DB_to_RAC_DB.ctl,.dbc,.dfb file to RAC2.

Part 2 : Create new RAC database from existing template.

Step 1 : Run dbca from RAC database home. Choose RAC Database.

Step 2 : Choose to create a database and click next.

Step 3 : Choose template we have created recently, Conversion non RAC -DB to RAC-DB.

Step 4 : Choose configuration type as admin managed and choose nodes for RAC database.

Step 5 : Click on configure Enterprise manager , if you want to enable EM.

Step 6 : In next step give Same Administrator password for all accounts , give confirm password and click on next.

Step 7 : Give Storage type as ASM and define Database area as +DATA [your ASM disk].

Step 8 : Specify Fast Recovery Area and Enable archiving (optional).

Step 9 : Custom Scripts :- As I have no scripts for Post database creation so choose no scripts to run and click next.

Step 10 : Set the memory parameters

Step 10: Check the Create Database and Click on finish .

Step 11 : Check Progress of Database creation , once it is created click on close.

Step 12 : Connect database from node RAC1 instance and check active instances.

Stay tuned for More articles on Oracle RAC

Leave a Reply