{"id":2377,"date":"2026-03-02T22:44:54","date_gmt":"2026-03-02T20:44:54","guid":{"rendered":"https:\/\/www.ludovicocaldara.net\/dba\/?p=2377"},"modified":"2026-03-02T22:45:16","modified_gmt":"2026-03-02T20:45:16","slug":"dg26ai-history-of-role-transitions","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/dg26ai-history-of-role-transitions\/","title":{"rendered":"Data Guard 26ai – #22: History of role transitions"},"content":{"rendered":"

This post is part of a blog series.<\/a><\/p>\n

Data Guard 26ai introduces a new fixed view, V$DG_BROKER_ROLE_CHANGE<\/a>, which tracks the last ten role transitions for a configuration. This view gathers information dynamically from the broker configuration file, logging both automatic and manual failovers (with reasons), switchovers, and each operation\u2019s start and end times. We plan to add recovery point SCN details in a future Release Update, but this isn\u2019t available yet.<\/p>\n

\"a<\/a><\/p>\n

This <\/span>view <\/span>makes <\/span>it <\/span>easy <\/span>to <\/span>see <\/span>recent <\/span>role <\/span>changes <\/span>without <\/span>searching <\/span>through <\/span>alert <\/span>logs. <\/span>It <\/span>also <\/span>helps <\/span>identify what was the primary database<\/span>\u00a0<\/span>at <\/span>any <\/span>given <\/span>moment. <\/span>The <\/span>view <\/span>stores <\/span>only <\/span>the <\/span>ten <\/span>most <\/span>recent <\/span>role <\/span>changes; <\/span>to <\/span>keep <\/span>a <\/span>longer <\/span>history, <\/span>you <\/span>can <\/span>copy <\/span>its <\/span>records <\/span>into <\/span>a <\/span>regular <\/span>table; for <\/span>example, <\/span>using <\/span>a <\/span>STARTUP <\/span>trigger <\/span>on <\/span>the <\/span>primary <\/span>database.<\/span><\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

V$DG_BROKER_ROLE_CHANGE in Data Guard 26ai tracks the last 10 role changes, making it easy to review transitions without reading alert logs. Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[375,329],"tags":[],"class_list":["post-2377","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\/2377","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=2377"}],"version-history":[{"count":3,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2377\/revisions"}],"predecessor-version":[{"id":2443,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2377\/revisions\/2443"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=2377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=2377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=2377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}