Examine the Data Guard configuration:
Which three will be true after a switchover to Dogs?
A.
Sheep will be an enabled logical standby database.
B.
Cats will be an enabled physical standby database
C.
Dogs will be the primary database
D.
Sheep will be a disabled logical standby database
E.
Cats will be a disabled physical standby database
Hi,
In this question
dgmgrl > show configuration
configuration animal
protection mode maxavailability
databases
cats- primary database
dogs- physical standby database
sheep- logical standby database
fast start failover : disabled
configuration status
success
For me corrects answers are A,B,C
I did a test and below results
DGMGRL> show configuration;
Configuration – ORCL_DR
Protection Mode: MaxPerformance
Members:
ORCL_SITE – Primary database
ORCL_SITE1 – Physical standby database
ORCL_SITE2 – Physical standby database
ORCL_SITE3 – Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 6 seconds ago)
DGMGRL> switchover to ‘ORCL_SITE1’;
Performing switchover NOW, please wait…
Operation requires a connection to database “ORCL_SITE1”
Connecting …
Connected to “ORCL_SITE1”
Connected as SYSDBA.
New primary database “ORCL_SITE1” is opening…
Operation requires start up of instance “ORCL” on database “ORCL_SITE”
Starting instance “ORCL”…
ORACLE instance started.
Database mounted.
Database opened.
Connected to “ORCL_SITE”
Switchover succeeded, new primary is “ORCL_SITE1”
DGMGRL> show configuration;
Configuration – ORCL_DR
Protection Mode: MaxPerformance
Members:
ORCL_SITE1 – Primary database
ORCL_SITE – Physical standby database
ORCL_SITE2 – Physical standby database
ORCL_SITE3 – Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 71 seconds ago)
DGMGRL>
A B C
A, B, C
A, B and C