FastStartFailoverThreshold

The FastStartFailoverThreshold configuration property defines the number of seconds the master observer attempts to reconnect to the primary database before initiating a fast-start failover.

Category Description

Broker default

30 seconds

Configuration Type

Data Guard only

Datatype

Integer

Property Type

Configurable

Scope

Configuration

Valid Role

Target standby database that is about to fail over to the primary role

Valid value

Integral number of seconds. Must be greater than, or equal to, 6.

(If there is only one observer, then by default it is considered the master. The time interval starts when the observer first loses connection with the primary database. If the observer is unable to regain a connection to the primary database within the specified time, then the observer initiates a fast-start failover to the target standby database. See Task 4 in Enabling Fast-Start Failover for more information about setting this property.

The observer ignores the threshold completely if a configurable fast-start failover condition is detected or an application has requested that fast-start failover be initiated.

For help in determining an appropriate value for this property, you can use the information provided in the V$FS_OBSERVER_HISTOGRAM view. This view displays statistics that are based on the frequency of successful pings between the observer and primary database for different time intervals. See Oracle Database Reference for a description of the V$FS_OBSERVER_HISTOGRAM view.