V$FAST_START_FAILOVER_CONFIG

V$FAST_START_FAILOVER_CONFIG displays configuration details about Oracle Data Guard fast-start failover.

Column Datatype Description
FAST_START_FAILOVER_MODE VARCHAR2(19)

Displays the current fast-start failover mode. Possible values are:

  • DISABLED - Fast-start failover is disabled.

  • OBSERVE-ONLY - Fast-start failover is enabled in test drive mode.

  • POTENTIAL DATA LOSS - Fast-start failover is enabled and a fast-start failover can incur data loss within FastStartFailoverLagLimit seconds.

  • ZERO DATA LOSS - Fast-start failover is enabled and a fast-start failover cannot incur any data loss.

STATUS VARCHAR2(22)

Fast-start failover status:

  • BYSTANDER

  • DISABLED

  • LOADING DICTIONARY

  • PRIMARY UNOBSERVED

  • REINSTATE FAILED

  • REINSTATE REQUIRED

  • STALLED

  • SUSPENDED

  • SYNCHRONIZED

  • TARGET OVER LAG LIMIT

  • TARGET UNDER LAG LIMIT

  • UNSYNCHRONIZED

See Also: Oracle Data Guard Broker Concepts for detailed descriptions of these values

Note: If the value of this column is DISABLED, then the values for the CURRENT_TARGET, THRESHOLD, OBSERVER_PRESENT, and OBSERVER_HOST columns in this table are not meaningful.

CURRENT_TARGET VARCHAR2(30) DB_UNIQUE_NAME of the standby that is the current fail-safe failover observer target standby for the Data Guard configuration
THRESHOLD NUMBER Time (in seconds) that the observer will attempt to reconnect with a disconnected primary before attempting fail-safe failover observer with the target standby
OBSERVER_PRESENT VARCHAR2(7)

Indicates whether the master observer is currently connected to the local database (YES) or not (NO)

Note: This column is consistent throughout an Oracle RAC environment; that is, if the observer is connected to any instance, then all instances will show a value of YES.

OBSERVER_HOST VARCHAR2(512) Machine name that is currently hosting the master observer process, if fast-start failover is enabled. If fast-start failover is not enabled, this column returns a NULL string.
PING_INTERVAL NUMBER

ObserverPingInterval value for the fast-start failover configuration

This value specifies how frequently the observer must ping the primary database (in milliseconds).

See Also: Oracle Data Guard Broker Concepts for more information about the ObserverPingInterval configuration property

PING_RETRY NUMBER

ObserverPingRetry value for the fast-start failover configuration

This value specifies the number of times that the observer retries a failed ping before it initiates a failover to the target standby database.

See Also: Oracle Data Guard Broker Concepts for more information about the ObserverPingRetry configuration property

PROTECTION_MODE VARCHAR2(120)

Protection mode for the fast-start failover configuration:

  • MAXAVAILABILITY

  • MAXPERFORMANCE

  • MAXPROTECTION

See Also: Oracle Data Guard Broker Concepts for more information about protection modes

LAG_LIMIT NUMBER

FastStartFailoverLagLimit value for the fast-start failover configuration

This value establishes an acceptable limit (in seconds) that the standby is allowed to fall behind the primary in terms of redo applied.

See Also: Oracle Data Guard Broker Concepts for more information about the FastStartFailoverLagLimit configuration property

AUTO_REINSTATE VARCHAR2(5)

FastStartFailoverAutoReinstate value (TRUE or FALSE) for the fast-start failover configuration

This value specifies whether the former primary database is to be automatically reinstated if a fast-start failover was initiated because the primary database was either isolated or had crashed.

See Also: Oracle Data Guard Broker Concepts for more information about the FastStartFailoverAutoReinstate configuration property

OBSERVER_RECONNECT NUMBER

ObserverReconnect value for the fast-start failover configuration

This value specifies how often (in seconds) the observer establishes a new connection to the primary database.

See Also: Oracle Data Guard Broker Concepts for more information about the ObserverReconnect configuration property

OBSERVER_OVERRIDE VARCHAR2(5)

ObserverOverride value (TRUE or FALSE) for the fast-start failover configuration

This value specifies whether an automatic failover is allowed to occur when the observer has lost connectivity to the primary.

See Also: Oracle Data Guard Broker Concepts for more information about the ObserverOverride configuration property

SHUTDOWN_PRIMARY VARCHAR2(5)

FastStartFailoverPmyShutdown value (TRUE or FALSE) for the fast-start failover configuration

This value specifies whether the primary database should shut down under certain conditions.

See Also: Oracle Data Guard Broker Concepts for more information about the FastStartFailoverPmyShutdown configuration property

LAG_TYPE VARCHAR2(4000)

FastStartFailoverLagType value (APPLY or TRANSPORT) for the fast-start failover configuration

This value specifies the type of lag (apply lag or transport lag) that is used to specify the data loss threshold.

See Also: Oracle Data Guard Broker Concepts for more information about the FastStartFailoverLagType configuration property

LAG_GRACE_TIME NUMBER

FastStartFailoverLagGraceTime value for the fast-start failover configuration

This value specifies the maximum amount of time (in seconds) that can pass before the lag limit (FastStartFailoverLagLimit) is reached when the primary database requests permission to move to the lagging state.

See Also: Oracle Data Guard Broker Concepts for more information about the FastStartFailoverLagGraceTime configuration property

CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Note: This view is available starting with Oracle AI Database 26ai.