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: AL16UTF16O/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
B is correct.
1) If the non-CDB database was 12.1.0.2, the correct answer would’ve been D. To use DBMS_PDB.DESCRIBE, the database should be 12.1.0.2 or higher. The 12.1.0.2 patchset introduced the ability to create a PDB as a clone of a remote non-CDB
2) If the non-CDB database was 11.2.0.3 or 11.2.0.4, the correct answer would’ve been A. to use Transportable database, the database should be 11.2.0.3 or higher.