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

After converting your physical standby database to a logical database, you get an error:

DGMGRL> show configuration -

Configuration- proddg -

Protection Mode: MaxPerformance -
Databases:
prod-Primary datatabse
prodsby-Physical standby database
Error: ORA-16810 multiple errors or warnings detected for database

Fast-Start Failover: DISABLED -
Configuration Status:

ERROR -
How can you rectify the error?

Answer options

• A. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.
• B. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.
• C. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.
• D. Reinstate both the primary and physical standby databases. The broker will automatically detect that PRODSBY is a logical standby update to the metadata.

Correct answer: D

Explanation

The correct answer is D because reinstating both databases allows the broker to automatically recognize PRODSBY as a logical standby, resolving the metadata issue. Options A and B are incorrect since they involve adding new databases instead of correcting the existing configuration. Option C suggests replacing the metadata incorrectly without addressing the primary database's reinstatement.