Which two must be true when you migrate an Oracle Database 12.1.0.2 non-CDB to a database that is running in a Database as a Service (DBaaS) instance on
Oracle Cloud by using the Remote Cloning method?
A.
The non-CDB may be opened in READ WRITE mode as long as ARCHIVELOG is enabled.
B.
The database link owner must have the CREATE PDB system privilege.
C.
The source platform must have the same endian format.
D.
The non-CDB must be in archivelog mode.
E.
The non-CDB must be opened in READ ONLY mode.
F.
The database link owner must have the CREATE PLUGGABLE DB system privilege.
Explanation:
To migrate an Oracle Database 12c non-CDB database to a Database Cloud Service database deployment using the remote cloning method, you perform these
tasks:
1. On the on-premises database host, invoke SQL*Plus and set the on-premises database to READ ONLY mode.
2. On the Database Cloud Service compute node, invoke SQL*Plus and create a database link that enables a connection to the on-premises database.
3. On the Database Cloud Service compute node, execute the CREATE PLUGGABLE DATABASEcommand to clone the on-premises non-CDB database.
4. On the Database Cloud Service compute node, execute the $ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql script.
5. On the Database Cloud Service compute node, open the new PDB by executing the ALTER PLUGGABLE DATABASE OPEN command.
6. Optionally, on the on-premises database host invoke SQL*Plus and set the on-premises database back to READ WRITE mode.
You can use this method only if the on-premises platform is little endian, the on-premises database release is 12.1.0.2 or higher, and the on-premises database and
Database Cloud Service database have compatible database character sets and national character sets.
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-remote-cloning-non-cdb.html
I would say C and E
Me too its C&E
I think C and E are correct too
All C.E and F are correct.
https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#GUID-D4900E43-DF38-4629-9A1F-D1C11EC8EC8F
The following prerequisites must be met:
Complete the prerequisites described in “Preparing for PDBs”.
The current user must have the CREATE PLUGGABLE DATABASE system privilege in the root of the CDB that will contain the target PDB.
The source PDB or source non-CDB must be in open read-only mode.
A database link must enable a connection from the CDB that will contain the target PDB to the remote source. If the source is a remote PDB, then the database link can connect to either the root of the remote CDB or to the remote source PDB.
The user that the database link connects with at the remote source must have the CREATE PLUGGABLE DATABASE system privilege in the source PDB or in the non-CDB
The correct syntax for the privilege is CREATE PLUGGABLE DATABASE and not
CREATE PLUGGABLE DB…so C and E
C,E