Q: 5
Examine the Data Guard configuration after an accidental switchover to Sheep:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
sheep - Primary database
dogs - Logical standby database
cats - Physical standby database (disabled)
ORA-16795: the standby database needs to be re-created
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three statements will be true after a switchover to Dogs?
Options
Discussion
Its B, C, D. Sheep becomes logical standby and stays enabled, Dogs is the new primary, and Cats stays disabled unless manually enabled because of ORA-16795. Not totally sure on C but that's usually how it works with logical standbys.
C or D, but B too fits. After switchover, Dogs becomes primary (D), Sheep swaps to logical standby and usually stays enabled (C), while Cats can't be enabled automatically because of ORA-16795 so B also correct. Unless I'm missing a catch here, that's how I've seen it work.
D imo. Dogs becomes primary after the switchover, so D fits. Pretty sure C too, since Sheep turns into the logical standby and usually stays enabled unless specifically noted otherwise. B is right because cats needs manual effort due to ORA-16795. Not 100% on C but that's what similar exam reports show.
Probably B, C, D. Saw a similar question in an exam report.
B C D, saw similar on a practice test and these matched up.
I don't see how A works here since Sheep isn't disabled after switchover, that's the trick. C and D check out because Sheep becomes logical standby (and stays enabled), Dogs is new primary, and B fits for Cats since ORA-16795 means still manual enable. So B, C, D.
D C, B tbh. A's a trap because after switchover Sheep isn't disabled, just flips to logical standby and stays enabled. Cats still needs manual enable due to ORA-16795. Seen similar in practice exams, anyone disagree?
If "enabled" just means Sheep can act as logical standby after the switchover, does that actually line up with how DGMGRL reports things? Or would Sheep be in a different state (like needing manual enable too)? Curious what people have seen in practice with this wording.
My vote is B, C, D are right for this one. C is the trap because "enabled logical standby" just means Sheep flips to that role, not that it's disabled. Cats stays disabled due to ORA-16795 (need manual intervention before it can join). Feel free to disagree if I missed something.
B. C, D
Be respectful. No spam.
