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

Examine this command executed on a physical standby database to transition it to a logical standby database:

SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;

Which statement is true regarding the execution of this command?

Answer options

• A. FLASHBACK is automatically enabled when transitioning to the logical standby database.
• B. The Managed Recovery Process (MRPO) continues applying redo up to the SCN immediately preceding the redo corresponding to the LogMiner dictionary build.
• C. Supplemental logging will be enabled on the logical standby database when the physical database is transitioned to the logical standby database.
• D. SQL apply is automatically started when transitioning to the logical standby database.
• E. It will automatically start redo apply.

Correct answer: B

Explanation

The correct answer is B because during the transition to a logical standby, the Managed Recovery Process continues until just before the LogMiner dictionary build. Options A, C, D, and E are incorrect as they do not accurately describe the behavior of the database during this specific transition process.