Differences

This shows you the differences between two versions of the page.

--- oracle_rac_database_migration_to_rac [2020/10/18 15:13] – andonovj
+++ oracle_rac_database_migration_to_rac [2020/10/22 12:45] (current) – [Migration] andonovj
@@ Line 7: / Line 7: @@
 In our case we will use the RConfig tool. So let's get going
+{{ :singleinstance2rac.jpg?600 |}}
 =====Prepare the environemnt=====
-First, be sure to take an offline backup of the single instance database, preferably with RMAN:
+Firstly we can check how the database is configured:
+<Code:Bash|Check database configuration>
+[oracle@enode01 ~]$ srvctl config database -db eastdb
+Database unique name: eastdb
+Database name: eastdb
+Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
+Oracle user: oracle
+Spfile: +DATA/EASTDB/PARAMETERFILE/spfile.299.890151031
+Password file:
+Domain: example.com
+Start options: open
+Stop options: immediate
+Database role: PRIMARY
+Management policy: AUTOMATIC
+Server pools:
+Disk Groups: DATA,FRA
+Mount point paths:
+Services:
+Type: SINGLE                  <- Single instance Database
+OSDBA group: dba
+OSOPER group: oper
+Database instance: eastdb
+Configured nodes: enode01
+Database is administrator managed
+[oracle@enode01 ~]$
+</Code>
+Be sure to take an offline backup of the single instance database, preferably with RMAN:
 <Code:bash|Create offlien backup>
@@ Line 111: / Line 142: @@
 </Code>
+====Test the conversion====
+With that, we can test if the conversion will succeed as follows:
+<Code:bash|Test>
+[oracle@enode01 sampleXMLs]$ rconfig ConvertToRAC_AdminManaged.xml
+<?xml version="1.0" ?>
+<RConfig version="1.1" >
+<ConvertToRAC>
+ <Convert>
+ <Response>
+ <Result code="0" >
+ Operation Succeeded
+ </Result>
+ </Response>
+ <ReturnValue type="object">
+There is no return value for this step </ReturnValue>
+ </Convert>
+</ConvertToRAC></RConfig>
+[oracle@enode01 sampleXMLs]$
+</Code>
+After we are sure that the operation will succed we can modify the parameter as follows:
+<Code:bash|Modiy the parameter>
+[oracle@enode01 sampleXMLs]$ vi ConvertToRAC_AdminManaged.xml
+<n:Convert verify="YES">
+:wq!
+[oracle@enode01 sampleXMLs]$
+</Code>
+=====Migration=====
+Finally, run the migration as follows:
+<Code:bash|Migrate>
+[oracle@enode01 sampleXMLs]$ rconfig ConvertToRAC_AdminManaged.xml
+Converting Database "eastdb" to Cluster Database. Target Oracle Home:
+/u01/app/oracle/product/12.1.0/dbhome_1. Database Role: PRIMARY.
+Setting Data Files and Control Files
+Adding Database Instances
+Adding Redo Logs
+Enabling threads for all Database Instances
+Setting TEMP tablespace
+Adding UNDO tablespaces
+Adding Trace files
+Setting Fast Recovery Area
+Updating Oratab
+Creating Password file(s)
+Configuring Listeners
+Configuring related CRS resources
+Starting Cluster Database
+<?xml version="1.0" ?>
+<RConfig version="1.1" >
+<ConvertToRAC>
+ <Convert>
+ <Response>
+ <Result code="0" >
+ Operation Succeeded
+ </Result>
+ </Response>
+ <ReturnValue type="object">
+<Oracle_Home>
+ /u01/app/oracle/product/12.1.0/dbhome_1
+ </Oracle_Home>
+ <Database type="ADMIN_MANAGED" >
+ <InstanceList>
+ <Instance SID="eastdb1" Node="enode01" >
+ </Instance>
+ <Instance SID="eastdb2" Node="enode02" >
+ </Instance>
+/Database> </ReturnValue>
+ </Convert>
+</ConvertToRAC></RConfig>
+[oracle@enode01 sampleXMLs]$
+</Code>
+Once that is done, we can test the database configuration:
+<Code:bash|Check the reconfiguration>
+[oracle@enode01 sampleXMLs]$ srvctl config database -db eastdb
+Database unique name: eastdb
+Database name: eastdb
+Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
+Oracle user: oracle
+Spfile: +DATA/EASTDB/PARAMETERFILE/spfile.299.890151031
+Password file: +DATA/eastdb/orapweastdb
+Domain: example.com
+Start options: open
+Stop options: immediate
+Database role: PRIMARY
+Management policy: AUTOMATIC
+Server pools:
+Disk Groups: DATA,FRA
+Mount point paths:
+Services:
+Type: RAC                <- Changed to RAC Database
+Start concurrency:
+Stop concurrency:
+OSDBA group: dba
+OSOPER group: oper
+Database instances: eastdb1,eastdb2
+Configured nodes: enode01,enode02
+Database is administrator managed
+[oracle@enode01 sampleXMLs]$
+</Code>