{"id":2364,"date":"2026-02-25T19:19:16","date_gmt":"2026-02-25T17:19:16","guid":{"rendered":"https:\/\/www.ludovicocaldara.net\/dba\/?p=2364"},"modified":"2026-03-03T19:35:25","modified_gmt":"2026-03-03T17:35:25","slug":"dg26ai-simplified-awr","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/dg26ai-simplified-awr\/","title":{"rendered":"Data Guard 26ai &#8211; #19: Easy AWR snapshots on the standby"},"content":{"rendered":"<p dir=\"auto\"><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/dg-26ai-series\/\">This post is part of a blog series.<\/a><\/p>\n<p dir=\"auto\">With release 26ai, generating AWR reports from Active Data Guard standby databases is now simple and direct, without extra configuration required.<\/p>\n<p dir=\"auto\">Previously, starting in version 12c Release 2, you had to set up DB links and use the Remote Management Framework (RMF) with the DBMS_UMF package to let the primary database collect remote AWR snapshots from standby databases. This process, documented in MOS note <a href=\"https:\/\/support.oracle.com\/support\/?kmContentId=2409808&amp;page=sptemplate&amp;sptemplate=km-article\">2409808.1 How to Generate AWRs in Active Data Guard Standby Databases<\/a> (now KB140685), was complex and could lead to non-working state, especially after failovers.<\/p>\n<p dir=\"auto\">Now, you can generate reports right on the standby database.<br \/>\nUnder the hood, the procedure exports the snapshot to a dump file, transfers it internally to the primary host using Data Guard communication, and imports it on the primary database. All of this is transparent.<\/p>\n<p dir=\"auto\"><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-awr-scaled.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2365\" src=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-awr-1024x308.png\" alt=\"You can AWR snapshots on the standby using the same DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT command as the primary.\" width=\"584\" height=\"176\" srcset=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-awr-1024x308.png 1024w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-awr-300x90.png 300w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-awr-768x231.png 768w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-awr-1536x463.png 1536w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-awr-2048x617.png 2048w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-awr-500x151.png 500w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Generate AWR reports directly on Active Data Guard standby databases in 26ai\u2014no extra setup needed. Snapshots are auto-imported for easy reporting. <a href=\"https:\/\/www.ludovicocaldara.net\/dba\/dg26ai-simplified-awr\/\">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":{"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-2364","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\/2364","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=2364"}],"version-history":[{"count":4,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2364\/revisions"}],"predecessor-version":[{"id":2446,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2364\/revisions\/2446"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=2364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=2364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=2364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}