What happens if you issue "switchover&quot…

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?

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 .



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Wim J

Wim J

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

JFK

JFK

Thanks for the effort! 🙂

JorgeZG

JorgeZG

I was doubting but with your test it made all clear.
D is corerct !!