{"id":4217,"date":"2025-06-15T09:11:43","date_gmt":"2025-06-15T09:11:43","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&#038;p=4217"},"modified":"2026-09-26T13:08:10","modified_gmt":"2026-09-26T07:38:10","slug":"starting-shutting-down-a-physical-standby-database","status":"publish","type":"post","link":"https:\/\/w3buddy.com\/blog\/starting-shutting-down-a-physical-standby-database\/","title":{"rendered":"Starting &amp; Shutting Down a Physical Standby Database"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Use the <code>STARTUP<\/code> command from SQL*Plus.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 <code>STARTUP<\/code> alone will <strong>mount and open<\/strong> the standby in <strong>read-only mode<\/strong><\/li>\n\n\n\n<li>\u2705 Once mounted or opened, it\u2019s ready to receive <strong>redo data from the primary<\/strong><\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code><code>-- Basic startup (read-only mode)\nSTARTUP;\n\n-- To mount only (for redo apply)\nSTARTUP MOUNT;<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udcdd <strong>Note<\/strong>:<br>If Redo Apply is started <strong>before<\/strong> the standby has received any redo from the primary, you may see:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>ORA-01112: media recovery not started<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This just means redo hasn&#8217;t arrived yet. Wait for it or register logs manually.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\uded1 <strong>Shutting Down a Physical Standby Database<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Use the <code>SHUTDOWN<\/code> command from SQL*Plus.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>SHUTDOWN;<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u23f3 The session waits until shutdown is complete.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udccc <strong>Best Practice<\/strong>:<br>Before shutting down:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Defer<\/strong> the standby destination on the primary<\/li>\n\n\n\n<li>Perform a <strong>log switch<\/strong> to avoid transmission issues<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Use the STARTUP command from SQL*Plus. \ud83d\udcdd Note:If Redo Apply is started before the standby has received any redo from the primary, you may see: This just means redo hasn&#8217;t arrived yet. Wait for it or register logs manually. \ud83d\uded1 Shutting Down a Physical Standby Database Use the SHUTDOWN command from SQL*Plus. \u23f3 The session [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowu461DA:productID":"","footnotes":""},"categories":[988,1225],"tags":[],"class_list":["post-4217","post","type-post","status-publish","format-standard","hentry","category-data-guard","category-database"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/4217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/comments?post=4217"}],"version-history":[{"count":1,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/4217\/revisions"}],"predecessor-version":[{"id":4218,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/4217\/revisions\/4218"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=4217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=4217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/tags?post=4217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}