Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 9

Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment?

Answer options

• A. Backups of data files taken on the primary database may be restored on a physical standby database.
• B. Backups of control files taken on the primary database may not be restored and used on a physical standby database.
• C. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database.
• D. Backups of control files taken on a physical standby database may be restored on the primary database.
• E. Backups of data files taken on a physical standby database may be restored on a primary database.
• F. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.

Correct answer: C, E, F

Explanation

The correct answers are C, E, and F because SPFILEs from a physical standby cannot be restored to the primary (C), data files from a physical standby can be restored to the primary (E), and SPFILEs from the primary cannot be used on a physical standby (F). Options A, B, and D are incorrect as they misrepresent the restoration capabilities of primary and standby databases in a Data Guard configuration.