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

Examine the Data Guard configuration:

Properties:
FastStartFailoverThreshold = ‘30’
OperationTimeout = ‘30’
TraceLevel = ‘USER’
FastStartFailoverLagLimit = ‘30’
CommunicationTimeout = ‘180’
ObserverReconnect = ‘10’
FastStartFailoverAutReinstate = ‘TRUE’
FastStartFailoverPmyShutdown = ‘TRUE’
BystandersFollowRoleChange = ‘all’
ObserverOverride = ‘FALSE’

Fast-Start Failover: ENABLED -

Threshold: 30 seconds -

Target: dogs -

Observer: prutser6.example.com -
Lag Limit: 30 seconds (not in use)

Shutdown Primary: TRUE -

Auto-reinstate: TRUE -

Observer Reconnect: 10 seconds -
Observer Override:
Configuration Status:

SUCCESS -

What happens if you issue “failover to dogs;” at the DGMGRL prompt while connected to Dogs?

Answer options

• A. The failover succeeds, Sheep becomes the new target standby database, and Cats is automatically reinstated.
• B. The failover succeeds and Cats is automatically reinstated.
• C. The failover succeeds and Cats is left running.
• D. The failover succeeds and Cats is terminated.
• E. It results in an error indicating that a failover is not allowed.

Correct answer: D

Explanation

The correct answer is D because the configuration specifies that the primary database (Cats) is set to shut down during a failover operation. Options A, B, and C incorrectly state that Cats will either be reinstated or left running, which contradicts the settings. Option E is also incorrect as a failover is permissible in this context.