8.231 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 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 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 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 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 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 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 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 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 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 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 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 Database 23ai.