Exam 1z0-066 topic 1 question 73 discussion

Actual exam question from Oracle's 1z0-066

Question #: 73
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: BE 🗳️
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

by marpayer at May 5, 2021, 10:17 a.m.

Comments

Submit Cancel

ScottL

1 year, 3 months ago

D and E true A: False - observer is running - Observer: 015.example.com B: False FastStartFailoverAutoReinstate= FALSE C: Unsure - but D and E true D: True - ObserverReconnect= 10 - E: True - FastStartFailoverAutoReinstate= FALSE

upvoted 1 times

...

JESUSBB

2 years, 5 months ago

Answer: D y E

upvoted 1 times

...

marpayer

3 years, 9 months ago

I believe is D because Observer Reconnect: 10 seconds - and E

upvoted 2 times

...

marpayer

3 years, 9 months ago

Auto-reinstate: FALSE - B is wrong

upvoted 1 times

...

Exam 1z0-066 All Questions

View all questions & answers for the 1z0-066 exam

Exam 1z0-066 topic 1 question 73 discussion

Comments

ScottL

JESUSBB

marpayer

marpayer

SY0-701