Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)
A.
creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
B.
creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
C.
creating a new empty PDB in the local database from PDB$SEED
D.
creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
E.
automatically dropping the database link to the remote database if it already exists
F.
creating a database link from CDB$ROOT in the remote database to the PDB in the local database
Tested in lab. If the database link already exists the operation will fail with:
[FATAL] [DBT-19405] Database link (database_link_name) is already exists.
BEG, but A should be also OK,when you read the documentation:
"The database link connects from the local CDB to either to the root of the remote CDB or to the remote source PDB."
F is Incorrect - from oracle doc
Prerequisites for the Database Link
The following prerequisites must be met:
A database link must enable a connection from the destination CDB (the CDB to which the PDB is being cloned) to the PDB in the source CDB.
source is remote and destination is local
From the following reference, we can know the answer should be AEG or BEG.
Combine with other comments, I believe it is BEG.
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-13FF2CE2-532C-4816-8E88-7A5A6E16A279
About Cloning a Remote PDB
When the source is a PDB is in a remote CDB, you must use a database link to clone the PDB into the local CDB.
The database link must exist in the local CDB (not the remote CDB). When you issue the CREATE PLUGGABLE DATABASE statement from the root of the local CDB, you must specify a database link to the remote CDB that contains the PDB being cloned in the FROM clause. The database link connects from the local CDB to either to the root of the remote CDB or to the remote source PDB.
The following figure illustrates how this technique creates a new PDB when the source PDB is remote.
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-32AE49B1-13A7-4A4D-AB43-BA781ECA99D6
E is FALSE. This is the error that occurs if the database link already exists:
[FATAL] [DBT-19405] Database link (RCAT_CLON_CLONE_LINK) is already exists.
If the clone process fails after create database link, you have to manually delete this database link in the local CDB$ROOT to try again.
... But in Oracle docs. 19c and Learnig Subscription curses, all says "Checks the presence of the database link. If the database link exists, DBCA drops it.". Then, E is true for exam (That reality does not destroy your hope...)
Sorry, my bad. I change my answer to EFG
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-05702CEB-A43C-452C-8081-4CA68DDA8007
upvoted 2 times
...
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
RinD
Highly Voted 3 years, 2 months agoantonica
Most Recent 3 months, 3 weeks agopiontk
9 months, 3 weeks ago_gio_
1 year agovkra
1 year, 4 months agoKushal22
1 year, 6 months agohkshado
2 years, 10 months agoABAJ
3 years, 1 month agoRogazan
3 years, 1 month agoRogazan
3 years, 1 month agoObserverPL
3 years, 1 month agodunhill
3 years, 2 months agossseee
3 years, 1 month agoAlvinzzz
2 years, 1 month agodunhill
3 years, 1 month ago