Examine the Data Guard configuration:
DGMGRL> show configuration Configuration -Animals
Protection Mode: MaxAvaiIabiIity Databases:
dogs- Primary database
sheep-(*) Physical standby database
cats- Physical standby database
Fast-Start Failover: ENABLED
Configuration Status: SUCCESS
What happens if you issue “switchover” to sheep;” at the DGMGRL prompt?
A.
The switchover succeeds but Dogs need to be reinstated
B.
The switchover succeeds but Fast-Start Failover is suspended.
C.
The switchover succeeds and Cats become the new failover target.
D.
The switchover succeeds and Dogs become the new failover target
E.
it results in an error indicating that a switchover is not allowed .
test in lab environment
Welcome to DGMGRL, type “help” for information.
Connected.
DGMGRL> show configuration
Configuration – config2
Protection Mode: MaxAvailability
Databases:
prim – Primary database
stdby1 – (*) Physical standby database
stdby2 – Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
DGMGRL> switchover to stdby1;
Performing switchover NOW, please wait…
New primary database “stdby1” is opening…
Operation requires startup of instance “PRIM” on database “prim”
Starting instance “PRIM”…
DGMGRL> show configuration;
Configuration – config2
Protection Mode: MaxAvailability
Databases:
stdby1 – Primary database
prim – (*) Physical standby database
stdby2 – Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
D is correct
Thanks for the effort! 🙂
I was doubting but with your test it made all clear.
D is corerct !!
D
D