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 1000+ 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 Connor 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)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thank you

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

Thank you for the answer!
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

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