{"id":35333,"date":"2022-03-19T10:09:14","date_gmt":"2022-03-19T10:09:14","guid":{"rendered":"https:\/\/dbtut.com\/?p=35333"},"modified":"2022-03-19T10:12:53","modified_gmt":"2022-03-19T10:12:53","slug":"switchover-and-failover","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/","title":{"rendered":"Switchover And Failover"},"content":{"rendered":"

In today’s article we will talk about Switchover And Failover.<\/p>\n

Databases in Data Guard Environment can be in Primary and Standby (Physical, Logical & Snapshot) roles. With Role Management Services we can dynamically switch between these roles.<\/p>\n

We can change roles in two ways. One is Switchover and the other is Failover.<\/p>\n

Switchover<\/h4>\n

1.There is a planned change. For example, we use it when we do an operating system or hardware maintenance on the servers in the Primary Database.<\/p>\n

2.After Switchover, Primary Database Standby becomes Primary in Standby Database.<\/p>\n

3.We call the relevant command from the Primary Database.<\/p>\n

4.We do not need to re-create databases after switchover. The reason is that the online redo logs of the new primary database have not been reset.<\/p>\n

5.After a successful switchover, there is no data difference between the original and new primary database.<\/p>\n

6.Since the Primary Database is in read-write mode at the start of the switchover process, we need to close it and restart it, but we cannot close it during the Physical Standby Database Switchover.<\/p>\n

7.If the Physical Standby Database is Active DataGuard, then we close it for the role change and open it after the role change. There is no need to turn off the Logical Standby Database. The reason is that it is already in read-write mode.<\/p>\n

8.When we switchover the Primary Database’s Instances to Logical Standby, there is no shutdown. This provides support for Oracle to use this structure as a seamless Upgrade solution.<\/p>\n

9.When we switchover to the Logical Standby Database, the Physical and Snapshot Standby Databases in the Data Guard Environment are disabled and become invalid.<\/p>\n

Other Logical Standbys in the Environment become the Standbys of the New Primary Logical Standby Database.<\/p>\n

10.Since Data Guard cannot automatically switch open sessions from Primary to Standby, open sessions will need to be reconnected to the new Primary Database.<\/p>\n

Although this process can be done automatically with Client Connectivity, it is not generally used due to the fact that there will be a lot of processing at both the application and database level.<\/p>\n

Switchover is not allowed in 3 cases.
\n1. If the archive Redo Log files cannot be accessed,
\n2.If you need Point-in-time recovery,
\n3.Primary database is not open or cannot be opened.<\/p>\n

Failover<\/h4>\n

1. There is an unplanned change.<\/p>\n

2. We should use it in cases where the recovery of the problem in the Primary Database will take a long time.<\/p>\n

3. According to the Data Protection mode we choose, we will lose data. For example, while there is no data loss in Maximum Protection, there is data loss in Maximum Performance.<\/p>\n

4. We can enable the Fast-Start Failover feature to automate the failover process. With this feature, when the broker detects a failover situation, it automatically performs the failover process without the need for manual intervention of the DBA.<\/p>\n

5.Related commands are called from Standby Database.<\/p>\n

6. During the failover process, we DISABLE the Primary Database Data Guard Environment.<\/p>\n

7.Failover is a one-way operation, so we cannot return it to the previous role, Standby Database, as in Switchover.<\/p>\n

Because the old Primary database is no longer usable. Either by reinstate or by re-creation, a new Standby Database becomes a database.<\/p>\n

There are two types of Failovers.
\nManual<\/p>\n

Complete:It tries to minimize data loss by processing all available redos in the Standby Database. It is the default and recommended method.<\/p>\n

Immediate:Does not apply any redo on Standby Database. Instantly makes the database available.<\/p>\n

Fast-Start Failover<\/p>\n

It is performed automatically by the Data Guard Broker.
\nPhysical Standby Database, if available, is preferred before failover. Then the most up-to-date data is preferred.<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

In today’s article we will talk about Switchover And Failover. Databases in Data Guard Environment can be in Primary and Standby (Physical, Logical & Snapshot) roles. With Role Management Services we can dynamically switch between these roles. We can change roles in two ways. One is Switchover and the other is Failover. Switchover 1.There is …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":484,"featured_media":35349,"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,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-35333","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nSwitchover And Failover - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article we will talk about Switchover And Failover.Databases in Data Guard Environment can be in Primary and Standby roles.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Switchover And Failover - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article we will talk about Switchover And Failover.Databases in Data Guard Environment can be in Primary and Standby roles.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-19T10:09:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-19T10:12:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-15.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"773\" \/>\n\t<meta property=\"og:image:height\" content=\"348\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Switchover And Failover\",\"datePublished\":\"2022-03-19T10:09:14+00:00\",\"dateModified\":\"2022-03-19T10:12:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/\"},\"wordCount\":601,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-15.jpg\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/\",\"name\":\"Switchover And Failover - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-15.jpg\",\"datePublished\":\"2022-03-19T10:09:14+00:00\",\"dateModified\":\"2022-03-19T10:12:53+00:00\",\"description\":\"In today's article we will talk about Switchover And Failover.Databases in Data Guard Environment can be in Primary and Standby roles.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-15.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-15.jpg\",\"width\":773,\"height\":348},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Switchover And Failover\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Switchover And Failover - Database Tutorials","description":"In today's article we will talk about Switchover And Failover.Databases in Data Guard Environment can be in Primary and Standby roles.","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:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/","og_locale":"en_US","og_type":"article","og_title":"Switchover And Failover - Database Tutorials","og_description":"In today's article we will talk about Switchover And Failover.Databases in Data Guard Environment can be in Primary and Standby roles.","og_url":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/","og_site_name":"Database Tutorials","article_published_time":"2022-03-19T10:09:14+00:00","article_modified_time":"2022-03-19T10:12:53+00:00","og_image":[{"width":773,"height":348,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-15.jpg","type":"image\/jpeg"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Switchover And Failover","datePublished":"2022-03-19T10:09:14+00:00","dateModified":"2022-03-19T10:12:53+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/"},"wordCount":601,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-15.jpg","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/","url":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/","name":"Switchover And Failover - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-15.jpg","datePublished":"2022-03-19T10:09:14+00:00","dateModified":"2022-03-19T10:12:53+00:00","description":"In today's article we will talk about Switchover And Failover.Databases in Data Guard Environment can be in Primary and Standby roles.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-15.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-15.jpg","width":773,"height":348},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/19\/switchover-and-failover\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Switchover And Failover"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/35333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=35333"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/35333\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/35349"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=35333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=35333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=35333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}