Oracle 12c no-CDB轉換為CDB

如果把資料庫從11g 升級到12c，或者在12c中建立的，就是NON CDB，那麼這樣的資料庫就是普通的單例項，

和12c 之前的資料庫沒有區別，但12c 的特點就是CDB 管理，所以既然上12c，還是要切換成CDB 進行管理。

https://blog.csdn.net/shiyu1157758655/article/details/78592265

ORCLE 12.1 Creation of a PDB from a Non-CDB

You can move a non-CDB into a PDB.

You can accomplish this task in the following ways:

• Executing  DBMS_PDB.DESCRIBE  on a non-CDB in Oracle Database 12 c

  You place a non-CDB in a transactionally consistent state, and then run the  DBMS_PDB.DESCRIBE function to generate XML metadata about this database. While connected to the root in the CDB, you execute the  CREATE PLUGGABLE DATABASE  statement to create a PDB from the existing non-CDB. Finally, to convert the definitions in the PDB data dictionary to references to objects in  CDB$ROOT , log in to the PDB and run the  noncdb_to_pdb.sql  script.

  See  Oracle Database Administrator’s Guide  to learn how to perform this technique.

• Using Oracle Data Pump with or without transportable tablespaces

  You can define a data set on a non-CDB using Oracle Data Pump. This non-CDB can be in the current or a previous Oracle Database release, for example, Oracle Database 10 g . You create an empty PDB in an existing CDB, and then use Oracle Data Pump to import the data set into the PDB.

  A Full Transportable Export using Oracle Data Pump exports all objects and data necessary to create a complete copy of the database. Oracle Data Pump exports objects using direct path unload and external tables, and then imports objects using  direct path INSERT  and external tables. The Full Transportable dump file contains all objects in the database, not only table-related objects. Full Transportable Export is available starting in Oracle Database 11 g  Release 2 (11.2.0.3) for import into Oracle Database 12 c .

  See  Oracle Database Administrator’s Guide  to learn how to perform this technique.

• Using Oracle GoldenGate replication

  You replicate the data from the non-CDB to a PDB. When the PDB becomes current with the non-CDB, you switch over to the PDB.

  See  Oracle Database Administrator’s Guide  to learn how to perform this technique.

ORACLE 12.2 Creation of a PDB by Cloning a PDB or a Non-CDB

多租戶架構文件的路線圖

Category	Topic	Documentation
Concepts	Overview of CDBs and PDBs	Chapters in  Oracle Database Concepts , and  Oracle Database Administrator’s Guide
Administration	Creating and configuring a CDB	Oracle Database Administrator’s Guide
Administration	Managing a CDB	Oracle Database Administrator’s Guide
Administration	Creating and configuring PDBs	Oracle Database Administrator’s Guide
Administration	Managing PDBs	Oracle Database Administrator’s Guide
Administration	Creating and removing application containers	Oracle Database Administrator’s Guide
Administration	Administering application containers	Oracle Database Administrator’s Guide
Performance	Troubleshooting PDBs	Oracle Database Performance Tuning Guide
Monitoring	Viewing information about CDBs and PDBs	Oracle Database Administrator’s Guide
Backup and Recovery	Performing backup and recovery in a CDB	Oracle Database Backup and Recovery User’s Guide
Security	Managing common users, roles, and privileges in a CDB	Oracle Database Security Guide
Miscellaneous	All other tasks relating to managing a CDB or PDB, including Oracle RAC, resource management, data transfer, and so on	Oracle Database Administrator’s Guide  is the primary task-oriented intermediate and advanced documentation for managing CDBs. This guide also contains See Also links to books that cover different CDB topics. For example,  Oracle Database Utilities  explains concepts and tasks specific to PDBs when using Oracle Data Pump.