Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration –Animals
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
cats- Snapshot standby database
sheep- Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-01034: ORACLE not available
ORA-16625: cannot reach database “dogs”
DGM-17017: unable to determine configuration status
Which three will be true after a successful failover to Cats?
A.
Sheep will be in the disabled state.
B.
Sheep will be in the enabled state.
C.
Dogs will be in the disabled state and has to be manually reinstated.
D.
The configuration will be in Maximum Performance mode.
E.
The configuration will be in Maximum Availability mode.
Explanation:
Incorrect Answers:
E: Because the Maximum Protection data mode prioritizes data protection over primary database availability,
Oracle recommends that a minimum of two standby databases be used to protect a primary database that runs
in maximum protection mode to prevent a single standby database failure from causing the primary database
to shut down.
https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm
Correct Ans: B, C, E
It will still maintain MaxAvailability mode and I have tested this.
DGMGRL> show configuration;
Configuration – Animals
Protection Mode: MaxAvailability
Members:
dogs – Primary database
Error: ORA-01034: ORACLE not available
sheep – Snapshot standby database
cats – Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR (status updated 0 seconds ago)
DGMGRL> failover to cats;
Converting database “cats” to a Physical Standby database, please wait…
Operation requires shut down of instance “cats” on database “cats”
Shutting down instance “cats”…
Database closed.
Database dismounted.
ORACLE instance shut down.
Operation requires start up of instance “cats” on database “cats”
Starting instance “cats”…
ORACLE instance started.
Database mounted.
Continuing to convert database “cats” …
Database “cats” converted successfully
Performing failover NOW, please wait…
Failover succeeded, new primary is “cats”
DGMGRL> show configuration
Configuration – Animals
Protection Mode: MaxAvailability
Members:
cats – Primary database
dogs – Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
sheep – Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 35 seconds ago)
B,C,E