Which three will be true after a successful failover to…

Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration –Animals
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
cats- Snapshot standby database
sheep- Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-01034: ORACLE not available
ORA-16625: cannot reach database “dogs”
DGM-17017: unable to determine configuration status
Which three will be true after a successful failover to Cats?

Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration –Animals
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
cats- Snapshot standby database
sheep- Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-01034: ORACLE not available
ORA-16625: cannot reach database “dogs”
DGM-17017: unable to determine configuration status
Which three will be true after a successful failover to Cats?

A.
Sheep will be in the disabled state.

B.
Sheep will be in the enabled state.

C.
Dogs will be in the disabled state and has to be manually reinstated.

D.
The configuration will be in Maximum Performance mode.

E.
The configuration will be in Maximum Availability mode.

Explanation:
Incorrect Answers:
E: Because the Maximum Protection data mode prioritizes data protection over primary database availability,
Oracle recommends that a minimum of two standby databases be used to protect a primary database that runs
in maximum protection mode to prevent a single standby database failure from causing the primary database
to shut down.
https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm



Leave a Reply 3

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


Chunn

Chunn

Correct Ans: B, C, E

It will still maintain MaxAvailability mode and I have tested this.

Chunn

Chunn

DGMGRL> show configuration;

Configuration – Animals

Protection Mode: MaxAvailability
Members:
dogs – Primary database
Error: ORA-01034: ORACLE not available

sheep – Snapshot standby database
cats – Snapshot standby database

Fast-Start Failover: DISABLED

Configuration Status:
ERROR (status updated 0 seconds ago)

DGMGRL> failover to cats;
Converting database “cats” to a Physical Standby database, please wait…
Operation requires shut down of instance “cats” on database “cats”
Shutting down instance “cats”…
Database closed.
Database dismounted.
ORACLE instance shut down.
Operation requires start up of instance “cats” on database “cats”
Starting instance “cats”…
ORACLE instance started.
Database mounted.
Continuing to convert database “cats” …
Database “cats” converted successfully
Performing failover NOW, please wait…
Failover succeeded, new primary is “cats”

DGMGRL> show configuration

Configuration – Animals

Protection Mode: MaxAvailability
Members:
cats – Primary database
dogs – Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated

sheep – Snapshot standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 35 seconds ago)