nerdexam
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)
  • A
    17% (8)
  • B
    70% (32)
  • C
    2% (1)
  • D
    7% (3)
  • E
    4% (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.

Full 1Z0-062 Practice