Oracle教程

Oracle 视图 V$FS_FAILOVER_OBSERVERS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图V$FS_FAILOVER_OBSERVERS用于监视Oracle数据库中现有的失效检测服务器。它帮助用户确定当前正在激活的观察者及其信息。

V$FS_FAILOVER_OBSERVERS视图中有一些重要的列，其中包括：

• OBSERVER_NAME：用于识别观察者的唯一名称。
• OBSERVER_STATUS：它提供观察者的当前状态，有效的值是NORMAL、TIMEOUT或SUSPENDED。
• VERSION：观察者的版本。
• NEXT_CHECKPOINT：观察者下一个检查点的时间戳。
• LAST_CHECKPOINT：观察者上一个检查点的时间戳。

使用以下查询可以检索V$FS_FAILOVER_OBSERVERS视图的数据：

SELECT observer_name, observer_status, version,
next_checkpoint, last_checkpoint
FROM 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.

LOG_FILEFoot 1

VARCHAR2(513)

Full path to the observer log file

STATE_FILEFoot 1

VARCHAR2(513)

Full path to the observer runtime data file

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

Footnote 1 This column is available starting with Oracle Database 21c.


数据运维技术 » Oracle 视图 V$FS_FAILOVER_OBSERVERS 官方解释，作用，如何使用详细说明
分享到：

相关推荐