{"id":2330,"date":"2026-02-06T19:25:38","date_gmt":"2026-02-06T17:25:38","guid":{"rendered":"https:\/\/www.ludovicocaldara.net\/dba\/?p=2330"},"modified":"2026-02-06T19:25:38","modified_gmt":"2026-02-06T17:25:38","slug":"dg26ai-automatic-preparation","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/dg26ai-automatic-preparation\/","title":{"rendered":"Data Guard 26ai &#8211; #9: Automatic preparation of primary and standby"},"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&#8217;ve previously blogged about how in 26ai you can automatically prepare the primary database using DGMGRL&#8217;s command &#8220;<a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/26\/dgbkr\/oracle-data-guard-broker-commands.html#GUID-06786336-CBC8-46ED-9918-F41D970D0F3A\">PREPARE DATABASE FOR DATA GUARD<\/a>&#8220;; you can find the link <a title=\"New in Data Guard 21c and 23c: Automatic preparation of the primary\" href=\"https:\/\/www.ludovicocaldara.net\/dba\/prepare-database-for-data-guard\/\">here<\/a> for more details.<\/p>\n<p>Many Oracle ACEs and bloggers also blogged about it:<\/p>\n<ul>\n<li><a href=\"https:\/\/oracle-base.com\/articles\/21c\/data-guard-prepare-database-for-data-guard-21c\">https:\/\/oracle-base.com\/articles\/21c\/data-guard-prepare-database-for-data-guard-21c<\/a><\/li>\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/\">https:\/\/www.dbi-services.com\/blog\/oracle-20c-the-new-prepare-database-for-data-guard\/<\/a><\/li>\n<li><a href=\"https:\/\/gavinsoorma.com.au\/knowledge-base\/prepare-database-for-data-guard\/\">https:\/\/gavinsoorma.com.au\/knowledge-base\/prepare-database-for-data-guard\/<\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-prepare-database-scaled.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2331\" src=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-prepare-database-1024x486.png\" alt=\"the PREPARE DATABASE command prepares SPFILE, standby logs, force logging, flashback logging, and sets recommended parameters for primary and standby databases\" width=\"584\" height=\"277\" srcset=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-prepare-database-1024x486.png 1024w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-prepare-database-300x142.png 300w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-prepare-database-768x365.png 768w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-prepare-database-1536x729.png 1536w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-prepare-database-2048x972.png 2048w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-prepare-database-500x237.png 500w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/a><br \/>\nAs of version 23.26.0 (released October &#8217;25), the &#8220;<a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/26\/dgbkr\/oracle-data-guard-broker-commands.html#GUID-06786336-CBC8-46ED-9918-F41D970D0F3A\">PREPARE DATABASE FOR DATA GUARD<\/a>&#8221; command supports both primary and standby databases. While you&#8217;ll still need to create your standby database manually, the command now recognizes the role of the database and automatically sets recommended parameters, creates required components, and enforces the necessary settings for joining a Data Guard configuration.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Automatically configure both primary and standby databases in DGMGRL 26ai. <a href=\"https:\/\/www.ludovicocaldara.net\/dba\/dg26ai-automatic-preparation\/\">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-2330","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\/2330","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=2330"}],"version-history":[{"count":2,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2330\/revisions"}],"predecessor-version":[{"id":2411,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2330\/revisions\/2411"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=2330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=2330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=2330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}