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

You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment.
Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database?

Answer options

• A. Connect to the primary database as the AUXILIARY.
• B. Catalog the data file copy for RMAN to use on the primary database for restore.
• C. Back up the data file as copy on the standby host to a location on the standby host.
• D. Switch to the data file copy using the RMAN SWITCH command.
• E. Back up the data file as copy on the standby host to a location on the primary host.
• F. Connect to the primary database as the TARGET.

Correct answer: A, B, D

Explanation

The correct actions involve connecting as AUXILIARY, cataloging the backup, and switching to the data file copy using RMAN. Options C and E are incorrect because they describe backing up the data file rather than the required recovery steps on the primary database. Option F is also not valid since the connection should be as AUXILIARY, not TARGET.