Oracle
1Z0-062 · Question #35
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…
The correct answer is B. Transportable tablespace. 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)…
Moving Data
Question
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?
Options
- ATransportable database
- BTransportable tablespace
- CData Pump full export/import
- DThe DBMS_PDB package
- ERMAN
How the community answered
(46 responses)- A17% (8)
- B70% (32)
- C2% (1)
- D7% (3)
- E4% (2)
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.
Topics
#PDB migration#Non-CDB to PDB#Transportable tablespace#Downtime minimization
Community Discussion
No community discussion yet for this question.