Home » Oracle » 1z0-062 v.2 » 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 11gRelease 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
Correct Answer: B
Explanation/Reference:
* 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 tocreate a cloned PDB in the CDB.
*Note that to plug in 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 tobe upgraded to 12c before they can be part of a 12c CDB.
Download Printable PDF. VALID exam to help you PASS.
|
|