Oracle Database 12c: Advanced Administration — Question 47

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

Statement A is correct because RMAN automatically copies all archive redo log files to ensure the duplicate database is consistent. Statement F is also correct, as the duplicate process can run without requiring RMAN backups, allowing the original database to remain operational. The other statements, while related to duplication, are not accurate in this context.