This content has been marked as final. Show 4 replies
Please refer these
user11977218Please consider closing your threads if you feel that they have been answered.
Status Level: Newbie
Registered: Nov 16, 2009
Total Posts: 31
Total Questions: 20 (17 unresolved)
For converting single instance DB to multiple instace (RAC set up)
1 Perfome the full system backup of the source DB
2 instal the oracle binaries and clusterware binaries on target m/c
3 Add the cluster environment parameters to pfile of source m/c
*.cluster_database = TRUE
*.cluster_database_instances = 2
<SID1>.undo_tablespace=undotbs (undo tablespace which already exists)
4 Open the node 1 m/c (source m/c)
5 "run $ORACLE_HOME/rdbms/admin/catclust.sql to create
cluster database specific views within the existing instance.
6 "Recreate control file if you defined maxinstances to be 1 when you created
the single instance database."
7 " Add instance specific parameters in the init<db_name>.ora for the second
instance on the second node and set appropriate values for it:
*** Names may need to be modified
<SID2>.cluster_database = TRUE
<SID2>.cluster_database_instances = 2
==> where LISTENER_RAC2 is an entry in the tnsnames.ora file like:
(ADDRESS = (PROTOCOL = TCP)(HOST = <node2>)(PORT = 1521))"
8 mount the database (from 1st instance)
9 " alter database
add logfile thread 2
group 3 ('/dev/RAC/redo2_01_100.dbf') size 100M,
group 4 ('/dev/RAC/redo2_02_100.dbf') size 100M;"
10 alter database enable public thread 2;
11 Create a second Undo Tablespace from the existing instance
"CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE
'/dev/RAC/undotbs_02_210.dbf' SIZE 200M ;
12 Set ORACLE_SID and ORACLE_HOME environment variables on the second node.
13 Start the second Instance.
My Blog: http://shishirtekade.blogspot.com
There are two different ways to convert single instance database to cluster database. One of method is to use RCONFIG and another method is DBCA. Use RCONFIG if database reside on the same server where CRS is running because RCONFIG convert the existing singlt instance database into Cluster database and use DBCA if database reside on different server other than where CRS is running.
DBCA method is quite simple..Invoke the DBCA and create a database template using existing database with the option including structure as well as data. Copy the template from $ORACLE_HOME/assistants/dbca/template directory to one of cluuster node at the same location and Invoke the DBCA from that cluster node and use that template to create a new cluster database.
For RCONFIG please use the below steps:-
-- copy ConvertToRAC_AdminManaged.xml to another file cluster.xml
node1$cp ConvertToRAC_AdminManaged.xml cluster.xml
-- Edit cluster.xml and make following changes :
. Specify current OracleHome of non-rac database for SourceDBHome
. Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome
. Specify SID of non-rac database and credential. User with sysdba role is required to perform conversion
. Specify the list of nodes that should have rac instances running for the Admin Managed Cluster Database. LocalNode should be the first node in this nodelist.
. Instance Prefix tag is optional starting with 11.2. If left empty, it is derived from db_unique_name
. Specify the type of storage to be used by rac database. Allowable values are CFS|ASM
. Specify Database Area Location to be configured for rac database.
. Specify Flash Recovery Area to be configured for rac database.
-- Run rconfig to convert orcl from single instance database to 2 instance RAC database
-- Check the log file for rconfig while conversion is going on
oracle@node1$ls -lrt $ORACLE_BASE/cfgtoollogs/rconfig/*.log
tailf <log file name>
-- check that the database has been converted successfully
node11$srvctl status database -d orcl
Instance orcl1 is running on node node1
Instance orcl2 is running on node node2
-- Note that rconfig adds password file to all the nodes but adds entry to tnsnames.ora on local node only.
-- For all other nodes, copy the entry for the database (orcl) from tnsnames.ora on local node to tnsnames.ora on remote node(s).