Which two methods can be used to add an Oracle 11g database to a multitenant container
database (CDB) as a pluggable database (PDB)?
A.
Use the d3MS_pdb package to plug the Oracle 11g database into the existing CDB as a
PDB.
B.
Use the create database … enable pluggable database statement to create a PDB by
copying data files from pd3Sseed and use data pump to load data from the Oracle 11g
database into the newly created PDB.
C.
Pre-create a PDB in CDB and use data pump to load data from the complete database
export of the Oracle 11g database into the newly created PDB.
D.
Pre-create a PDB in CDB and use the network_link and parallel parameters with data
pump import to import data from the Oracle 11g database to the newly created PDB.
E.
Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe
procedure to plug the database as a new PDB into the CDB.
B y E is fine
Answer: C,E
“create database … enable pluggable database statement” use for create CDB not PDB
Hi Siegfried,
Why not D ?… network_link is another possible way to migrate to 12c.
E is correct. which is next method?
for option C :If your database is 11.2.0.3 you can take the 11.2.0.3 database and plug into 12c using DataPump transportable but note this does not mean you are plugging in as a 11g database it is basically and export / import
D,E this time I would not go with Siegfried (exceptionally).
as techie says 11.2.0.3 is a prerequite and in C it’s mentionend ‘complete database export’ where in D it’s Import data
D, E
A is not a right answer
A multitenant multitenant container database (CDB) is an Oracle database that includes zero, one, or many user-created pluggable databases (PDBs). The DBMS_PDB package provides an interface to examine and manipulate data about pluggable databases.
https://docs.oracle.com/database/121/ARPLS/d_pdb.htm#ARPLS73529
C is better choice than B. So C,E
C, E check the link someone tried the option C.. E is for sure..
http://db12c.blogspot.co.uk/2013/07/provision-cross-platform-pluggable.html
what’s wrong with D?
https://docs.oracle.com/database/121/UPGRD/expimp.htm#UPGRD52674
You can use the Data Pump Import utility with a database link to perform a full database import from a source database to a destination database without intermediate dump files. This method is an alternative to the procedure in “Migrating Data With Data Pump When Upgrading Oracle Database”
D,E
D,E
A wrong
docs: “You can easily plug an Oracle Database 12c non-CDB into a CDB”
But i haven’t found reference for pluging 11g into 12c CDB.
B wrong
As Siegfred said – given command is used for creating CDB
C wrong
As Techie said- this not basic import/export
BUT datapump transportable tablespaces OR transportable database have to be used.
http://db12c.blogspot.co.uk/2013/07/provision-cross-platform-pluggable.html
D right
https://oracle-base.com/articles/12c/multitenant-migrate-non-cdb-to-pdb-12cr1
E right
https://blogs.oracle.com/RobinAntony/entry/how_to_migrate_an_existing
A wrong
The package DBMS_PDB is not used to PLUG database on PDB.
B wrong
The command ‘create database … enable pluggable database’ is used when in creation of CDB.
C Right
It is possible to use data pump to export and import a database to a PDB (transportable database).
D Right
It is possible to user data pump to transport database using a network_link between databases.
E Wrong
The DBMS_PDB.DESCRIBE procedure is used to make a XML from database, not to plug the database on a PDB.
Then .. CD
DE