Upgrade Oracle DBA 11g to Oracle Database 12c — Question 38

RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1

FROM ACTIVE DATABASE -

NOFILENAMECHECK -

PASSWORD FILE -
SPFILE;
Which two statements are true about the execution of the duplicate command?

Answer options

• A. All archive redo log files are automatically copied to the duplicate database.
• B. The duplicate database has the same directory structure as the source database.
• C. The duplicate database is created by using the backups created during the execution of
• D. the duplicate command.
• E. The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.
• F. The duplicate database is created without using RMAN backups and prod: is allowed to remain open during duplication.

Correct answer: A, F

Explanation

Option A is correct because all archive redo log files are indeed copied to the new duplicate database when creating it from an active database. Option F is also correct as the duplicate process can proceed without RMAN backups and allows the source database to remain operational. The other options are incorrect because they either misstate how the directory structure is handled or the use of backups, or they incorrectly describe the creation of the password file and SPFILE.