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?
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.
Explanation:
You can reenable the standby database or reset the primary database state to ONLINE to fix the inconsistencies.https://docs.oracle.com/cd/B19306_01/server.102/b14230/cli.htm
Database “Reinstate” is possible only if Flashback Database is enabled on that database – which is not mentioned in question text.
Under assumption “Flashback Database” is not enabled, correct answer would be to re-create “prodsby”.
No need to reinstate primary database.
Absolutly. In fact, link posted points to 10gR2 doc… gamesmanship?
B is correct. The question starts with ‘After converting your physical standby database to a logical database’. PRDSBY was in the configuration as physical, and later converted. As such, you have to remove the physical member and at it again as logical.
A is not possible, no replacement option available
C: reinstate recreates the databases, which you just converted to logical
D: reinstate a primary is not possible by definition
B is correct
Here the database is configured for Data Guard Broker and CONVERT DATABASE command can be only used to convert to SNAPSHOT STANDBY or PHYSICAL STANDBY.
Syntax:
CONVERT DATABASE TO
{ SNAPSHOT STANDBY | PHYSICAL STANDBY };
Converting Physical standby to Logical standby was done outside the Broker and I think Standby Database Metadata is still pointing to physical standby. In order to address this from DBMGRL you may perform the following steps:
DGMGRL> remove database PRODSBY preserve destinations;
DGMGRL> add database PRODSBY as connect identifier is PRODSBY;
DGMGRL> enable database PRODSBY;
DGMGRL> show configuration
http://blog.yannickjaquier.com/oracle/data-guard-hands-on-with-a-logical-standby-database-creation.html