Home » Oracle » 1z0-160 » 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?
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.
Correct Answer: EF
Explanation/Reference:
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.
References: https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-remote-cloning-non-cdb.html
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
