In previous articles, we have seen various methods of converting Non-RAC database to RAC database.

In this article, we will convert non-RAC database to RAC database using RMAN backup-restore utility.

Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name
MGR MGR Node 1 db1 RAC1
Node 2 db2 RAC2

Step 1: Check details of Single Instance Database :

Step 2 : Take backup of database :

Step 3 : Make directory in RAC node for recovery area:

Step 4: Transfer backupset and autobackup to rac node.

Step 5 : Transfer spfile to RAC1 node , make directories :

Step 6 : Startup database in nomount stage,  Restore control file from autobackup :

Step 7 : Catalog backup files :

Step 8 : Restore database ;

Step 9 : Recover database :

Step 10 : Open database using “open resetlogs” option .

Here we have restore databse from non-rac node to rac node in normal file System.

Part – 2 is Convert Normal File System to ASM :

Convert Non ASM database to ASM Database using Duplicate Database command

Part 3 : Convert Single Instance Database to Oracle RAC :

Convert Single Instance Database to Oracle RAC

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:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

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