Database consolidation is the general process of moving data from one or more non-CDBs into a CDB.
Starting in Oracle Database 12c, you must create a database as either a CDB or non-CDB. You can plug a traditional non-CDB into a CDB as a PDB. The PDB/non-CDB compatibility guarantee means that a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net.
microsoft certification malaysia
The following figure shows two separate non-CDBs: hr and sales. Each non-CDB has its own memory and set of database files, and resides on its own computer. Each non-CDB has its own dedicated user application.
Figure 1-2 Non-CDBs
Description of “Figure 1-2 Non-CDBs”
The following figure shows the same data after being consolidated into the CDB named MYCDB.
juniper certification malaysia
Figure 1-3 Consolidation of Non-CDBs into a CDB
Description of “Figure 1-3 Consolidation of Non-CDBs into a CDB”
Physically, MYCDB is an Oracle database. MYCDB has one database instance, although multiple instances are possible in Oracle Real Application Clusters, and one set of database files, just like a non-CDB.
MYCDB contains two PDBs: hrpdb and salespdb. As shown in Figure 1-3, these PDBs appear to their respective applications just as they did before database consolidation. To administer the CDB itself or any PDB within it, a CDB administrator can connect to the CDB root, which is a collection of schemas, schema objects, and nonschema objects to which all PDBs belong.
See also
Oracle Multitenant Administrator’s Guide to learn how to consolidate non-CDBs into a CDB
Leave a Reply