OCP CBT Question 487

Please solve the following question.

You have a non-CDB database named `LEGACYDB` running on Oracle Database 19c. You want to migrate it into a new PDB within an existing CDB, `CDB01`. You have already performed the necessary `DBMS_PDB.CHECK_PLUG_COMPATIBILITY` checks and ensured compatibility. Which sequence of steps is correct to create a new PDB from `LEGACYDB`?

Source Database (LEGACYDB) `sql SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE OPEN READ ONLY;` ## Target CDB (CDB01) `sql -- Assume CDB01 is open and in READ WRITE mode`

sql -- On LEGACYDB ALTER DATABASE PACKAGE; -- On CDB01 CREATE PLUGGABLE DATABASE new_pdb_from_legacy USING '/path/to/pdb_package.xml' COPY; ALTER PLUGGABLE DATABASE new_pdb_from_legacy OPEN;

sql -- On LEGACYDB CREATE PLUGGABLE DATABASE new_pdb_from_legacy FROM NON$CDB; -- On CDB01 ALTER PLUGGABLE DATABASE new_pdb_from_legacy OPEN;

sql -- On LEGACYDB ALTER DATABASE CONVERT TO PLUGGABLE DATABASE; -- On CDB01 CREATE PLUGGABLE DATABASE new_pdb_from_legacy FROM LEGACYDB; ALTER PLUGGABLE DATABASE new_pdb_from_legacy OPEN;

sql -- On LEGACYDB ALTER DATABASE CREATE PLUGGABLE DATABASE new_pdb_from_legacy; -- On CDB01 CREATE PLUGGABLE DATABASE new_pdb_from_legacy FROM NON$CDB;

Source Database (LEGACYDB) sql SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE OPEN READ ONLY; ## Target CDB (CDB01) sql -- Assume CDB01 is open and in READ WRITE mode

Source Database (LEGACYDB) `sql SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE OPEN READ ONLY;` ## Target CDB (CDB01) `sql -- Assume CDB01 is open and in READ WRITE mode`