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.
RMAN

B.
The DBMS_PDB package

C.
Transportable database

D.
Data Pump full export/import

E.
Transportable tablespace



Leave a Reply 3

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


TheAnswer

TheAnswer

C – Transportable database is the correct answer.

B – Wrong as the database is 11.2.0.2

Ref: 12c New Features for Administrators

There are three possible methods to plug a non-CDB database into a CDB.
Whichever method is used, you have to get the non-CDB into a transactionally consistent
state and open it in restricted mode.
• Either use transportable tablespace (TTS) or full conventional export/import or
transportable database (TDB) provided that in the last one any user-defined object
resides in a single user-defined tablespace.
• Or use DBMS_PDB package to construct an XML file describing the non-CDB data files
to plug the non-CDB into the CDB as a PDB. This method presupposes that the non-
CDB is an Oracle 12c database.
• Or use replication with GoldenGate
Using the DBMS_PDB package is the easiest option.
If the DBMS_PDB package is not used, using export/import is usually simpler than using
GoldenGate replication, but export/import might require more downtime during the switch from
the non-CDB to the PDB.

****
If you choose to use export/import, and you are moving a whole non-CDB into the CDB,
transportable databases (TDB) is usually the best option.
****

If you choose to export and import
part of a non-CDB into a CDB, transportable tablespaces (TTS) is the best option.

Charles

Charles

Transportable database works when source is atleast 11.2.0.3. So the correct answer is E