8.240 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 |
---|---|---|
|
|
The fast-start failover observer name |
|
|
Indicates if this observer is registered ( |
|
|
The name of the host where this observer is running |
|
|
Indicates if this observer is the master observer ( |
|
|
Shows when this observer became master observer, if
|
|
|
Possible values:
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 |
|
|
Possible values:
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 |
|
|
Full path to the observer log file |
|
|
Full path to the observer runtime data file |
|
|
The ID of the container to which the data pertains. Possible values include:
|
Footnote 1 This column is available starting with Oracle Database 21c.