My Oracle Support Banner

STEP BY STEP RMAN DUPLICATE Database From RAC ASM To RAC ASM (Doc ID 1913937.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Enterprise Manager for Oracle Database - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Goal

Creating a RAC duplicate (clone) database from an existing RAC Database.

Outline Steps

  1. Install/Prepare Oracle Clusterware (aka Grid infrastructure in 11g onwards) in clone Nodes
  2. Install Oracle RDBMS software Home in clone Nodes
  3. Make sure that all required pre-requisites / setup for Clusterware / Grid Infrastructure / RAC Oracle Home are executed and verified.
  4. In case of ASM storage, create required ASM diskgroups accessible to all clone Nodes.
  5. Use RMAN DUPLICATE to create a non-RAC database (cluster_database=FALSE) in any one of the clone nodes. In our example we will use RMAN ACTIVE DUPLICATE method introduced in 11g.

    References:

    RMAN 'Duplicate From Active Database' Feature in 11G (Doc ID 452868.1)

    Oracle10G RMAN Database Duplication (Doc ID 259694.1)

    RMAN 'Duplicate Database' Feature in Oracle9i / 10G and 11.1 (Doc ID 228257.1)
     

  6. Convert the non-RAC clone (duplicate) database to RAC Database using tools like rconfig, Oracle Enterprise Manager, etc.

     

Example Setup

The steps are illustrated with example having below setup:

  1. Source Database (PROD) is a  3 Node RAC having version 11.2.0.3 for  both Grid Infrastructure (GI) and Oracle RDBMS Home.

  2. Clone Database (UAT) needs to be a 2 Node RAC having version 11.2.0.3 for  both Grid Infrastructure (GI) and Oracle RDBMS Home.

Source Database PROD (which is to be DUPLICATEd)

Database Name: PROD

Number of RAC Nodes: 3

Node Names: prod01, prod02, prod03

Instance Names: PROD1, PROD2, PROD3

Grid Infrastructure Version: 11.2.0.3

Oracle RDBMS Version: 11.2.0.3

ASM Diskgroups: +PROD1, +PROD2

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
 Outline Steps
 Example Setup
 Source Database PROD (which is to be DUPLICATEd)
 Clone Database UAT to achieve 
Solution
 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 UAT
 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 UAT
 6) Start UAT (auxiliary) instance in NOMOUNT mode
 7) Connect RMAN to Target (PROD) and Auxiliary (UAT) 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
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.