You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB.
User-defined objects are stored in several tablespaces in the non-CDB.
Which three methods can you use? (Choose three.)
You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB.
User-defined objects are stored in several tablespaces in the non-CDB.
Which three methods can you use? (Choose three.)
When migrating a non-CDB Oracle 11g database to a CDB without performing an initial upgrade, three valid methods can be used. First, using Data Pump for a full database export and import is appropriate because it can handle the migration of data between different versions without requiring the source non-CDB to be upgraded beforehand. Second, Data Pump transportable tablespaces is another valid method, allowing the user-defined objects stored in several tablespaces in the non-CDB to be migrated effectively. Finally, the Data Pump full transportable database approach is also suitable for this task. This method combines aspects of both export/import and transportable tablespaces and can handle databases from version 11.2.0.3 onwards. These methods ensure that user-defined objects are correctly migrated to the CDB environment.
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)
CDF - is correct
I think BCD
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.
BCF OK
ADE i think
sorry BDE
AE is not correct, because it requires 12c; in my opinion BCDF are all corrects
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. 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
BCF voted wrong, D is correct I think
CDF for me
BCF, but D is posible
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."