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 will be true after a switchover to Dogs?
A.
Sheep will be a disabled logical standby database.
B.
Sheep will be an enabled logical standby database.
C.
Cats will be a disabled physical standby database that can be manually enabled.
D.
Cats will be an enabled physical standby database.
E.
Dogs will be the primary database.
tested on my environment:
oracle@primserver:~$ dgmgrl /
DGMGRL for Linux: Version 11.2.0.4.0 – 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type “help” for information.
Connected.
DGMGRL> show configuration;
Configuration – config2
Protection Mode: MaxAvailability
Databases:
prim – Primary database
stdby1 – Physical standby database (disabled)
ORA-16795: the standby database needs to be re-created
stdby2 – Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> switchover to stdby2;
Performing switchover NOW, please wait…
Switchover succeeded, new primary is “stdby2”
DGMGRL>
DGMGRL> show configuration;
Configuration – config2
Protection Mode: MaxAvailability
Databases:
stdby2 – Primary database
prim – Logical standby database
stdby1 – Physical standby database (disabled)
ORA-16795: the standby database needs to be re-created
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
BCE is correct!
Thanks for testing !
B,C,E