{"id":4171,"date":"2020-12-06T23:59:35","date_gmt":"2020-12-07T05:59:35","guid":{"rendered":"http:\/\/www.aamirharoon.com\/?p=4171"},"modified":"2026-09-21T20:58:52","modified_gmt":"2026-09-22T01:58:52","slug":"upgrade-standby-database","status":"publish","type":"post","link":"https:\/\/www.aamirharoon.com\/?p=4171","title":{"rendered":"Upgrade Standby Database"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In this post, I am sharing my notes on upgrading an Oracle Standby database. The following are the steps I performed on the standby database while upgrading from 12.1 to 19.5, but these can be used for upgrading any standby database version.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I hope you find this helpful, and good luck with your upgrade. \ud83d\ude03<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">At a high level, you don&#8217;t upgrade the standby database. You just need to start it in mount state with 19.5 software. And if you have Data Guard Broker configured, then you need to disable it for the upgrade. The standby database will upgrade as it receives redo logs from the primary database.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">On Standby<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">On the standby database, copy the following files from the 12.1 Oracle home to 19.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>spfile<\/li>\n\n\n\n<li>password file<\/li>\n\n\n\n<li>Data Guard Broker files<\/li>\n\n\n\n<li>sqlnet.ora file<\/li>\n\n\n\n<li>tnsnames.ora file<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\ncp \/oracle\/product\/12.1.0\/dbhome_1\/dbs\/spfilestdby.ora \/oracle\/product\/19\/dbhome_1\/dbs\/\n\ncp \/oracle\/product\/12.1.0\/dbhome_1\/dbs\/orapwstdby \/oracle\/product\/19\/dbhome_1\/dbs\/\n\ncp \/oracle\/product\/12.1.0\/dbhome_1\/dbs\/dr1stdby.dat \/oracle\/product\/19\/dbhome_1\/dbs\/\ncp \/oracle\/product\/12.1.0\/dbhome_1\/dbs\/dr2stdby.dat \/oracle\/product\/19\/dbhome_1\/dbs\/\n\ncp \/oracle\/product\/12.1.0\/dbhome_1\/network\/admin\/sqlnet.ora\u00a0 \/oracle\/product\/19\/dbhome_1\/network\/admin\/\n\ncp \/oracle\/product\/12.1.0\/dbhome_1\/network\/admin\/tnsnames.ora \u00a0\/oracle\/product\/19\/dbhome_1\/network\/admin\/\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">Disable Data Guard Broker<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Now we need to disable the Data Guard Broker (if configured)<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\ndgmgrl sys@prmy\nshow configuration;\nDISABLE CONFIGURATION;\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Run the following alter statement on both the primary and standby database.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER SYSTEM SET DG_BROKER_START=FALSE;\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">On the primary database, remove the net_timeout setting from log_archive_dest_2 and verify the primary database has specified the db_unique_name of the standby database in the log_archive_dest_n parameter setting as follows:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSYS@CDB$ROOT&gt;select name, value from v$parameter where name in (&#039;log_archive_dest_2&#039;);\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\n_____________________ ____________________________________________________________________________________________________________________________________________________________________________________________________\nlog_archive_dest_2\u00a0\u00a0\u00a0 service=&quot;stdby&quot;, ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name=&quot;stdby&quot; net_timeout=30, valid_for=(online_logfile,all_roles)\n\n1 rows selected.\n\u00a0\n--set the parameter on PRIMARY DATABASE without net_timeout\u00a0\nalter system set log_archive_dest_2=&#039;service=&quot;stdby&quot;, ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name=&quot;stdby&quot;, valid_for=(online_logfile,all_roles)&#039; scope=both;\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">Flush Redo<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Next, flush all redo to the standby database using the following command. Monitor the alert.log on the standby database to verify the &#8216;<em>End-of-Redo<\/em>&#8216; message.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; highlight: [7]; title: ; notranslate\" title=\"\">\n--Startup Primary in MOUNT\nstartup mount;\nalter system flush redo to &#039;stdby&#039;;\n\u00a0\n--In the Standby Alert log:\nStandby switchover readiness check: Checking whether recovery applied all redo..\nPhysical Standby applied all the redo from the primary.\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">Start the standby database from the 19c home in MOUNT state<\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; highlight: [3]; title: ; notranslate\" title=\"\">\nsrvctl stop database -db stdby\n\n# Set env to 19c Home\n\n# Update the OCR configuration for the standby database by running the &#039;srvctl upgrade&#039; command from the new database home as follow:\n\u00a0\ncd \/oracle\/product\/19\/dbhome_1\/bin\nsrvctl upgrade database -d stdby -o \/oracle\/product\/19\/dbhome_1\n\u00a0\u00a0\n# Start the standby as follows (add -o mount option for database running Active Data Guard):\nsrvctl start database -d stdby -o mount\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--Start MRP (Managed Recovery Process):\nALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">Upgrade Primary Database<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Now we can upgrade the primary database. I will not be listing details of upgrading the primary database as this is not the scope of this blog.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Active Data Guard<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">After successful upgrade of the primary database, the standby database will also get upgraded. If you have an ADG license, then wait until the primary and standby database redo are in sync before opening the standby database in read-only mode.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter database open read only;\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">Enable Data Guard Broker<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">As a last step, enable DG Broker. Run the following on both primary and standby databases<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER SYSTEM SET dg_broker_start=TRUE SCOPE=BOTH;\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Enable Data Guard Broker.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\ndgmgrl sys@prmy\nshow configuration;\nenable configuration;\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this post, I am sharing my notes on upgrading an Oracle Standby database. The following are the steps I performed on the standby database while upgrading from 12.1 to 19.5, but these can be used for upgrading any standby database version. I hope you find this helpful, and good luck with your upgrade. \ud83d\ude03 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4189,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[57,52,51],"tags":[54,64,31,63,55],"class_list":["post-4171","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-database","category-oracle-database-19c","category-upgrade","tag-19c","tag-database","tag-oracle","tag-standby","tag-upgrade"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":8}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Upgrade Standby Database - The Database Handyman<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/aamirharoon.com\/?p=4171\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrade Standby Database - The Database Handyman\" \/>\n<meta property=\"og:description\" content=\"In this post, I am sharing my notes on upgrading an Oracle Standby database. The following are the steps I performed on the standby database while upgrading from 12.1 to 19.5, but these can be used for upgrading any standby database version. I hope you find this helpful, and good luck with your upgrade. \ud83d\ude03 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aamirharoon.com\/?p=4171\" \/>\n<meta property=\"og:site_name\" content=\"The Database Handyman\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-07T05:59:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-22T01:58:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/aamirharoon.com\/wp-content\/uploads\/2020\/12\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"333\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Aamir\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@aamir814\" \/>\n<meta name=\"twitter:site\" content=\"@aamir814\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aamir\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=4171#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=4171\"},\"author\":{\"name\":\"Aamir\",\"@id\":\"https:\\\/\\\/www.aamirharoon.com\\\/#\\\/schema\\\/person\\\/5b7250c4974dcf9818ca431e21831c75\"},\"headline\":\"Upgrade Standby Database\",\"datePublished\":\"2020-12-07T05:59:35+00:00\",\"dateModified\":\"2026-09-22T01:58:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=4171\"},\"wordCount\":336,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.aamirharoon.com\\\/#\\\/schema\\\/person\\\/5b7250c4974dcf9818ca431e21831c75\"},\"image\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=4171#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.aamirharoon.com\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg\",\"keywords\":[\"19c\",\"database\",\"oracle\",\"standby\",\"upgrade\"],\"articleSection\":[\"Oracle Database\",\"Oracle Database 19c\",\"Upgrade\"],\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/aamirharoon.com\\\/?p=4171#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=4171\",\"url\":\"https:\\\/\\\/aamirharoon.com\\\/?p=4171\",\"name\":\"Upgrade Standby Database - The Database Handyman\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.aamirharoon.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=4171#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=4171#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.aamirharoon.com\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg\",\"datePublished\":\"2020-12-07T05:59:35+00:00\",\"dateModified\":\"2026-09-22T01:58:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=4171#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/aamirharoon.com\\\/?p=4171\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=4171#primaryimage\",\"url\":\"https:\\\/\\\/www.aamirharoon.com\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg\",\"contentUrl\":\"https:\\\/\\\/www.aamirharoon.com\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg\",\"width\":640,\"height\":333,\"caption\":\"Photo by Tobias Fischer on Unsplash\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=4171#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.aamirharoon.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrade Standby Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.aamirharoon.com\\\/#website\",\"url\":\"https:\\\/\\\/www.aamirharoon.com\\\/\",\"name\":\"The Database Handyman\",\"description\":\"Cloud Architecture. Open-Source Databases. Data-Driven Solutions.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.aamirharoon.com\\\/#\\\/schema\\\/person\\\/5b7250c4974dcf9818ca431e21831c75\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.aamirharoon.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.aamirharoon.com\\\/#\\\/schema\\\/person\\\/5b7250c4974dcf9818ca431e21831c75\",\"name\":\"Aamir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/www.aamirharoon.com\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/toolbox_1f9f0.png\",\"url\":\"https:\\\/\\\/www.aamirharoon.com\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/toolbox_1f9f0.png\",\"contentUrl\":\"https:\\\/\\\/www.aamirharoon.com\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/toolbox_1f9f0.png\",\"width\":160,\"height\":160,\"caption\":\"Aamir\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.aamirharoon.com\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/toolbox_1f9f0.png\"},\"sameAs\":[\"https:\\\/\\\/www.aamirharoon.com\\\/about\\\/\",\"https:\\\/\\\/x.com\\\/aamir814\"],\"url\":\"https:\\\/\\\/www.aamirharoon.com\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upgrade Standby Database - The Database Handyman","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/aamirharoon.com\/?p=4171","og_locale":"en_US","og_type":"article","og_title":"Upgrade Standby Database - The Database Handyman","og_description":"In this post, I am sharing my notes on upgrading an Oracle Standby database. The following are the steps I performed on the standby database while upgrading from 12.1 to 19.5, but these can be used for upgrading any standby database version. I hope you find this helpful, and good luck with your upgrade. \ud83d\ude03 [&hellip;]","og_url":"https:\/\/aamirharoon.com\/?p=4171","og_site_name":"The Database Handyman","article_published_time":"2020-12-07T05:59:35+00:00","article_modified_time":"2026-09-22T01:58:52+00:00","og_image":[{"width":640,"height":333,"url":"https:\/\/aamirharoon.com\/wp-content\/uploads\/2020\/12\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg","type":"image\/jpeg"}],"author":"Aamir","twitter_card":"summary_large_image","twitter_creator":"@aamir814","twitter_site":"@aamir814","twitter_misc":{"Written by":"Aamir","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aamirharoon.com\/?p=4171#article","isPartOf":{"@id":"https:\/\/aamirharoon.com\/?p=4171"},"author":{"name":"Aamir","@id":"https:\/\/www.aamirharoon.com\/#\/schema\/person\/5b7250c4974dcf9818ca431e21831c75"},"headline":"Upgrade Standby Database","datePublished":"2020-12-07T05:59:35+00:00","dateModified":"2026-09-22T01:58:52+00:00","mainEntityOfPage":{"@id":"https:\/\/aamirharoon.com\/?p=4171"},"wordCount":336,"commentCount":0,"publisher":{"@id":"https:\/\/www.aamirharoon.com\/#\/schema\/person\/5b7250c4974dcf9818ca431e21831c75"},"image":{"@id":"https:\/\/aamirharoon.com\/?p=4171#primaryimage"},"thumbnailUrl":"https:\/\/www.aamirharoon.com\/wp-content\/uploads\/2020\/12\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg","keywords":["19c","database","oracle","standby","upgrade"],"articleSection":["Oracle Database","Oracle Database 19c","Upgrade"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/aamirharoon.com\/?p=4171#respond"]}]},{"@type":"WebPage","@id":"https:\/\/aamirharoon.com\/?p=4171","url":"https:\/\/aamirharoon.com\/?p=4171","name":"Upgrade Standby Database - The Database Handyman","isPartOf":{"@id":"https:\/\/www.aamirharoon.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/aamirharoon.com\/?p=4171#primaryimage"},"image":{"@id":"https:\/\/aamirharoon.com\/?p=4171#primaryimage"},"thumbnailUrl":"https:\/\/www.aamirharoon.com\/wp-content\/uploads\/2020\/12\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg","datePublished":"2020-12-07T05:59:35+00:00","dateModified":"2026-09-22T01:58:52+00:00","breadcrumb":{"@id":"https:\/\/aamirharoon.com\/?p=4171#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aamirharoon.com\/?p=4171"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/aamirharoon.com\/?p=4171#primaryimage","url":"https:\/\/www.aamirharoon.com\/wp-content\/uploads\/2020\/12\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg","contentUrl":"https:\/\/www.aamirharoon.com\/wp-content\/uploads\/2020\/12\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg","width":640,"height":333,"caption":"Photo by Tobias Fischer on Unsplash"},{"@type":"BreadcrumbList","@id":"https:\/\/aamirharoon.com\/?p=4171#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.aamirharoon.com\/"},{"@type":"ListItem","position":2,"name":"Upgrade Standby Database"}]},{"@type":"WebSite","@id":"https:\/\/www.aamirharoon.com\/#website","url":"https:\/\/www.aamirharoon.com\/","name":"The Database Handyman","description":"Cloud Architecture. Open-Source Databases. Data-Driven Solutions.","publisher":{"@id":"https:\/\/www.aamirharoon.com\/#\/schema\/person\/5b7250c4974dcf9818ca431e21831c75"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.aamirharoon.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":["Person","Organization"],"@id":"https:\/\/www.aamirharoon.com\/#\/schema\/person\/5b7250c4974dcf9818ca431e21831c75","name":"Aamir","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/www.aamirharoon.com\/wp-content\/uploads\/2026\/09\/toolbox_1f9f0.png","url":"https:\/\/www.aamirharoon.com\/wp-content\/uploads\/2026\/09\/toolbox_1f9f0.png","contentUrl":"https:\/\/www.aamirharoon.com\/wp-content\/uploads\/2026\/09\/toolbox_1f9f0.png","width":160,"height":160,"caption":"Aamir"},"logo":{"@id":"https:\/\/www.aamirharoon.com\/wp-content\/uploads\/2026\/09\/toolbox_1f9f0.png"},"sameAs":["https:\/\/www.aamirharoon.com\/about\/","https:\/\/x.com\/aamir814"],"url":"https:\/\/www.aamirharoon.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts\/4171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4171"}],"version-history":[{"count":20,"href":"https:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts\/4171\/revisions"}],"predecessor-version":[{"id":4329,"href":"https:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts\/4171\/revisions\/4329"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/media\/4189"}],"wp:attachment":[{"href":"https:\/\/www.aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}