{"id":2454,"date":"2026-04-02T15:01:14","date_gmt":"2026-04-02T13:01:14","guid":{"rendered":"https:\/\/www.ludovicocaldara.net\/dba\/?p=2454"},"modified":"2026-04-02T15:01:14","modified_gmt":"2026-04-02T13:01:14","slug":"dg26ai-fsfo-config-view","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/dg26ai-fsfo-config-view\/","title":{"rendered":"Data Guard 26ai \u2013 #25: New view V$FAST_START_FAILOVER_CONFIG"},"content":{"rendered":"<p><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/dg-26ai-series\/\">This post is part of a blog series.<\/a><\/p>\n<p>I hope you&#8217;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 <a href=\"https:\/\/www.ludovicocaldara.net\/dba\/dg26ai-v-dg-broker-property\/\">fixed view for broker properties<\/a>, a similar enhancement is available for Fast-Start Failover (FSFO).<\/p>\n<p>Before 26ai, if you wanted to inspect Fast-Start Failover settings, you had to rely on <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/26\/dgbkr\/show-fast_start-failover.html\">the broker command<\/a>:<\/p>\n<pre class=\"lang:plsql highlight:0 decode:true\">DGMGRL&gt; show fast_start failover;<\/pre>\n<p>Starting with Oracle 26ai, you can now query the new fixed view <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/26\/refrn\/V-FAST_START_FAILOVER_CONFIG.html\">V$FAST_START_FAILOVER_CONFIG<\/a> that exposes FSFO configuration details.<\/p>\n<pre class=\"lang:plsql decode:true\">SELECT * FROM V$FAST_START_FAILOVER_CONFIG;<\/pre>\n<p>This provides direct access to FSFO configuration using standard SQL, making automation and observability much simpler.<\/p>\n<p><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/04\/dg26ai-fsfo-config-view-scaled.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2456\" src=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/04\/dg26ai-fsfo-config-view-1024x569.png\" alt=\"Slide showing the new view columns\" width=\"584\" height=\"325\" srcset=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/04\/dg26ai-fsfo-config-view-1024x569.png 1024w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/04\/dg26ai-fsfo-config-view-300x167.png 300w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/04\/dg26ai-fsfo-config-view-768x427.png 768w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/04\/dg26ai-fsfo-config-view-1536x853.png 1536w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/04\/dg26ai-fsfo-config-view-2048x1138.png 2048w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/04\/dg26ai-fsfo-config-view-500x278.png 500w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/a><\/p>\n<h2>Deprecation of V$DATABASE.FS_FAILOVER_* Columns<\/h2>\n<p>Some FSFO-related information was historically exposed via columns in <strong>V$DATABASE<\/strong>, such as:<\/p>\n<ul data-spread=\"false\">\n<li>FS_FAILOVER_MODE<\/li>\n<li>FS_FAILOVER_STATUS<\/li>\n<li>FS_FAILOVER_CURRENT_TARGET<\/li>\n<li>FS_FAILOVER_THRESHOLD<\/li>\n<li>FS_FAILOVER_OBSERVER_PRESENT<\/li>\n<li>FS_FAILOVER_OBSERVER_HOST<\/li>\n<\/ul>\n<p>This information doesn&#8217;t really belong there.<\/p>\n<p>In Oracle 26ai, these columns are <strong>deprecated<\/strong> and will be <strong>desupported in a future release<\/strong>.<\/p>\n<p>If you are currently relying on these columns, you should transition to the new view.<\/p>\n<p>Here is how the deprecated V$DATABASE columns map to the new V$FAST_START_FAILOVER_CONFIG view:<\/p>\n<table>\n<tbody>\n<tr>\n<th>V$DATABASE<\/th>\n<th>V$FAST_START_FAILOVER_CONFIG<\/th>\n<\/tr>\n<tr>\n<td>FS_FAILOVER_MODE<\/td>\n<td>FAST_START_FAILOVER_MODE<\/td>\n<\/tr>\n<tr>\n<td>FS_FAILOVER_STATUS<\/td>\n<td>STATUS<\/td>\n<\/tr>\n<tr>\n<td>FS_FAILOVER_CURRENT_TARGET<\/td>\n<td>CURRENT_TARGET<\/td>\n<\/tr>\n<tr>\n<td>FS_FAILOVER_THRESHOLD<\/td>\n<td>THRESHOLD<\/td>\n<\/tr>\n<tr>\n<td>FS_FAILOVER_OBSERVER_PRESENT<\/td>\n<td>OBSERVER_PRESENT<\/td>\n<\/tr>\n<tr>\n<td>FS_FAILOVER_OBSERVER_HOST<\/td>\n<td>OBSERVER_HOST<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>V$FAST_START_FAILOVER also include these additional columns:<\/p>\n<ul data-spread=\"false\">\n<li>PING_INTERVAL<\/li>\n<li>PING_RETRY<\/li>\n<li>PROTECTION_MODE<\/li>\n<li>LAG_LIMIT<\/li>\n<li>AUTO_REINSTATE<\/li>\n<li>OBSERVER_RECONNECT<\/li>\n<li>OBSERVER_OVERRIDE<\/li>\n<li>SHUTDOWN_PRIMARY<\/li>\n<li>LAG_TYPE<\/li>\n<li>LAG_GRACE_TIME<\/li>\n<\/ul>\n<p>Once again, a 26ai feature that improves configuration and automation of Data Guard environments.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Query the Fast-Start Failover configuration directly using the new view V$FAST_START_FAILOVER_CONFIG in 26ai: a simple SQL instead of running DGMGRL. <a href=\"https:\/\/www.ludovicocaldara.net\/dba\/dg26ai-fsfo-config-view\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[375,329],"tags":[],"class_list":["post-2454","post","type-post","status-publish","format-standard","hentry","category-oracle-ai-database-26ai","category-oracle-dg"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2454","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/comments?post=2454"}],"version-history":[{"count":2,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2454\/revisions"}],"predecessor-version":[{"id":2458,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2454\/revisions\/2458"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=2454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=2454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=2454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}