Cloning Oracle E-Business Suite 12.2.11: RMAN + Rapid Clone

Cloning Oracle E-Business Suite (EBS) environments is a critical part of managing development, testing, and DR landscapes. In this post, we walk through the process of cloning EBS 12.2.11 from a production environment to a non-production one using RMAN active duplication and Oracle Rapid Clone utilities.

---

Clone Scenario
Source Database CDB: PRODCDB
Source PDB: prod
Target Database CDB: RNDCDB
Target PDB: RND

---

Step 1: Prepare the Target Server
Create Required Directories
mkdir -p /u01/oracle/RNDCDB
mkdir -p /u01/oracle/RND
mkdir -p /u01/oracle/clone_logs
Verify Swap Space (Must be ≥ 16GB)
free -h

---

Step 2: Run Pre-Clone on Source
Database Tier
cd $ORACLE_HOME/appsutil/scripts/prod_PRODCDB
perl adpreclone.pl dbTier
Application Tier
cd $ADMIN_SCRIPTS_HOME
perl adpreclone.pl appsTier

---

 Step 3: Clone the CDB with RMAN
3.1: Startup Target CDB in NOMOUNT Mode
export ORACLE_SID=RNDCDB
sqlplus / as sysdba
STARTUP NOMOUNT;
3.2: Run RMAN Active Duplicate
rman target sys@PRODCDB auxiliary sys@RNDCDB
DUPLICATE TARGET DATABASE TO RNDCDB
FROM ACTIVE DATABASE
USING COMPRESSED BACKUPSET
SPFILE
SET db_name='PRODCDB'
SET db_unique_name='RNDCDB'
NOFILENAMECHECK;

---

Step 4: Rename PDB
4.1: Open Source PDB in Restricted Mode
ALTER SESSION SET CONTAINER=prod;
ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE;
ALTER PLUGGABLE DATABASE OPEN RESTRICTED;
4.2: Rename PDB from prod ➝ RND
ALTER PLUGGABLE DATABASE prod RENAME GLOBAL_NAME TO RND;

---

Step 5: Verify & Configure Target DB
5.1: Create New PDB Directories
mkdir -p /u01/oracle/RND/db/apps_st/data
mkdir -p /u01/oracle/RND/inst
5.2: Update listener.ora and tnsnames.ora
Add entries for the RND PDB and reload listener:
lsnrctl reload

---

 Step 6: Rapid Clone - Database Tier
6.1: Configure DB Tech Stack
cd $ORACLE_HOME/appsutil/clone/bin
perl adcfgclone.pl dbTechStack
6.2: Configure DB Tier
perl adcfgclone.pl dbconfig /u01/oracle/RND

---

Step 7: Rapid Clone - Application Tier
cd $INST_TOP/admin/scripts
perl adcfgclone.pl appsTier

---

Step 8: Validation
Confirm PDB Status
SELECT name, open_mode FROM v$pdbs;
Validate Application Access
Log in to EBS via the web URL.
Confirm hostname, SID, and environment file reflect RND.

---

Conclusion
Cloning Oracle EBS 12.2.11 using RMAN and Rapid Clone provides a clean, consistent, and automated way to refresh non-prod environments from production. This setup is ideal for development, patch testing, and training use cases.
Always mask sensitive data and change passwords after cloning.

---

Let me know if you want this blog exported to PDF/Word, or if you want an Ansible/Shell script to automate it.