Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 33

Examine the Data Guard configuration:
DGMGRL> show configuration verbose;

Configuration Animals -

Protection Mode: MaxPerformance -
Databases:
cats- Primary database
dogs-(*) Physical standby database
sheep- Physical standby database
(*) Fast-Start Failover target
Properties:

FastStartFailoverThreshold = 30 -

OperationTimeout = 30 -

TraceLevel = USER -

FastStartFailoverLagLimit = 30 -

CommunicationTimeout= 180 -

ObserverReconnect= 10 -
FastStartFailoverAutoReinstate= FALSE
FastStartFailoverPmyShutdown= TRUE

BystanderFollowRoleChange= none -

ObserverOverride = FALSE -

Fast-Start Failover: ENABLED -

Threshold: 30 seconds -

Target: dogs -

Observer: 015.example.com -

Lag Limit: 30 seconds -

Shutdown Primary: TRUE -

Auto-reinstate: FALSE -

Observer Reconnect: 10 seconds -

Observer Override: TRUE -
Configuration Status:

SUCCESS -
Which two are true?

Answer options

• A. The observer must run on host ol5.example.com and is currently not running.
• B. The observer will reinstate Sheep automatically after a failover, if required.
• C. The observer will mark another standby database as the failover target if the original failover target becomes unavailable.
• D. The observer will detect if the primary database is unable to accept new connections.
• E. The former primary database will not be reinstated automatically after a failover.

Correct answer: B, E

Explanation

Option B is correct because the configuration indicates that automatic reinstatement is not enabled, meaning the observer will not reinstate Sheep without manual intervention. Option E is correct as it aligns with the configuration that specifies 'FastStartFailoverAutoReinstate= FALSE', indicating the former primary will not be reinstated automatically. The other options do not accurately reflect the provided configuration details.