My Oracle Support Banner

Using PDB Relocation to Move a Single PDB to Another CDB Without Upgrade (Doc ID 2771737.1)

Last updated on APRIL 27, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version All Versions and later
Information in this document applies to any platform.

Goal

 

With the release of Oracle Multitenant, one of the main benefits is the portability of each individual Pluggable Database (PDB).  It is possible to move the self-contained contents of a single PDB from one Container Database (CDB) to another.  In the initial release of Oracle RDBMS 12cR1 this required the PDB to be unplugged from the source CDB and plugged into the destination CDB which could have the potential for extensive downtime.  With 12cR2 the concept of PDB Relocation was introduced, allowing movement of a PDB from one container to another through two SQL commands where the physical copy of the files is performed while the source PDB remains accessible to users and applications.  The final phase of relocation introduces a short downtime of less than 10 minutes to complete the operation.

The primary use cases for PDB Relocation are from a planned maintenance perspective:

Each of these operations is a physical move of the PDB from one container to another.  There is no reorganization of the PDB or its data as part of this move.

This paper will document the process for relocating a PDB with minimal down time, describing:

For PDB Relocation where upgrade of the PDB is required, please see Using PDB Relocation to Upgrade an Individual PDB <Document 2771716.1>.

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
 Prerequisites
 Performing a Pluggable Database (PDB) Relocate
 Steps to Prepare for the Relocate
 Steps to Perform Phase 1 of the Relocate – Source PDB Remains Available
 Steps to Perform Phase 2 of the Relocate – Application Downtime Occurs
 Steps to Perform after the Relocate has Completed
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.