Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Conversion from NON-RAC to RAC using Mounted FS.... Basic Qs
Typo Correction:-
Qs How will the names (with paths) for the Redologfiles of the 2nd instance be specified? Is it's creation to be Coupled with Step 3 below?
Subject: Conversion from NON-RAC to RAC using Mounted FS.... Basic Qs
Folks
Request a review of the following Steps for Conversion of NON RAC Database to RAC using Mounted Filesystems.
Am NOT able to find the same in the Oracle 10g Documentation
Configuration
Solaris 10 , Oracle 10.2
NON-RAC Database existing on UFS
RAC Database to exist on Veritas SFRAC ver 5
Qs How will the names (with paths) for the Redologfiles of the 2nd instance be specified? Is it's creation to be Coupled with Step 3 below?
Any Links, Docs on Conversion will help.
Thanks indeed
STEPS - For 2 node / instance RAC
_no_recovery_through_resetlogs=TRUE
2. RE-Create the Controlfile
"startup nomount" & Run the Trace SQL file for RE-Creating the Controlfile
3. Add the 2nd thread
SQL>ALTER DATABASE ENABLE PUBLIC THREAD 2; 4. Remove the following from initRACOL1.ora
_no_recovery_through_resetlogs=TRUE
APPENDIX Sample initRACOL1.ora
*.db_name = RACOL
*.cluster_database=true
*.cluster_database_instances=2
*.service_names='RACOL' # is same as db_name
RACOL1.instance_name=RACOL1
RACOL1.thread=1
RACOL1.instance_number=1
RACOL1.undo_tablespace=UNDO_TABLESPACE1
RACOL2.instance_name=RACOL2
RACOL2.thread=2
RACOL2.instance_number=2
RACOL2.undo_tablespace=UNDO_TABLESPACE2
RACOL1.LOCAL_LISTENER='LISTENER_RAC1' RACOL2.LOCAL_LISTENER='LISTENER_RAC2'
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 31 2006 - 06:15:36 CST
![]() |
![]() |