You can use these steps to migrate a NON-ASM database to ASM database in Oracle 11gR2.

Prerequisite – ASM instance should be created and up and running.

Single Instance Non ASM DB name Single Instance ASM DB name
test testdb

Step 1 : Check details of Single Instance Database :

Optionally, we can check size the database, so that we have enough space available to allocate to new database.

Step 2 : Create password file for RAC database under $ORACLE_HOME/dbs/ .

Before starting instance create directory required for instance startup

Step 3 : Create pfile under $ORACLE_HOME/dbs/ directory

Step 4: Configure Oracle Listener and tnsnames file

create tnsnames.ora entry as follows :

Step 5: Start database in nomount stage and check connectivity.

Step 6: Take backup of non-asm database

Step 7: Move backup to RAC1 node with scp command.

Step 8: Using rman to Duplicate database

after finishing of duplicate db command in RMAN you will see output like following :

Step 9 :Check database converted to ASM :

Here we can see single instance database of non-asm is successfully converted to ASM as we have duplicated database to RAC1 node.

In the next article, we will convert of single instance ASM database to RAC database.

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

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply