Which three will be true after a switchover to Dogs?

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?

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.



Leave a Reply 3

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


Wim J

Wim J

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!

JorgeZG

JorgeZG

Thanks for testing !