https://oracle-base.com/articles/12c/multitenant-migrate-non-cdb-to-pdb-12cr1#using-replication
A- false (The DBMS_PDB package allows you to generate an XML metadata file from a non-CDB 12c database)
E - false (The 12.1.0.2 patchset introduced the ability to create a PDB as a clone of a remote non-CDB)
C - true ( If the non-CDB is pre-11.2.0.3, then you can still consider using transportable tablespaces)
D - true (use a replication product like Golden Gate)
F - true (If the non-CDB is version 11.2.0.3 onward, you can consider using Transport Database)
An excerpt from the official "Oracle Database 19c: Multitenant Architecture" - Student Guide
D108654GC10. p91/340:
"It is appropriate to use Oracle Data Pump when:
- The source database is an 11g database.
...
Use either
C: transportable tablespace (TTS)
or
B: full conventional export / import
or
(not F): full transportable database (TDB) --> provided that in the last one any user-defined object resides in a single user-defined tablespace <--.
...
(continuing on the post above)
A: --> In other cases, using the DBMS_PDB package is the easiest option <--. The DBMS_PDB package constructs an XML file describing the non-CDB data files to plug the non-CDB into the CDB as a PDB. It is also a good way to quickly consolidate several non-CDBs into a CDB.
(Also available, but probably too much fuss)
D: If the DBMS_PDB package cannot be used as this would be the case because the non-CDB is an 11g database, export/import is usually simpler than using GoldenGate replication, but export/import might require more down time during the switch from the non-CDB to the PDB."
There is no mention of a time factor, so I would skip using Golden Gate; likewise, it's an entirely different product, probably unavailable or unfamiliar to an an everyday admin.
This is the absolutely first line of the relevant text, sorry for my omission of properly putting it on top:
"There are different possible methods to migrate data from a non-CDB database into a CDB."
BCF looks correct for me.
D is wrong - I think Oracle GoldenGate is a comprehensive software package for real-time data integration and replication.
Plus, I don't see exam asking to study about GoldenGate topic
E is wrong - Not for 11g.
The CDB and the non-CDB must be running Oracle Database 12c Release 1 (12.1.0.2) or later.
Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-1D7528E6-3893-46A6-8AC5-0E99794D9875:~:text=The%20CDB%20and%20the%20non%2DCDB%20must%20be%20running%20Oracle%20Database%2012c%20Release%201%20(12.1.0.2)%20or%20later.
A. FALSE, DBMS_PDB package creates XML file and check compatibility.
https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrade-scenarios-non-cdb-oracle-databases.html#GUID-FEB1F7ED-33EA-4582-8861-52B18BC74A61
B. TRUE, can use DATA PUMP.
https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/migrating-data-after-upgrade-oracle.html#GUID-F0E5FE65-14A1-4621-BA54-4239B84A1CBC
C. TRUE, didn't find any limitation for 11g (as long as it's 11.2 or above otherwise false).
https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/transporting-data.html#GUID-C8044A0E-B870-4F21-8D46-5CE5EFE7F0D9
D. TRUE, Should work according to documentation.
E. FALSE, The CDB and the non-CDB must be running Oracle Database 12c Release 1 (12.1.0.2) or later.
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-1D7528E6-3893-46A6-8AC5-0E99794D9875
F. TRUE, not mentioned in limitations.
https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/transporting-data.html#GUID-28800719-6CB9-4A71-95DD-4B61AA603173
here BCF is documented: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-11g-12c.html#GUID-EF2C50EB-191F-4A93-A623-749025B41642
I think D is true also, https://www.oracle.com/cn/a/tech/docs/technical-resources/zero-downtime-database-upgrades-using-oracle-goldengate-august2015.pdf
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
dmees
Highly Voted 1 year, 11 months agozenai
Most Recent 2 months agoacesonly
7 months, 3 weeks agoacesonly
7 months, 3 weeks agoacesonly
7 months, 3 weeks agoantonica
9 months, 2 weeks agosan_six
11 months, 2 weeks agodancymonkey
12 months agozouve
1 year, 3 months agomusafir
1 year, 4 months agomusafir
1 year, 4 months agoJuv07
1 year, 5 months ago_gio_
1 year, 6 months agoTrololoshko
1 year, 11 months agoilputto
1 year, 12 months agohilaire
2 years agohilaire
2 years ago