(Doc ID 1913937.1)

Last updated on MAY 15, 2017

Applies to:

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


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.


    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 for  both Grid Infrastructure (GI) and Oracle RDBMS Home.

  2. Clone Database (UAT) needs to be a 2 Node RAC having version 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:

Oracle RDBMS Version:

ASM Diskgroups: +PROD1, +PROD2



Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms