Oracle 18c new feature, cloning a PDB Database using DBCA for the purpose of creating multiple, identical PDBs. PDB clone helps with the mass creation of identical PDBs for test and development purposes.

In 12c, you can clone the PDB using PDBSEED or from unplugged database as show below.

12.2.PNG

Now in 18c, you can clone from existing plugged database.

18c.PNG

Here is the Demo. This example clones a PDB using the silent mode of DBCA.

  • Source CDB : CDB18
  • Source PDB : PDB18
  • Cloned PDB: PDB18_copy

Clone PDB from plugged PDB using DBCA.

Check status of new PDB.

Successfully completed the cloning a PDB Database from exiting plugged in PDB  using DBCA.

Mandy

Leave a Reply