{"id":2358,"date":"2026-02-20T19:48:01","date_gmt":"2026-02-20T17:48:01","guid":{"rendered":"https:\/\/www.ludovicocaldara.net\/dba\/?p=2358"},"modified":"2026-02-20T19:48:01","modified_gmt":"2026-02-20T17:48:01","slug":"dg26ai-tempfile-creation","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/dg26ai-tempfile-creation\/","title":{"rendered":"Data Guard 26ai &#8211; #17: Automatic standby tempfile creation"},"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\">Adding tempfiles in a Data Guard configuration has always been tricky. In 19c or lower, adding a tempfile doesn&#8217;t automatically create it on the standby database because tempfile operations (including creation) don&#8217;t generate redo. As a result, the standby doesn&#8217;t notice the change.<\/p>\n<p dir=\"auto\">To work around this, you had to manually add the tempfile on the standby by opening the standby PDB in read-only mode\u2014after stopping redo if you didn&#8217;t have an Active Data Guard license. Mohamadou explained this workaround in detail:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/dataguard-environment-and-database-tempfiles\/\" target=\"_blank\" rel=\"nofollow noopener\">https:\/\/www.dbi-services.com\/blog\/dataguard-environment-and-database-tempfiles\/<\/a><\/p>\n<p dir=\"auto\">In release 26ai, the process is finally automatic\u2014if you use Oracle-Managed Files (OMF) and set standby_file_management to auto. The system now writes a new redo marker whenever a tempfile is added, ensuring automatic creation on the standby.<\/p>\n<p dir=\"auto\"><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-tempfile-creation-scaled.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2359\" src=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-tempfile-creation-1024x490.png\" alt=\"with automatic standby_file_management and OMF, tempfiles are now created automatically during recovery and at database open.\" width=\"584\" height=\"279\" srcset=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-tempfile-creation-1024x490.png 1024w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-tempfile-creation-300x144.png 300w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-tempfile-creation-768x368.png 768w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-tempfile-creation-1536x736.png 1536w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-tempfile-creation-2048x981.png 2048w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2026\/01\/dg26ai-tempfile-creation-500x239.png 500w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/a><\/p>\n<p dir=\"auto\">My colleague Sinan also covered this topic here:<br \/>\n<a href=\"https:\/\/database-heartbeat.com\/2023\/09\/26\/temp-file-dg\/\" target=\"_blank\" rel=\"nofollow noopener\">https:\/\/database-heartbeat.com\/2023\/09\/26\/temp-file-dg\/<\/a><\/p>\n<p dir=\"auto\">\n","protected":false},"excerpt":{"rendered":"<p>In 26ai, tempfiles are now auto-created on standby with OMF and standby_file_management=auto, fixing a long-standing Data Guard manual step. <a href=\"https:\/\/www.ludovicocaldara.net\/dba\/dg26ai-tempfile-creation\/\">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-2358","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\/2358","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=2358"}],"version-history":[{"count":2,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2358\/revisions"}],"predecessor-version":[{"id":2431,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2358\/revisions\/2431"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=2358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=2358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=2358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}