In this post, I am sharing my notes on upgrading Oracle Standby database. Following are the steps I preformed on 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
I hope you find this helpful and good luck with your upgrade. \ud83d\ude03<\/p>\n\n\n\n
At high level, you don’t upgrade 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 upgrade. The standby database will upgrade as it receives redo logs from primary database.<\/p>\n\n\n\n
On standby database copy following files from 12.1 Oracle home to 19.<\/p>\n\n\n\n
cp \/oracle\/product\/12.1.0\/dbhome_1\/dbs\/spfilestdby.ora<\/span> \/oracle\/product\/19\/dbhome_1\/dbs\/\n\ncp \/oracle\/product\/12.1.0\/dbhome_1\/dbs\/orapwstdby<\/span> \/oracle\/product\/19\/dbhome_1\/dbs\/\n\ncp \/oracle\/product\/12.1.0\/dbhome_1\/dbs\/dr1stdby.dat<\/span> \/oracle\/product\/19\/dbhome_1\/dbs\/\ncp \/oracle\/product\/12.1.0\/dbhome_1\/dbs\/dr2stdby.dat <\/span>\/oracle\/product\/19\/dbhome_1\/dbs\/\n\ncp \/oracle\/product\/12.1.0\/dbhome_1\/network\/admin\/sqlnet.ora <\/span>\/oracle\/product\/19\/dbhome_1\/network\/admin\/\n\ncp \/oracle\/product\/12.1.0\/dbhome_1\/network\/admin\/tnsnames.ora <\/span> \/oracle\/product\/19\/dbhome_1\/network\/admin\/<\/pre>\n\n\n\nDisable Data Guard Broker<\/h3>\n\n\n\n
Now we need to disable data guard broker (if configured)<\/p>\n\n\n\n
dgmgrl sys@prmy\nshow configuration;\nDISABLE CONFIGURATION;<\/pre>\n\n\n\nRun the following alter statement on both, primary and standby database.<\/p>\n\n\n\n
ALTER SYSTEM SET DG_BROKER_START=FALSE;<\/pre>\n\n\n\nOn primary database, remove the net_timeout setting from log_archive_dest_2 and verify the primary database has specified db_unique_name of the standby database in the log_archive_dest_n parameter setting as follows:<\/p>\n\n\n\n
SYS@CDB$ROOT>select name, value from v$parameter where name in ('log_archive_dest_2');\n NAME VALUE\n_____________________ ____________________________________________________________________________________________________________________________________________________________________________________________________\nlog_archive_dest_2 service=\"stdby\", ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name=\"stdby\" net_timeout=30<\/span>, valid_for=(online_logfile,all_roles)\n\n1 rows selected.\n \n--set the parameter on PRIMARY DATABASE without net_timeout \nalter system set log_archive_dest_2='service=\"stdby\", ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name=\"stdby\", valid_for=(online_logfile,all_roles)' scope=both;<\/pre>\n\n\n\nFlush Redo<\/h3>\n\n\n\n
Next, flush all redo to the standby database using the following command. Monitor the alert.log of the standby database to verify for the ‘End-of-Redo<\/em>‘ message.<\/p>\n\n\n\n--Startup Primary in MOUNT\nstartup mount;\nalter system flush redo to 'stdby';\n \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.<\/span><\/pre>\n\n\n\nStart Standby database from 19c home in mount state<\/h3>\n\n\n\nsrvctl stop database -db stdby\n\nSet env to 19c Home<\/strong>\n\n--Update the OCR configuration for the standby database by running the 'srvctl upgrade' command from the new database home as follow:\n \ncd \/oracle\/product\/19\/dbhome_1\/bin\nsrvctl upgrade database -d stdby -o \/oracle\/product\/19\/dbhome_1\n \n--Start the standby as follows (add -o mount option for database running Active Data Guard):\nsrvctl start database -d stdby -o mount\n\n--Start MRP (Managed Recovery Process):\nALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;<\/pre>\n\n\n\nUpgrade Primary Database<\/h3>\n\n\n\n
Now we can upgrade primary database. I will not be listing details of upgrading primary database as this is not the scope of this blog.<\/p>\n\n\n\n
Active Data Guard<\/h3>\n\n\n\n
After successful upgrade of primary database, standby database will also get upgraded. If you have ADG license, then wait until primary and standby database redo are in sync before opening the standby database in read-only mode.<\/p>\n\n\n\n
alter database open read only;<\/pre>\n\n\n\nEnable Data Guard Broker<\/h3>\n\n\n\n
As a last step, enable DG broker. Run the following on both primary and standby databases<\/p>\n\n\n\n
ALTER SYSTEM SET dg_broker_start=TRUE SCOPE=BOTH;<\/pre>\n\n\n\nEnable data guard broker.<\/p>\n\n\n\n
dgmgrl sys@prmy\nshow configuration;\nenable configuration;<\/pre>\n\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
In this post, I am sharing my notes on upgrading Oracle Standby database. Following are the steps I preformed on standby database while upgrading from<\/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"],"yoast_head":"\n
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:\/\/www.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 Oracle Standby database. Following are the steps I preformed on standby database while upgrading from\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.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=\"2020-12-07T06:01:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.aamirharoon.com\/?p=4171#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.aamirharoon.com\/?p=4171\"},\"author\":{\"name\":\"Aamir\",\"@id\":\"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63\"},\"headline\":\"Upgrade Standby Database\",\"datePublished\":\"2020-12-07T05:59:35+00:00\",\"dateModified\":\"2020-12-07T06:01:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.aamirharoon.com\/?p=4171\"},\"wordCount\":316,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63\"},\"image\":{\"@id\":\"https:\/\/www.aamirharoon.com\/?p=4171#primaryimage\"},\"thumbnailUrl\":\"http:\/\/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:\/\/www.aamirharoon.com\/?p=4171#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.aamirharoon.com\/?p=4171\",\"url\":\"https:\/\/www.aamirharoon.com\/?p=4171\",\"name\":\"Upgrade Standby Database - The Database Handyman\",\"isPartOf\":{\"@id\":\"http:\/\/www.aamirharoon.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.aamirharoon.com\/?p=4171#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.aamirharoon.com\/?p=4171#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2020\/12\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg\",\"datePublished\":\"2020-12-07T05:59:35+00:00\",\"dateModified\":\"2020-12-07T06:01:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.aamirharoon.com\/?p=4171#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.aamirharoon.com\/?p=4171\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/www.aamirharoon.com\/?p=4171#primaryimage\",\"url\":\"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2020\/12\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg\",\"contentUrl\":\"http:\/\/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:\/\/www.aamirharoon.com\/?p=4171#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/www.aamirharoon.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrade Standby Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.aamirharoon.com\/#website\",\"url\":\"http:\/\/www.aamirharoon.com\/\",\"name\":\"The Database Handyman\",\"description\":\"My notes about Oracle Database, APEX, OEM Cloud Control and whatever I learn\",\"publisher\":{\"@id\":\"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.aamirharoon.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63\",\"name\":\"Aamir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"http:\/\/www.aamirharoon.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/63cc5bb07711a1b9719cc47e13a8205072859c1aef30fac28f412baa84b9cf9b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/63cc5bb07711a1b9719cc47e13a8205072859c1aef30fac28f412baa84b9cf9b?s=96&d=mm&r=g\",\"caption\":\"Aamir\"},\"logo\":{\"@id\":\"http:\/\/www.aamirharoon.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/www.aamirharoon.com\/about\/\",\"https:\/\/x.com\/aamir814\"],\"url\":\"http:\/\/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:\/\/www.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 Oracle Standby database. Following are the steps I preformed on standby database while upgrading from","og_url":"https:\/\/www.aamirharoon.com\/?p=4171","og_site_name":"The Database Handyman","article_published_time":"2020-12-07T05:59:35+00:00","article_modified_time":"2020-12-07T06:01:18+00:00","og_image":[{"width":640,"height":333,"url":"https:\/\/www.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.aamirharoon.com\/?p=4171#article","isPartOf":{"@id":"https:\/\/www.aamirharoon.com\/?p=4171"},"author":{"name":"Aamir","@id":"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63"},"headline":"Upgrade Standby Database","datePublished":"2020-12-07T05:59:35+00:00","dateModified":"2020-12-07T06:01:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.aamirharoon.com\/?p=4171"},"wordCount":316,"commentCount":0,"publisher":{"@id":"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63"},"image":{"@id":"https:\/\/www.aamirharoon.com\/?p=4171#primaryimage"},"thumbnailUrl":"http:\/\/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:\/\/www.aamirharoon.com\/?p=4171#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.aamirharoon.com\/?p=4171","url":"https:\/\/www.aamirharoon.com\/?p=4171","name":"Upgrade Standby Database - The Database Handyman","isPartOf":{"@id":"http:\/\/www.aamirharoon.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.aamirharoon.com\/?p=4171#primaryimage"},"image":{"@id":"https:\/\/www.aamirharoon.com\/?p=4171#primaryimage"},"thumbnailUrl":"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2020\/12\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg","datePublished":"2020-12-07T05:59:35+00:00","dateModified":"2020-12-07T06:01:18+00:00","breadcrumb":{"@id":"https:\/\/www.aamirharoon.com\/?p=4171#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.aamirharoon.com\/?p=4171"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/www.aamirharoon.com\/?p=4171#primaryimage","url":"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2020\/12\/tobias-fischer-PkbZahEG2Ng-unsplash.jpg","contentUrl":"http:\/\/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:\/\/www.aamirharoon.com\/?p=4171#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.aamirharoon.com\/"},{"@type":"ListItem","position":2,"name":"Upgrade Standby Database"}]},{"@type":"WebSite","@id":"http:\/\/www.aamirharoon.com\/#website","url":"http:\/\/www.aamirharoon.com\/","name":"The Database Handyman","description":"My notes about Oracle Database, APEX, OEM Cloud Control and whatever I learn","publisher":{"@id":"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.aamirharoon.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":["Person","Organization"],"@id":"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63","name":"Aamir","image":{"@type":"ImageObject","inLanguage":"en","@id":"http:\/\/www.aamirharoon.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/63cc5bb07711a1b9719cc47e13a8205072859c1aef30fac28f412baa84b9cf9b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/63cc5bb07711a1b9719cc47e13a8205072859c1aef30fac28f412baa84b9cf9b?s=96&d=mm&r=g","caption":"Aamir"},"logo":{"@id":"http:\/\/www.aamirharoon.com\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/www.aamirharoon.com\/about\/","https:\/\/x.com\/aamir814"],"url":"http:\/\/www.aamirharoon.com\/?author=1"}]}},"_links":{"self":[{"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts\/4171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4171"}],"version-history":[{"count":14,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts\/4171\/revisions"}],"predecessor-version":[{"id":4190,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts\/4171\/revisions\/4190"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/media\/4189"}],"wp:attachment":[{"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4171"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}