This post is part of a blog series.
I hope you’ve caught the pattern from previous posts: with Oracle AI Database 26ai we made a big effort in improving the management of Data Guard configurations directly from SQL. Similar to the fixed view for broker properties, a similar enhancement is available for Fast-Start Failover (FSFO).
Before 26ai, if you wanted to inspect Fast-Start Failover settings, you had to rely on the broker command:
|
1 |
DGMGRL> show fast_start failover; |
Starting with Oracle 26ai, you can now query the new fixed view V$FAST_START_FAILOVER_CONFIG that exposes FSFO configuration details.
|
1 |
SELECT * FROM V$FAST_START_FAILOVER_CONFIG; |
This provides direct access to FSFO configuration using standard SQL, making automation and observability much simpler.
Deprecation of V$DATABASE.FS_FAILOVER_* Columns
Some FSFO-related information was historically exposed via columns in V$DATABASE, such as:
- FS_FAILOVER_MODE
- FS_FAILOVER_STATUS
- FS_FAILOVER_CURRENT_TARGET
- FS_FAILOVER_THRESHOLD
- FS_FAILOVER_OBSERVER_PRESENT
- FS_FAILOVER_OBSERVER_HOST
This information doesn’t really belong there.
In Oracle 26ai, these columns are deprecated and will be desupported in a future release.
If you are currently relying on these columns, you should transition to the new view.
Here is how the deprecated V$DATABASE columns map to the new V$FAST_START_FAILOVER_CONFIG view:
| V$DATABASE | V$FAST_START_FAILOVER_CONFIG |
|---|---|
| FS_FAILOVER_MODE | FAST_START_FAILOVER_MODE |
| FS_FAILOVER_STATUS | STATUS |
| FS_FAILOVER_CURRENT_TARGET | CURRENT_TARGET |
| FS_FAILOVER_THRESHOLD | THRESHOLD |
| FS_FAILOVER_OBSERVER_PRESENT | OBSERVER_PRESENT |
| FS_FAILOVER_OBSERVER_HOST | OBSERVER_HOST |
V$FAST_START_FAILOVER also include these additional columns:
- PING_INTERVAL
- PING_RETRY
- PROTECTION_MODE
- LAG_LIMIT
- AUTO_REINSTATE
- OBSERVER_RECONNECT
- OBSERVER_OVERRIDE
- SHUTDOWN_PRIMARY
- LAG_TYPE
- LAG_GRACE_TIME
Once again, a 26ai feature that improves configuration and automation of Data Guard environments.
Latest posts by Ludovico (see all)
- Data Guard 26ai – #25: New view V$FAST_START_FAILOVER_CONFIG - April 2, 2026
- Data Guard 26ai – #24: Validate DGConnectIdentifier - March 13, 2026
- Data Guard 26ai – #23: New view V$DG_BROKER_PROPERTY - March 9, 2026