Oracle Database Administration II — Question 13

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

Answer options

• A. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
• B. A connection to an auxiliary instance is always required.
• C. A subset of the target database can be duplicated.
• D. A new DBID is always created for the duplicated database.
• E. A connection to the recovery catalog instance is always required.
• F. A backup of the target database is always required.
• G. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
• H. A connection to the target database instance is always required.

Correct answer: A, B, C, G

Explanation

The correct answers (A, B, C, G) accurately reflect the capabilities and requirements of RMAN for database duplication. A connection to the auxiliary instance is indeed required (B), and the auxiliary instance can pull backup sets (A) or receive copies pushed from the target instance (G). Options D, E, and F are incorrect as creating a new DBID is not mandatory, a recovery catalog connection is not always necessary, and a backup is not always required for duplication.