{"id":2343,"date":"2026-02-13T15:28:11","date_gmt":"2026-02-13T13:28:11","guid":{"rendered":"https:\/\/www.ludovicocaldara.net\/dba\/?p=2343"},"modified":"2026-02-13T15:28:11","modified_gmt":"2026-02-13T13:28:11","slug":"dg-26ai-show-edit-all","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/dg-26ai-show-edit-all\/","title":{"rendered":"Data Guard 26ai &#8211; #13: Show \/ edit all members at once"},"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\">Before 26ai, updating properties or parameters across many members in a Data Guard configuration was a multi-step process. You had to run a separate command for each member, changing the DB unique name in each of them, and issuing the command for every one. Similarly, verification required running \u201cshow database\u201d for each member.<\/p>\n<p dir=\"auto\">Before 26ai:<\/p>\n<div class=\"my-2\">\n<pre class=\"lang:plsql highlight:0 decode:true\">DGMGRL&gt; show database mydb_site1 logxptmode\r\nLogXptMode = 'ASYNC'\r\n\r\nDGMGRL&gt; show database mydb_site2 logxptmode\r\nLogXptMode = 'ASYNC'\r\n\r\nDGMGRL&gt; show database mydb_site3 logxptmode\r\nLogXptMode = 'ASYNC'\r\n\r\nDGMGRL&gt; show database mydb_site4 logxptmode\r\nLogXptMode = 'ASYNC'\r\n\r\n\r\nDGMGRL&gt; edit database mydb_site1 set property logxptmode=sync;\r\nProperty \"logxptmode\" updated for member \"mydb_site1\".\r\n\r\nDGMGRL&gt; edit database mydb_site2 set property logxptmode=sync;\r\nProperty \"logxptmode\" updated for member \"mydb_site2\".\r\n\r\nDGMGRL&gt; edit database mydb_site3 set property logxptmode=sync;\r\nProperty \"logxptmode\" updated for member \"mydb_site3\".\r\n\r\nDGMGRL&gt; edit database mydb_site4 set property logxptmode=sync;\r\nProperty \"logxptmode\" updated for member \"mydb_site4\".<\/pre>\n<p>Now, 26ai offers new commands that let you display or edit properties or parameters for all members at once.<\/p>\n<\/div>\n<pre class=\"lang:plsql highlight:0 decode:true\">DGMGRL&gt; show all members logxptmode\r\nmydb_site1: logxptmode = 'ASYNC'\r\nmydb_site2: logxptmode = 'ASYNC'\r\nmydb_site3: logxptmode = 'ASYNC'\r\nmydb_site4: logxptmode = 'ASYNC'\r\n\r\nDGMGRL&gt; EDIT ALL MEMBERS SET PROPERTY logxptmode ='SYNC';\r\nProperty \"logxptmode\" updated for member \"mydb_site1\".\r\nProperty \"logxptmode\" updated for member \"mydb_site2\".\r\nProperty \"logxptmode\" updated for member \"mydb_site3\".\r\nProperty \"logxptmode\" updated for member \"mydb_site4\".<\/pre>\n<p><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-show-edit-all.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2344\" src=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-show-edit-all-1024x519.png\" alt=\"examples of SHOW ALL and EDIT ALL commands in DGMGRL\" width=\"584\" height=\"296\" srcset=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-show-edit-all-1024x519.png 1024w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-show-edit-all-300x152.png 300w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-show-edit-all-768x389.png 768w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-show-edit-all-1536x778.png 1536w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-show-edit-all-2048x1037.png 2048w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-show-edit-all-500x253.png 500w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/a><\/p>\n<p>Here&#8217;s the documentation for the new commands:<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/26\/dgbkr\/edit-all-members-reset-parameter.html\">EDIT ALL MEMBERS RESET (Parameter)<\/a><\/li>\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/26\/dgbkr\/edit-all-members-reset-property.html\">EDIT ALL MEMBERS RESET (Property)<\/a><\/li>\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/26\/dgbkr\/edit-all-members-set-parameter.html\">EDIT ALL MEMBERS SET (Parameter)<\/a><\/li>\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/26\/dgbkr\/edit-all-members-set-property.html\">EDIT ALL MEMBERS SET (Property)<\/a><\/li>\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/26\/dgbkr\/show-all-members-parameter.html\">SHOW ALL MEMBERS (Parameter)<\/a><\/li>\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/26\/dgbkr\/show-all-members-property.html\">SHOW ALL MEMBERS (Property)<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>26ai introduces new commands to edit or view properties for all Data Guard members at once, simplifying DGMGRL operations and monitoring. <a href=\"https:\/\/www.ludovicocaldara.net\/dba\/dg-26ai-show-edit-all\/\">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-2343","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\/2343","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=2343"}],"version-history":[{"count":2,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2343\/revisions"}],"predecessor-version":[{"id":2421,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2343\/revisions\/2421"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=2343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=2343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=2343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}