Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question.

Asked: May 12, 2021 - 8:41 am UTC

Last updated: May 14, 2021 - 6:42 am UTC

Version: 12.1.0.2

Viewed 100+ times

You Asked

Hello team,

we are planning to clone a two nodes RAC database on ASM to a test database on one server only. The test server has grid and Oracle database software installed and ASM diskgroups configured.

After RMAN duplicate from active database with cluster_database=false, we will have to convert the test database into RAC. What is the correct way to do this? Can we do that with pfile modification and then srvctl add database?

Thanks and Regards,
Le

and we said...

Check MOS note 1913937.1

It provides a step-by-step guide for this exact process. The TOC looks like

  A) Setup Oracle Clusterware / Grid Infrastructure (GI)
  1) Install/Configure Oracle Clusterware (aka Grid Infrastructure in 11g onwards) and ASM
  2) Install Oracle RDBMS Software Oracle Home
  3) Create required ASM diskgroups
  B) Clone using RMAN DUPLICATE
  1) Add Static Listener Entry in <CLUSTER_NAME>
  2) Add TNS entry for UAT in PROD
  3) Copy Password File from PROD to UAT
  4) Verify TNS Connectivity to UAT from PROD
  5) Create Directory Structures for <DATABASE_NAME>
  6) Start <DATABASE_NAME> (auxiliary) instance in NOMOUNT mode
  7) Connect RMAN to Target (PROD) and Auxiliary (<DB_NAME>) using TNS
  8) DUPLICATE Command Execution
  C) Convert UAT from Single Instance to RAC
  1) Copy ConvertToRAC_AdminManaged.xml to UAT_ConvertToRAC.xml (or any desired name)
  2) Modify xml file UAT_ConvertToRAC.xml to convert UAT  to 2 Node RAC in ASM
  3) Run RCONFIG to convert UAT to 2 Node RAC using modified xml file
  4) Verify that database UAT is converted to 2 Node RAC using srvctl
  5) Verify RAC database conversion using SQL queries




Rating

  (1 rating)

Comments

Thank you

A reader, May 14, 2021 - 7:01 am UTC

Thank you for the answer!

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database