V$FS_FAILOVER_STATS

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

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

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

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 AI Database 26ai. 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.