Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration –Animals
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
sheep- (*) Physical standby databasecats- 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.
Explanation:
Incorrect Answers:
E: NOT ALLOWED – Either this is a standby database and the primary database has not been switched first, or
this is a primary database and there are no standby databases.
Ans: D
DGMGRL> show configuration;
Configuration – Animals
Protection Mode: MaxAvailability
Members:
dogs – Primary database
sheep – (*) Physical standby database
cats – Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS (status updated 11 seconds ago)
DGMGRL> switchover to sheep;
Performing switchover NOW, please wait…
Operation requires a connection to instance “sheep” on database “sheep”
Connecting to instance “sheep”…
Connected as SYSDBA.
New primary database “sheep” is opening…
Operation requires start up of instance “dogs” on database “dogs”
Starting instance “dogs”…
ORACLE instance started.
Database mounted.
Switchover succeeded, new primary is “sheep”
DGMGRL> show configuration;
Configuration – Animals
Protection Mode: MaxAvailability
Members:
sheep – Primary database
dogs – (*) Physical standby database
cats – Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS (status updated 42 seconds ago)
D