{"id":12239,"date":"2019-06-12T20:59:20","date_gmt":"2019-06-12T20:59:20","guid":{"rendered":"https:\/\/dbtut.com\/?p=12239"},"modified":"2021-12-20T14:45:00","modified_gmt":"2021-12-20T14:45:00","slug":"what-is-asm-failure-group","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/","title":{"rendered":"What is ASM Failure Group"},"content":{"rendered":"

ASM Failure group is defined as protection against the problems in disk in ASM disk groups. Oracle provides disk redundancy with failure groups.<\/p>\n

If the failure group is not defined in non-Exadata environments, the failure group for each disk is itself. In this case, the failure group of a block on a disk is copied to a different disk.<\/p>\n

In the Exadata environment, the failure group for disks on each cell node is cellnode itself. In this way, the blocks on the disk in the cell node is also present on another cellnode, so even if the cellnode is turned off, there will be no problem.<\/p>\n

We can define failure groups when creating a disk group. First you should understand disk redundancy types.<\/p>\n

Disk Redundancy Types<\/h3>\n

High Redundancy :<\/strong> data is stored in 3 copies, including itself. A disk group requires at least 3 failure groups. Each copy must be on different failure group. In this way, even if the two failure groups fails, there will be no data loss and database continues to work.<\/p>\n

Normal Redundancy :<\/strong> data is stored in 2 copies, including itself. A disk group requires at least 2 failure groups. Each copy must be on different failure groups.<\/p>\n

External Redundancy:<\/strong> The copy of the data is not stored. You can choose this type if there is already a RAID structure on the storage.<\/p>\n

Lets create a disk group with 3 failure groups and normal redundancy as follows.<\/p>\n

CREATE DISKGROUP DATA NORMAL REDUNDANCY\r\n  FAILGROUP fg1 DISK\r\n    '\/dev\/sda' NAME disk1,\r\n  FAILGROUP fg2 DISK\r\n    '\/dev\/sdb' NAME disk2,\r\n  FAILGROUP fg3 DISK\r\n    '\/dev\/sdc' NAME disk3\r\n  ATTRIBUTE 'au_size'='4M',\r\n    'compatible.asm' = '11.2', \r\n    'compatible.rdbms' = '11.2',\r\n    'compatible.advm' = '11.2';<\/pre>\n
According to the failure group definitions in this disk group, a copy of the blocks on \/dev\/sda will be on \/dev\/sdb or \/dev\/sdc. But the blocks of \/dev\/sda disks will never be on this disk. This is the case for normal redundancy.<\/p>\n
The block distribution in this disk group will be as follows. Three failure groups and normal redundancy.<\/p>\n
<\/p>\n
When a disk in this disk group becomes corrupted, the disk group will be available without data loss.<\/p>\n
\"\"<\/p>\n
If no external redundancy is used in disk group, it is recommended that the disks in a disk group have the same size and have the same number of disks with failure groups. This is mandatory in version 12c. In the case of a different behavior, disk space problems may occur.<\/p>\n
It is not possible to create a copy of all blocks between disks in different failure groups with different disks on different sizes.<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
ASM Failure group is defined as protection against the problems in disk in ASM disk groups. Oracle provides disk redundancy with failure groups. If the failure group is not defined in non-Exadata environments, the failure group for each disk is itself. In this case, the failure group of a block on a disk is copied …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":12242,"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":[4290,4291,4292,4289,4288,1945,1948,1947,4287],"class_list":["post-12239","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-asm-disk-failure","tag-asm-failure-group","tag-asm-redundancy-types","tag-create-diskgroup-normal-redundancy","tag-disk-redundancy-types-in-asm","tag-external-redundancy","tag-high-redundancy","tag-normal-redundancy","tag-what-is-asm-failure-group"],"aioseo_notices":[],"yoast_head":"\nWhat is ASM Failure Group - Database Tutorials<\/title>\n<meta name=\"description\" content=\"ASM Failure group is defined as protection against the problems in ASM disk groups. This provides disk redundancy with failure groups.\" \/>\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\/2019\/06\/12\/what-is-asm-failure-group\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is ASM Failure Group - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"ASM Failure group is defined as protection against the problems in ASM disk groups. This provides disk redundancy with failure groups.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-12T20:59:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-20T14:45:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-43.png\" \/>\n\t<meta property=\"og:image:width\" content=\"639\" \/>\n\t<meta property=\"og:image:height\" content=\"395\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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\/2019\/06\/12\/what-is-asm-failure-group\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"What is ASM Failure Group\",\"datePublished\":\"2019-06-12T20:59:20+00:00\",\"dateModified\":\"2021-12-20T14:45:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/\"},\"wordCount\":398,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-43.png\",\"keywords\":[\"asm disk failure\",\"asm failure group\",\"asm redundancy types\",\"create diskgroup normal redundancy\",\"disk redundancy types in asm\",\"External Redundancy\",\"High Redundancy\",\"Normal Redundancy\",\"What is asm failure group\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/\",\"name\":\"What is ASM Failure Group - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-43.png\",\"datePublished\":\"2019-06-12T20:59:20+00:00\",\"dateModified\":\"2021-12-20T14:45:00+00:00\",\"description\":\"ASM Failure group is defined as protection against the problems in ASM disk groups. This provides disk redundancy with failure groups.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-43.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-43.png\",\"width\":639,\"height\":395},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is ASM Failure Group\"}]},{\"@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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is ASM Failure Group - Database Tutorials","description":"ASM Failure group is defined as protection against the problems in ASM disk groups. This provides disk redundancy with failure groups.","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\/2019\/06\/12\/what-is-asm-failure-group\/","og_locale":"en_US","og_type":"article","og_title":"What is ASM Failure Group - Database Tutorials","og_description":"ASM Failure group is defined as protection against the problems in ASM disk groups. This provides disk redundancy with failure groups.","og_url":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/","og_site_name":"Database Tutorials","article_published_time":"2019-06-12T20:59:20+00:00","article_modified_time":"2021-12-20T14:45:00+00:00","og_image":[{"width":639,"height":395,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-43.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"What is ASM Failure Group","datePublished":"2019-06-12T20:59:20+00:00","dateModified":"2021-12-20T14:45:00+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/"},"wordCount":398,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-43.png","keywords":["asm disk failure","asm failure group","asm redundancy types","create diskgroup normal redundancy","disk redundancy types in asm","External Redundancy","High Redundancy","Normal Redundancy","What is asm failure group"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/","url":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/","name":"What is ASM Failure Group - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-43.png","datePublished":"2019-06-12T20:59:20+00:00","dateModified":"2021-12-20T14:45:00+00:00","description":"ASM Failure group is defined as protection against the problems in ASM disk groups. This provides disk redundancy with failure groups.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-43.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-43.png","width":639,"height":395},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/06\/12\/what-is-asm-failure-group\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"What is ASM Failure Group"}]},{"@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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12239","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=12239"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12239\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12242"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=12239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=12239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=12239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}