Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 545 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 440 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Clone PDB from RMAN backup

DB version:19c
OS : RHEL 7.9
I have my production pluggable DBs PDB1_P, PDB2_P, PDB3_P running in CDB_01P container DB in the production server.
and
I have my UAT clones of above PDBs: PDB1_U, PDB2_U, PDB3_U running in CDB_01U container DB in the UAT DB server
Once a month, I want to refresh my UAT PDBs (PDB1_U, PDB2_U, PDB3_U) from PDB1_P, PDB2_P, PDB3_P using RMAN tape backup.
RMAN DUPLICATE is a possible solution. But, this involves
Step1. Dropping the target UAT DBs,
Step2. Then, in the UAT DB server, run the below RMAN DUPLICATE to an auxiliary DB (say CDB_01X ) .
set UNTIL TIME "TO_DATE('23-MAY-2022 13:45:00', 'DD-MON-YYYY HH24:MI:SS')"; DUPLICATE DATABASE CDB_01P dbid 8386008743 TO CDB_01X pluggable database PDB1_U, PDB2_U, PDB3_U, root nofilenamecheck ;
Step3. Unplug the PDBs from the auxiliary DB CDB_01X and plugging it to CDB_01U container DB.
Step4. At the ASM layer, I need to move datafiles from CDB_01X subfolder to CDB_01U.
Is there an alternative to the above approach ?
Unfortunately, creating the UAT PDBs via DB Link pointed to production DB (using the below command) is not an option for me as source DBs are very busy 24x7 OLTP DBs and the below approach can hamper production DB's performance.
CREATE PLUGGABLE DATABASE PDB1_U FROM [email protected]_LINK_POINTING_TO_PROD;