Oracle Database 12c: Advanced Administration — Question 30

Which two are prerequisites for creating a backup-based duplicate database?

Answer options

• A. connecting to the target database and a recovery catalog to execute the duplicate command
• B. creating a password file for an auxiliary instance
• C. connecting to an auxiliary instance
• D. matching the database identifier (DBID) of the source database and the duplicate database
• E. creating an SPFILE for the target database

Correct answer: A, B

Explanation

Options A and B are essential because you need to connect to the target database and have a recovery catalog to execute the duplicate command, as well as a password file for the auxiliary instance. Options C, D, and E are not prerequisites for creating a backup-based duplicate database, as they pertain to other configurations or requirements that do not directly impact the duplication process.