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

Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?

Answer options

• A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
• B. backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered
• C. backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
• D. backups of data files taken on the logical standby database, if not connected to a recovery catalog
• E. backups of control files taken on the logical standby database if not connected to a recovery catalog

Correct answer: A, D, E

Explanation

The correct answers are A, D, and E because they represent valid backup scenarios for restoring a logical standby database. Option A is correct as it involves backups from the primary database connected to the recovery catalog. Options D and E are valid as they pertain to backups taken on the logical standby database without a recovery catalog. Options B and C are not suitable as they either involve backups from the standby database, which is not applicable, or control files from the primary, which do not meet the criteria.