V$FS_FAILOVER

8.251 V$FS_FAILOVER_STATS

V$FS_FAILOVER_STATS displays statistics about fast-start failovers occurring on the system.

Column Datatype Description

Column	Datatype	Description
`LAST_FAILOVER_TIME`	`VARCHAR2(20)`	Timestamp of the last fast-start failover
`LAST_FAILOVER_REASON`	`VARCHAR2(255)`	Reason for the last fast-start failover
`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

LAST_FAILOVER_TIME

VARCHAR2(20)

Timestamp of the last fast-start failover

LAST_FAILOVER_REASON

VARCHAR2(255)

Reason for the last fast-start failover

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 deprecated in Oracle Database 23ai. Oracle recommends that you instead use the V$DG_BROKER_ROLE_CHANGE view. V$FS_FAILOVER_STATS displays one row with limited information about the most recent fast-start failover. The data is available in the primary database only, and is not persisted across database restarts. V$DG_BROKER_ROLE_CHANGE contains detailed information about the ten most recent role changes, including switchover, failover, and reinstate, across the Data Guard broker configuration, and provides richer information than V$FS_FAILOVER_STATS. See "V$DG_BROKER_ROLE_CHANGE" for more information.