Conversion of Single instance ASM Database to RAC ?

Folks

How is Conversion of Existing Single instance Database(ASM) to 2-instance RAC done?

STEPS Envisaged:-

• RE-Creation of Controlfile using "RAC Related ORACLE_HOME" with init.ora parameter cluster_database=FALSE. NOTE - This is Done & the Single Instance ASM Database is brought up.
• Add Redo logfiles for THREAD 2 & Enable the Same.
• Change init.ora parameters on Both Nodes (Set cluster_database=TRUE, cluster_database_instances=2 etc)
• Issue following 3 srvctl commands $ srvctl add database -d ASMDBR -o /ora/asm10gr2/product $ srvctl add instance -d ASMDBR -i ASMDBR1 -n spesuns4p-2 $ srvctl add instance -d ASMDBR -i ASMDBR2 -n spesuns4p-4

NOTE - CRS Setup for 2 Node ASM-RAC is already done & working as seen below. $ crs_stat -t
Name Type Target State Host

ora....SM1.asm application    ONLINE    ONLINE    spesuns4p-2
ora....p-2.gsd application    ONLINE    ONLINE    spesuns4p-2
ora....p-2.ons application    ONLINE    ONLINE    spesuns4p-2
ora....p-2.vip application    ONLINE    ONLINE    spesuns4p-2
ora....SM2.asm application    ONLINE    ONLINE    spesuns4p-4
ora....p-4.gsd application    ONLINE    ONLINE    spesuns4p-4
ora....p-4.ons application    ONLINE    ONLINE    spesuns4p-4
ora....p-4.vip application    ONLINE    ONLINE    spesuns4p-4

CONFIG:-

• Oracle 10gR2
• Solaris 10

Cheers & Thanks indeed,

Vivek

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***

--
http://www.freelists.org/webpage/oracle-l