Conversion of Single instance ASM Database to RAC ?
- From: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 Aug 2007 00:11:58 +0530
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***
Other related posts:
