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 theCREATE PDBsystem 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 theCREATE PLUGGABLE DBsystem 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:
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/migremote-cloning-non-cdb.html
C, E
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-remote-cloning-non-cdb.html
C, E
C,E
C,E
EF the answer C is wrong because is only little endian, You can use this method only if the on-premises platform is little endian.
Agree with you. E and F are the correct answers.
C,E are correct. E command itself is wrong. It should be CREATE PLUGGABLE DATABASE not CREATE PLUGGABLE DB. Correct if I am wrong.
C,E are correct.
From documentation:
You can use this method only if the on-premises platform is little endian, the onpremises 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.
You can use the remote cloning method to copy an Oracle Database 12c non-CDB onpremises database to a PDB in an Oracle Database 12c database on Oracle
Database Cloud Service.
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 DATABASE command 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 onpremises database back to READ WRITE mode.