Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)
Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)
When duplicating pluggable databases (PDBs) with RMAN, multiple PDBs can be duplicated with the same RMAN DUPLICATE command. Additionally, if a PDB is duplicated, the root (CDB$ROOT) and the seed database (PDB$SEED) are automatically duplicated as part of the process. This ensures that the resulting duplicate database is a fully functional container database (CDB) that includes the root, the seed database, and the duplicated PDBs.
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 & E https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-duplicating-databases.html#GUID-68742310-3B60-4246-9431-6671697AB516
Question is incomplete, it should state that the duplication is in a new CDB. If that is the case then the correct answers are A&E
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
sorry C is wrong you must start the auxiliary instance
Start is automatic (with that parameter set to true) , creation is manual!
Agree - A and E are correct according to the official Oracle documentation.
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.
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."
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
AE absolutely right https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV760 just above table25-1
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
why are some of you referencing 12.1 manuals for a 19c exam ??
A + E is correct, read this https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV760