Home » Oracle » 1z0-066 » Which two are true?
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?
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: BE
Explanation/Reference:
B: . If fast-start failover is enabled, the observer will automatically reinstate the standby databases after failover has completed.
E: FastStartFailoverAutoReinstate= ‘FALSE’ means that the former primary database will not be reinstated automatically after a failover,
Note: The FastStartFailoverAutoReinstate configuration property causes the former primary database to be automatically reinstated if a fast-start failover was initiated because the primary database was either isolated or had crashed. To prevent automatic reinstatement of the former primary database in these cases, set this configuration property to FALSE.
The observer is the third party in an otherwise typical primary/standby Data Guard configuration. Only the observer can initiate FSFO failover. It’s secondary job is to automatically reinstate a failed primary as a standby if that feature is enabled (the default).
Incorrect Answers:
A: The observer is running.
B: Sheep is neither the primary database, nor the failover target.
D: By default, the observer will initiate failover to the target standby if and only if ALL of the following are true:
* observer is running
* observer and the standby both lose contact with the primary
Note: if the observer loses contact with the primary, but the standby does not, the observer can determine that the primary is still up via the standby.
* observer is still in contact with the standby
* durability constraints are met
* failover threshold timeout has elapsed
References:
http://www.oracle.com/technetwork/articles/smiley-fsfo-084973.html
https://docs.oracle.com/cd/E11882_01/server.112/e40771/dbpropref.htm
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
DE