V$FS_FAILOVER_OBSERVERS

V$FS_FAILOVER_OBSERVERS provides information about fast-start failover observers.

If you are querying on the primary database, this view returns three rows, each describing one observer. However, only a row having an non-empty value in column NAME corresponds to a started observer. If you are querying on a non-primary database, the behavior of this view is not defined.

Column Datatype Description
NAME VARCHAR2(513) The fast-start failover observer name
REGISTERED VARCHAR2(4) Indicates if this observer is registered (YES) or not (NO). Note that the observer is registered only if HOST is not NULL.
HOST VARCHAR2(513) The name of the host where this observer is running
ISMASTER VARCHAR2(4) Indicates if this observer is the master observer (YES) or not (NO)
TIME_SELECTED TIMESTAMP(9)

Shows when this observer became master observer, if ISMASTER is YES; otherwise the following constant appears:

1990-01-01 00:00:00.00
PINGING_PRIMARY VARCHAR2(4)

Possible values:

  • YES: Observer is currently connected to the primary database

  • NO: Observer is not connected to the primary database

Note: This field is consistent throughout an Oracle Real Application Clusters (Oracle RAC) environment; that is, if the observer is connected to any instance of the primary database in the Oracle RAC environment, all instances will show a value of YES.

PINGING_TARGET VARCHAR2(4)

Possible values:

  • YES: Observer is currently connected to the target standby database

  • NO: Observer is not connected to the target standby database

Note: This field is consistent throughout an Oracle Real Application Clusters (Oracle RAC) environment; that is, if the observer is connected to any instance of the target standby database in the Oracle RAC environment, all instances will show a value of YES.

LAST_PING_PRIMARY NUMBER Amount of time (in seconds) since the observer last pinged the primary database
LAST_PING_TARGET NUMBER Amount of time (in seconds) since the observer last pinged the target standby database
LOG_FILE VARCHAR2(513) Full path to the observer log file
STATE_FILE VARCHAR2(513) Full path to the observer runtime data file
CURRENT_TIME TIMESTAMP(9) Date and time at which this view was queried
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