A-E are correct:
"Duplicates the specified PDBs in the CDB. Use a comma-delimited list to duplicate multiple PDBs."
"When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the seed database (PDB$SEED)."
The reasons why the other answers are wrong are also found here:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV760
A. True
B. False: "can" be done; and not "must" be done...
C. False: it is started, and not it is created. Creation is manual.
D. False: must login into CBD, and not PDB.
E. True
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-duplicating-databases.html#GUID-539E89F6-C0BC-49CB-8D8C-CD8FF88BAF32 According to last link: BC
A: NO=> Only one PDB can be duplicated at a time.
B: SI => Partial PDB duplication is not supported, only complete PDB duplication is supported. For example, you cannot include or exclude specific tablespaces while duplicating a PDB.
C: SI => You must create the auxiliary instance as a CDB. To do so, start the instance with the following declaration in the initialization parameter file: enable_pluggable_database=TRUE
D: NO => You must log in to the root of the CDB as a user who is granted the SYSDBA or SYSBACKUP privilege
E:NO => Only If I duplicate a CDB
You can select multiple PDBs to duplicate as single rman command according to this: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-duplicating-databases.html#GUID-571FD3C7-BF5A-4CF4-970A-9F8CAC3DF1F1
So A is true
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/DUPLICATE.html#GUID-E13D8A02-80F9-49A2-9C31-92DD3A795CE4
C is tricky: the auxiliary instance cannot be CREATED automatically. Auxiliary must be started in nomount with enable_pluggable_database=TRUE
BE are correct:
Duplicating a PDB to an existing CDB is subject to certain restrictions.
Only active database duplication is supported.
Only the following clauses of the DUPLICATE command are supported: NORESUME, DB_FILE_NAME_CONVERT, SECTION SIZE, and USING COMPRESSED BACKUPSET.
The following clauses of the DUPLICATE command are not supported: SPFILE, NO STANDBY, FARSYNC STANDBY, and LOG_FILE_NAME_CONVERT.
Duplicating a PDB to a CDB that is a standby database is not supported.
Only one PDB can be duplicated at a time.
Partial PDB duplication is not supported, only complete PDB duplication is supported. For example, you cannot include or exclude specific tablespaces while duplicating a PDB.
Duplicating a non-CDB as a PDB in an existing CDB is not supported.
Duplicating PDBs that contain TDE-encrypted tablespaces is not supported.
A & C
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-duplicating-databases.html#GUID-8AEC7767-8572-435C-9320-8B589CA4F224
A. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB. WRONG
C. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
D. A user with SYSDBA or SYSBKUP must use RMAN logged in to a PDB in order to duplicate it. WRONG you must to connect to the CDB$ROOT not to the CDB
E. CDB$ROOT and PDB$SEED are automatically duplicated if a PDB is duplicated. WRONG - if you duplicate into an existing PDB
I think is E wrong, if you duplicate the database to an existing CDB, CDB$ROOT and PDB$SEED are not duplicated.
And I think D is correct, you need SYSDBA or SYSBACKUP privileges to backup with RMAN
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-duplicating-databases.html#GUID-F31F9FCE-B610-49EB-B9DB-44B9AA4E838F
From your own link, this is a quote that proves that E must be correct:
"When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the CDB seed (PDB$SEED). The resulting duplicate database is a fully functional CDB that contains the root, the CDB seed, and the duplicated PDBs."
Agree - A and E are correct according to the official Oracle documentation.
upvoted 3 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.
SimoneF
Highly Voted 3 years, 9 months agowiprooracle
Highly Voted 3 years, 7 months agoauwia
Most Recent 7 months, 2 weeks agoYennism
1 year, 1 month agoKuraudio
1 year agokaka321
1 year, 6 months ago_gio_
1 year, 8 months agoNonicknameavailable
1 year, 11 months agovkra
1 year, 11 months agoMartinDBA2
2 years, 8 months agoantjvr
3 years, 5 months agomarpayer
3 years, 5 months agomarpayer
3 years, 5 months agoauwia
7 months, 2 weeks agomarpayer
3 years, 8 months agoxRodge
3 years, 6 months agoObserverPL
3 years, 8 months ago