Clone Pluggable Database - Oracle 12c

Cloning Pluggable Database in Oracle 12c

Cloning databases in versions prior to 12c was a challenge. We need to use RMAN to perform cloning. Now its made very easy using one single command.

Create pluggable database TARGET_NAME FROM SOURCE_NAME


Lets see how to clone a new database

Source Name  : ORC1
Target Name : ORC3


1. We should be logged in as CDB$ROOT ( Container DB) to perform this task

2. Lets create & insert some sample data in ORCl database 

3. Before cloning we need to make sure that we open the source database in READ ONLY.

This step is MANDATORY!!!!

4. Clone the Pluggable Database

Use the CREATE PLUGGABLE DATABASE FROM CLAUSE to create the clone DB

Datafiles have been created


























View the Status

By default the new pluggable clone database will be in MOUNT state.

5. Post Tasks

Open the Source Database & Target Database to READ WRITE Mode

ORC1 & ORC3

6. Final Verification

Lets check if the table exists in the newly created database

Alert Log