{"id":9452,"date":"2016-11-30T18:19:43","date_gmt":"2016-11-30T17:19:43","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/"},"modified":"2023-06-08T16:14:17","modified_gmt":"2023-06-08T14:14:17","slug":"switchover-and-failover-with-dbvisit-8","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/","title":{"rendered":"Switchover and Failover with Dbvisit 8"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

In this blog we will talk about how to do a switchover and how to do a failover. We suppose that dbvisit is already installed and that a standby database is already configured. Our instance is named DBPRIMA.<\/p>\n

Switchover<\/strong>
\nSWITCHOVER is the fact to change database role. The primary becomes the standby and the standby becomes the primary. This can be useful for many reasons.
\nBefore performing a switchover, we have first to send archived logs if any not already sent on the primary server. For this we use the magic command dbvctl
\n
\n[oracle@dbvisit2 DBPRIMA]$ \/u01\/app\/dbvisit\/standby\/dbvctl -d DBPRIMA
\n=============================================================
\nDbvisit Standby Database Technology (8.0.04.18184) (pid 9201)
\ndbvctl started on dbvisit2: Tue Nov 29 14:46:15 2016
\n=============================================================
\n>>> Applying Log file(s) from dbvisit1 to DBPRIMA on dbvisit2:
\nthread 1 sequence 30 (1_30_926978008.arc)
\n=============================================================
\ndbvctl ended on dbvisit2: Tue Nov 29 14:46:17 2016
\n=============================================================
\n[oracle@dbvisit2 DBPRIMA]$
\n<\/code><\/p>\n

After let\u2019s apply all archived logs on the standby
\n
\n[oracle@dbvisit2 DBPRIMA]$ \/u01\/app\/dbvisit\/standby\/dbvctl -d DBPRIMA
\n=============================================================
\nDbvisit Standby Database Technology (8.0.04.18184) (pid 9201)
\ndbvctl started on dbvisit2: Tue Nov 29 14:46:15 2016
\n=============================================================
\n>>> Applying Log file(s) from dbvisit1 to DBPRIMA on dbvisit2:
\nthread 1 sequence 30 (1_30_926978008.arc)
\n=============================================================
\ndbvctl ended on dbvisit2: Tue Nov 29 14:46:17 2016
\n=============================================================
\n[oracle@dbvisit2 DBPRIMA]$
\n<\/code>
\nNote that the commands above can be scheduled on both servers using crontab for example on linux system
\nOn the Primary Server:
\n
\n00,10,20,30,40,50 * * * * cd \/u01\/app\/dbvisit\/standby; .\/dbvctl -d DBPRIMA >>\/dev\/null 2>&1
\n<\/code>
\nOn the Standby Server:
\n
\n00,10,20,30,40,50 * * * * cd \/u01\/app\/dbvisit\/standby; .\/dbvctl -d DBPRIMA >>\/dev\/null 2>&1
\n<\/code>
\nAfter sending and applying archived logs, we can check the status of the synchronization
\n
\n[oracle@dbvisit1 ~]$ \/u01\/app\/dbvisit\/standby\/dbvctl -d DBPRIMA -i
\n=============================================================
\nDbvisit Standby Database Technology (8.0.04.18184) (pid 4420)
\ndbvctl started on dbvisit1: Tue Nov 29 14:26:11 2016
\n=============================================================
\nDbvisit Standby log gap report for DBPRIMA thread 1 at 201611291426:
\n-------------------------------------------------------------
\nDestination database on dbvisit2 is at sequence: 29.
\nSource database on dbvisit1 is at log sequence: 30.
\nSource database on dbvisit1 is at archived log sequence: 29.
\nDbvisit Standby last transfer log sequence: 29.
\nDbvisit Standby last transfer at: 2016-11-29 14:24:16.
\nArchive log gap for DBPRIMA: 0.
\nTransfer log gap for DBPRIMA: 0.
\nStandby database time lag (DAYS-HH:MI:SS): +0:01:37.
\n=============================================================
\ndbvctl ended on dbvisit1: Tue Nov 29 14:26:12 2016
\n=============================================================
\n[oracle@dbvisit1 ~]$
\n<\/code>
\nIf all is ok, we can now we can go for the SWITCHOVER. We can do it either by the graphical console or by command line. We are using the command line method. The command should be run only on the primary server.
\n
\n[oracle@dbvisit1 ~]$ \/u01\/app\/dbvisit\/standby\/dbvctl -d DBPRIMA -o switchover
\n=============================================================
\nDbvisit Standby Database Technology (8.0.04.18184) (pid 5081)
\ndbvctl started on dbvisit1: Tue Nov 29 14:47:32 2016
\n=============================================================
\n>>> Starting Switchover between dbvisit1 and dbvisit2
\nRunning pre-checks ... done
\nPre processing ... done
\nProcessing primary ... done
\nProcessing standby ... done
\nConverting standby ... done
\nConverting primary ... done
\nCompleting ... done
\nSynchronizing ... done
\nPost processing ... done
\n>>> Graceful switchover completed.
\nPrimary Database Server: dbvisit2
\nStandby Database Server: dbvisit1
\n>>> Dbvisit Standby can be run as per normal:
\ndbvctl -d DBPRIMA
\nPID:5081
\nTRACE:5081_dbvctl_switchover_DBPRIMA_201611291447.trc
\n=============================================================
\ndbvctl ended on dbvisit1: Tue Nov 29 14:50:23 2016
\n=============================================================
\n[oracle@dbvisit1 ~]$
\n<\/code>
\nFailover<\/strong>
\nThe FAILOVER process happens when the primary database is no longer working. In this case the standby should be activated and will become the primary one. This FAILOVER process is NOT reversible unlike SWITCHOVER process.
\nA good practice before activating the standby database is to run a quick test to ensure that the standby database is in a consistent state (datafile headers and controlfile is in sync) and ready to be activated. This can be done by opening the standby database read-only.
\n
\n[oracle@dbvisit2 ~]$ \/u01\/app\/dbvisit\/standby\/dbvctl -d DBPRIMA -o read
\n=============================================================
\nDbvisit Standby Database Technology (8.0.04.18184) (pid 2542)
\ndbvctl started on dbvisit2: Wed Nov 30 09:40:50 2016
\n=============================================================
\nOpen Standby Database DBPRIMA in READ ONLY mode...
\nStandby Database DBPRIMA opened in READ ONLY mode.
\nLog files cannot be applied to Database while in READ ONLY mode.
\nDatabase tempfile(s) may need to be added to this database.
\n=============================================================
\ndbvctl ended on dbvisit2: Wed Nov 30 09:40:55 2016
\n=============================================================
\n[oracle@dbvisit2 ~]$
\n<\/code><\/p>\n

As we don\u2019t get any error and that we know we can open the standby read-only, let\u2019s start it back into recovery mode (mount state).
\n
\n[oracle@dbvisit2 ~]$ \/u01\/app\/dbvisit\/standby\/dbvctl -d DBPRIMA -o restart
\n=============================================================
\nDbvisit Standby Database Technology (8.0.04.18184) (pid 2667)
\ndbvctl started on dbvisit2: Wed Nov 30 09:45:45 2016
\n=============================================================
\nStopping instance DBPRIMA...
\nStandby Instance DBPRIMA shutdown successfully on dbvisit2.
\nStarting instance DBPRIMA...
\nStandby Instance DBPRIMA started
\n=============================================================
\ndbvctl ended on dbvisit2: Wed Nov 30 09:45:57 2016
\n=============================================================
\n[oracle@dbvisit2 ~]$
\n<\/code><\/p>\n

And proceed with the FAILOVER. Dbvisit will ask to confirm. We can use the –force option to avoid this.
\n
\n[oracle@dbvisit2 ~]$ \/u01\/app\/dbvisit\/standby\/dbvctl -d DBPRIMA -o activate
\n=============================================================
\nDbvisit Standby Database Technology (8.0.04.18184) (pid 2796)
\ndbvctl started on dbvisit2: Wed Nov 30 09:47:12 2016
\n=============================================================
\nActivating means this database will become a Primary Database.
\nIt will no longer be a Standby Database for DBPRIMA on dbvisit1.
\nActivation cannot be reversed.
\n=>Activate Standby Database on dbvisit2? [No]: yes
\nAre you sure? [No]: yes
\n>>> Activating now...
\nFile \/u01\/app\/dbvisit\/standby\/conf\/dbv_DBPRIMA.env copied to
\n\/u01\/app\/dbvisit\/standby\/conf\/dbv_DBPRIMA.env.201611300947.
\n>>> Activation complete. Please ensure a backup of this Database is made
\n>>> Old archives from before the activation should be removed to avoid mix-up between new
\nand old archive logs
\n>>> If the Dbvisit Standby process is to be reversed, then database on dbvisit1 will need
\nto be rebuilt as a Standby Database
\n=============================================================
\ndbvctl ended on dbvisit2: Wed Nov 30 09:48:07 2016
\n=============================================================
\n[oracle@dbvisit2 ~]$
\n<\/code><\/p>\n

In this article we have seen how easy it is to do a switchover or failover with Dbvisit 8 .<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw In this blog we will talk about how to do a switchover and how to do a failover. We suppose that dbvisit is already installed and that a standby database is already configured. Our instance is named DBPRIMA. Switchover SWITCHOVER is the fact to change database role. The primary becomes the standby […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[998],"type_dbi":[],"class_list":["post-9452","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-dbvisit-standby-version-8"],"acf":[],"yoast_head":"\nSwitchover and Failover with Dbvisit 8 - dbi Blog<\/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.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Switchover and Failover with Dbvisit 8\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw In this blog we will talk about how to do a switchover and how to do a failover. We suppose that dbvisit is already installed and that a standby database is already configured. Our instance is named DBPRIMA. Switchover SWITCHOVER is the fact to change database role. The primary becomes the standby […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-30T17:19:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-08T14:14:17+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Switchover and Failover with Dbvisit 8\",\"datePublished\":\"2016-11-30T17:19:43+00:00\",\"dateModified\":\"2023-06-08T14:14:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/\"},\"wordCount\":341,\"commentCount\":0,\"keywords\":[\"Dbvisit Standby Version 8\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/\",\"name\":\"Switchover and Failover with Dbvisit 8 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-11-30T17:19:43+00:00\",\"dateModified\":\"2023-06-08T14:14:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Switchover and Failover with Dbvisit 8\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Switchover and Failover with Dbvisit 8 - dbi Blog","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.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/","og_locale":"en_US","og_type":"article","og_title":"Switchover and Failover with Dbvisit 8","og_description":"By Mouhamadou Diaw In this blog we will talk about how to do a switchover and how to do a failover. We suppose that dbvisit is already installed and that a standby database is already configured. Our instance is named DBPRIMA. Switchover SWITCHOVER is the fact to change database role. The primary becomes the standby […]","og_url":"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/","og_site_name":"dbi Blog","article_published_time":"2016-11-30T17:19:43+00:00","article_modified_time":"2023-06-08T14:14:17+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Switchover and Failover with Dbvisit 8","datePublished":"2016-11-30T17:19:43+00:00","dateModified":"2023-06-08T14:14:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/"},"wordCount":341,"commentCount":0,"keywords":["Dbvisit Standby Version 8"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/","url":"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/","name":"Switchover and Failover with Dbvisit 8 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-11-30T17:19:43+00:00","dateModified":"2023-06-08T14:14:17+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/switchover-and-failover-with-dbvisit-8\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Switchover and Failover with Dbvisit 8"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9452"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9452\/revisions"}],"predecessor-version":[{"id":25685,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9452\/revisions\/25685"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9452"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}