Examine the command to duplicate a database:
RMAN> DUPLICATE TARGET DATABASE TO cdb
PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command?
A.
The SPFILE is copied along with the data files of the pluggable databases (PDBs). The
root and the seed database in the container database (CDB) are also duplicated.
B.
A backup of pdbi and pd35 must exist before executing the command.
C.
The duplicate command first creates a backup, and then duplicates the PDBs by using the
D.
backup.
E.
An auxiliary instance must be started with the initialization parameter
ENABLE_PLUGGABLE_DATABASE set to TRUE.
if correct answers, coalesce C and D, and E become D than answer will be B,D
AE
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV645
A and E are indeed correct!
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV760
Well done Steve!!
Can you confirm Vonpire?
Thanks!
E confirm.
https://docs.oracle.com/database/121/REFRN/GUID-2265FE97-8696-48FA-A041-422BC008C3C4.htm#REFRN10338
Not sure others.
Do backups of the source database exist?
The principal advantage of active database duplication is that it does not require source database backups. Active duplication copies mounted or online database files over a network to the auxiliary instance. One disadvantage of this technique is the negative performance effect on the network. Another disadvantage is that the source database is running processes required to transfer the files to the auxiliary host, thereby affecting the source database and production workload.
If the source database backups exist, and if the effect on the network is unacceptable, then backup-based duplication may be a better option. You can copy backups to temporary storage and transfer them manually to the destination host. If duplication is made with a connection to the target or the recovery catalog, then the backup files on the destination host must have the same file specification as they had on the source host. Otherwise, this is not a requirement.
B and E is correct!
A is here
To duplicate PDBs, you must create the auxiliary instance as a CDB. To do so, start the instance with the declaration enable_pluggable_database=TRUE in the initialization parameter file. When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the seed database (PDB$SEED). The resulting duplicate database is a fully functional CDB that contains the root, the seed database, and the duplicated PDBs.Table 25-1 describes the options that you can use to duplicate PDBs or tablespaces within PDBs.
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV760
NOT A. It is not active duplicate. So a backup of source database is needed.
For me the answer is BE
It has correct D answer:
D. The root and the seed database in the container database (CDB) are also duplicated.
I mean the real D answer.
BE
BE
When duplicating a whole CDB or one more PDBs:
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
AE
https://docs.oracle.com/cd/E49329_01/backup.121/b71297/rcmdupdb.htm#BGBJIFCH
https://docs.oracle.com/cd/E49329_01/backup.121/b71297/rcmdupdb.htm#BGBJIFCH
BE
AE
Because:
To duplicate PDBs, you must create the auxiliary instance as a CDB. To do so, start the instance with the declaration enable_pluggable_database=TRUE in the initialization parameter file. When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the seed database (PDB$SEED). The resulting duplicate database is a fully functional CDB that contains the root, the seed database, and the duplicated PDBs.Table 25-1 describes the options that you can use to duplicate PDBs or tablespaces within PDBs.
E is correct with no doubt.
A is not correct, because the SPFILE will not be copied!!! the SPFILE Option is NOT specified in the command!
B is correct becuase FROM ACTIVE DATABASE is not specified, so it is a backup-based Duplication.
AB correct
Sorry, I mean BE is correct.
I confirm BE is correct
BE
good work Sinasian 🙂
the question has wrong order for answers, answers should be as follow
A.The SPFILE is copied along with the data files of the pluggable databases (PDBs).
B. The root and the seed database in the container database (CDB) are also duplicated.
C.A backup of pdb1 and pdb5 must exist before executing the command.
D.The duplicate command first creates a backup, and then duplicates the PDBs by using the backup
E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
I think best answer is B and E
A and C may be wrong because not only PDB is copied , CDB and seed also copied and should be in the backup
[email protected]
BE