Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database
(CDB).
The characteristics of the non-CDB are as follows:
Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
Character set: AL32UTF8
National character set: AL16UTF16
—–O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
Version: Oracle Database 12c Release 1 64-bit
Character Set: AL32UTF8
National character set: AL16UTF16
O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the
CDB?

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database
(CDB).
The characteristics of the non-CDB are as follows:
Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
Character set: AL32UTF8
National character set: AL16UTF16
—–O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
Version: Oracle Database 12c Release 1 64-bit
Character Set: AL32UTF8
National character set: AL16UTF16
O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the
CDB?

A.
Transportable database

B.
Transportable tablespace

C.
Data Pump full export/import

D.
The DBMS_PDB package

E.
RMAN

Explanation:
* Overview, example:
– Log into ncdb12c as sys
– Get the database in a consistent state by shutting it down cleanly.
– Open the database in read only mode
– Run DBMS_PDB.DESCRIBE to create an XML file describing the database.
– Shut down ncdb12c
– Connect to target CDB (CDB2)
– Check whether non-cdb (NCDB12c) can be plugged into CDB(CDB2)
– Plug-in Non-CDB (NCDB12c) as PDB(NCDB12c) into target CDB(CDB2).
– Access the PDB and run the noncdb_to_pdb.sql script.
– Open the new PDB in read/write mode.
* You can easily plug an Oracle Database 12c non-CDB into a CDB. Just create a PDB manifest
file for the non-CDB, and then use the manifest file to create a cloned PDB in the CDB.
* Note that to plugin a non-CDB database into a CDB, the non-CDB database needs to be of
version 12c as well. So existing 11g databases will need to be upgraded to 12c before they can be
part of a 12c CDB.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


michal

michal

why there are questions about PDB/CDB all over again. It`s not even required to iz0-062

K.L

K.L

I thought about this myself

Luca

Luca

B
https://oracle-base.com/articles/12c/multitenant-migrate-non-cdb-to-pdb-12cr1

If the non-CDB is version 11.2.0.3 onward, you can consider using Transport Database, as described here. If the non-CDB is pre-11.2.0.3, then you can still consider using transportable tablespaces.

C can’t be because Note that the
source database must be Oracle Database 11g Release 2 (11.2.0.3) or higher for a full transportable
import