• Arun Kumar

Unplug PDB from 12c and Plug into 19c CDB

In this activity, we will be unplugging PDB from Oracle 12c CDB and plug it into Oracle 19c CDB. All the steps of unplugging and plugging PDB remain the same except we need to perform PDB upgrade.


Unplug PDB from 12c CDB


Run dbca command. Select Manage Pluggable Database

database configuration assistant application - manage pluggable databases

Select Unplug a Pluggable database then click the next button Select

database configuration assistant - unplug a pluggable database

Select the container database which pluggable database we need to unplug and click the next button

database configuration assistant-select database

We need to select the Pluggable database name from the drop-down box and then click the next button

dbca Unplug Pluggable Database - generate pluggable database file set

It will show the unpluggable database details

Database Configuration Assistant- Summary
database configuration assistant - unplugging database in progress
database configuration assistant- pluggable database unplugged successfully


Transfer file to 19c CDB Server


Now transfer database file set from 12c to 19c using SCP or WINSCP. PDB database file sets

/u01/app/oracle/product/12.2.0.1/db_1/assistants/dbca/templates/{DB_UNIQUE_NAME}_{PDB_NAME}.dfb

/u01/app/oracle/product/12.2.0.1/db_1/assistants/dbca/templates/{DB_UNIQUE_NAME}_{PDB_NAME}.xml


Plug the PDB into 19c CDB


Run dbca command from 19c CDB. Choose the Manage Pluggable Databases option in it then click the next button

19c dbca - manage pluggable database

Select Create a Pluggable database Choose

19c dbca - create a pluggable database

Choose the container database on which we are planning to plug the HR_PDB, we have only 1 container so we will click NEXT to proceed

19c dbca - dbca select container database

Select Create Pluggable database from an unplugged PDB and select the transferred database file set from the 12c and click NEXT

19c dbca - Create Pluggable Database from an unplugged pdb

We need to provide the required Pluggable Database name then click the next button. If required we can lock all other PDB users and can create a new administrator option too

19c dbca - pluggable database identification options

It will automatically choose the storage type and location if exists already

19c dbca - pdb storage options
19c CDB - dbca Summary
plug the pdb into 19c cdb - DBCA Progress

At the end of the process, you will receive a warning as PDB is in upgrade mode

plug the pdb into 19c cdb - open PDB in upgrade mode


Upgrade PDB


Run dbupgrade -c HR_PDB as the PDB is in Migrate mode

upgrade 19c pdb - Run dbupgrade utility

dbupgrade -c HR_PDB

upgrade pdb - dbupgrade -c PDB

After completion of the upgrade process, log in to the database and run open pdb to bring the PDB from Mount to open

post upgrade pdb - open pdb

ALTER PLUGGABLE DATABASE HR_PDB OPEN;

alter pluggable database open

Recent Posts

See All