This content has been marked as final. Show 4 replies
There will be no data loss in converting single instance to RAC.
Follow the steps as documented here:
Can we use the current single host with database instance and ASM as first Oracle RAC cluster node while adding the second RAC node?Yes....pretty standard way of doing it.
Please refer to hte following link:
Yes you can also use existing server as a part of first RAC node but would be better to have similar hardware configuration for all the cluster nodes. In order to migrate your database
from single instance with ASM to RAC database you have to follow below steps:-
Step 1> Install 11g Grid Infra software which will basically install clusterware ASM binaries ACFS
Step 2> Install database binaries in separate home in cluster mode
Step 3> Take the database backup which is running from non-clustered database home
Step 4> Use rconfig utility to convert single intsnace existing database running on one of cluster node into RAC database.
Please follow the below link how to use rconfig utility:- (Before proceding rconfig utility I would like to mention that both database binaries should be same. I mean older database home binaries and new installed database binaries in clustered mode. If both are not same then please first upgrade your database and then use rconfig utility).
I tend to use data guard to migrate my database because the downtime is minimal and if anything go wrong I will just rollback to the original server.