Oracle 12cR2: Enhancements in PDB Unplugging and Plugging

ByJoel Pérez ( Oracle ACE Director )

Oracle 12cR2: Enhancements in PDB Unplugging and Plugging

Oracle 12cR2: Enhancements in PDB Unplugging and Plugging


Hi Readers


In Oracle Database 12.1, when a PDB is unplugged, all the data files associated with the PDB along with the PDB manifest must be copied or moved individually over to the remote server where it will be plugged into another CDB.

With Oracle Database 12.2, you can choose to create a single PDB archive file, a compressed file with the .pdb extension, which contains the PDB manifest and all the data files when unplugging a PDB. When plugging in a PDB, the presence of a .pdb file is interpreted and the PDB is plugged into the CDB. You can choose to run the PDB plug-in compatibility test directly on the PDB archive without extracting the PDB manifest file from the archive.

This feature provides ease of managing the unplugging and plugging of PDBs across CDBs.
















Thanks for reading!!


If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn:

Skant Gupta’s LinkedIn:

Join our LinkedIn group: Oracle Cloud DBaaS

or Subscribe to our Enmotech Blog!


Author Bios:


Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China


Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link:


This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD

Follow our Company in Linkedin:

Subscribe to our Blog and enjoy our Weekly Cloud article..!

About the author

Joel Pérez ( Oracle ACE Director ) administrator

2 Comments so far

MiteshPosted on9:39 pm - Jan 7, 2018


Nice to see blogs from learned Oracle Professionals. Pls. keep in touch.

MMindCorp: Innovation and Technology made accessible.
Mumbai, India.

Oracle 12cR2: Enhancements in PDB Unplugging and Plugging – Toad for Oracle Blog – Toad for Oracle – Toad WorldPosted on2:20 am - Jan 10, 2018

[…] For Reading, Click Here: […]

Comments are closed.