{"id":14635,"date":"2020-01-08T07:03:05","date_gmt":"2020-01-08T07:03:05","guid":{"rendered":"https:\/\/dbtut.com\/?p=14635"},"modified":"2020-01-08T07:03:05","modified_gmt":"2020-01-08T07:03:05","slug":"automatic-gap-resolution","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/","title":{"rendered":"Automatic GAP Resolution"},"content":{"rendered":"<p>I will explan Automatic GAP Resolution in Oracle Data Guard in this article. You may want to read below articles two understand Oracle Data Guard architecture.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2020\/01\/02\/oracle-data-guard-architecture\/\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Data Guard Architecture<\/a>&#8220;,<br \/>\n&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2020\/01\/07\/oracle-data-guard-redo-transport-services\/\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Data Guard Redo Transport Services<\/a>&#8221;<\/p>\n<h2>What is Redo GAP?<\/h2>\n<p>In some cases, the LNS background process cannot transmit the generated redo data quickly enough and REDO GAP occurs. Some reasons for the occurrence of redo gap are as follows;<\/p>\n<ul>\n<li>Too many commits<\/li>\n<li>Network interruption<\/li>\n<li>Closing the standby database<\/li>\n<\/ul>\n<p id=\"KbmyFnq\"><img loading=\"lazy\" decoding=\"async\" width=\"616\" height=\"415\" class=\"size-full wp-image-14636  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e157aa73aee9.png\" alt=\"\" \/><\/p>\n<h2>What is Automatic GAP Resolution?<\/h2>\n<ul>\n<li>When the Redo GAP occurs, the LGWR background process continues to write to the &#8220;Online Redo Log&#8221; file, and when Redo is full, it continues to &#8220;Switch&#8221; to the next redo log file.<\/li>\n<li>When the switch occurs, the ARCH background process generates an archive. The ARCH background process continues to generate an archive file until the Primary to Standby problem is resolved.<\/li>\n<li>The ARCH process running on the primary database regularly pings the standby database during the interruption and checks to see if it responds.<\/li>\n<\/ul>\n<p>When the problem between Primary and Standby is solved;<\/p>\n<ul>\n<li>The ARCH process in the primary database determines the last received log file from the Primary by querying the &#8220;Standby Control File&#8221; over the RFS operation in the standby database.<\/li>\n<li>Data Guard automatically detects the &#8220;Archive Log Files&#8221; required to close the gap and tries to close the gap via the ARCH process.<\/li>\n<\/ul>\n<h3 class=\"LC20lb\">Check Log GAP Between Primary and Standby<\/h3>\n<p>You can learn log gap with two scripts;<\/p>\n<h4>Check Last Processed Archive at Stanby(Execute the script in Primary):<\/h4>\n<pre class=\"lang:default decode:true \">column arsiv_farki format a11\r\nSELECT a.resetlogs_id, DECODE (a.thread#, 1, 'node1', 2, 'node2') HOST, b.last_seq prmy_son_dosya,\r\n       a.applied_seq stdby_son_dosya, b.last_seq - a.applied_seq arsiv_farki, TO_CHAR (a.uygulanan_son_zaman, 'dd\/mm\/yyyy hh24:mi:ss') stdby_son_zaman\r\n  FROM (SELECT   resetlogs_id, thread#, MAX (sequence#) applied_seq, MAX (next_time) uygulanan_son_zaman\r\n            FROM v$archived_log\r\n           WHERE applied = 'YES'\r\n        GROUP BY resetlogs_id, thread#) a,\r\n       (SELECT   resetlogs_id, thread#, MAX (sequence#) last_seq\r\n            FROM v$archived_log\r\n        GROUP BY resetlogs_id, thread#) b\r\n WHERE a.thread# = b.thread#\r\n ORDER BY a.thread#;<\/pre>\n<h4>Check How Much LAG is between Primary and Standby(Execute the script in Standby):<\/h4>\n<pre class=\"lang:default decode:true  \">set linesize 500 feedback off pages 0 head off\r\ncolumn value format a12\r\ncolumn name format a13\r\ncolumn time_computed format a25\r\nSELECT  name, value, time_computed FROM v$dataguard_stats where name in ('transport lag','apply lag');<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14635\" class=\"pvc_stats all  \" data-element-id=\"14635\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I will explan Automatic GAP Resolution in Oracle Data Guard in this article. You may want to read below articles two understand Oracle Data Guard architecture. &#8220;Oracle Data Guard Architecture&#8220;, &#8220;Oracle Data Guard Redo Transport Services&#8221; What is Redo GAP? In some cases, the LNS background process cannot transmit the generated redo data quickly enough &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14635\" class=\"pvc_stats all  \" data-element-id=\"14635\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":484,"featured_media":14637,"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":[7532,7527,7526,7523,7536,7537,7539,7534,7524,7533,7538,7525,7535,7528,7529,7530,7531],"class_list":["post-14635","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-archive-gap-detection-and-resolution","tag-automatic-gap-detection-and-resolution","tag-automatic-gap-detection-and-resolution-in-standby-database","tag-automatic-gap-resolution","tag-check-how-much-lag-is-between-primary-and-standby","tag-check-lag-is-between-primary-and-standby","tag-check-last-processed-archive-at-stanby","tag-data-guard-archive-redo-gap","tag-data-guard-automatic-gap-resolution","tag-data-guard-gap-detection-and-resolution","tag-lag-between-primary-and-standby","tag-oracle-data-guard-automatic-gap-resolution","tag-resolving-gaps-in-data-guard","tag-what-is-log-gap-in-oracle","tag-what-is-log-gap-in-oracle-database","tag-what-is-logs-gap-in-oracle-database","tag-what-is-redo-gap"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":402,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Automatic GAP Resolution - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Automatic GAP Resolution\" \/>\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\/2020\/01\/08\/automatic-gap-resolution\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automatic GAP Resolution - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Automatic GAP Resolution\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-08T07:03:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"565\" \/>\n\t<meta property=\"og:image:height\" content=\"340\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Automatic GAP Resolution\",\"datePublished\":\"2020-01-08T07:03:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/\"},\"wordCount\":274,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-4.png\",\"keywords\":[\"ARCHIVE GAP DETECTION AND RESOLUTION\",\"Automatic Gap Detection and Resolution\",\"automatic gap detection and resolution in standby database\",\"Automatic GAP Resolution\",\"Check How Much LAG is between Primary and Standby\",\"Check LAG is between Primary and Standby\",\"Check Last Processed Archive at Stanby\",\"Data Guard archive redo gap\",\"data guard automatic gap resolution\",\"Data Guard Gap Detection and Resolution\",\"LAG between Primary and Standby\",\"oracle data guard automatic gap resolution\",\"Resolving Gaps in Data Guard\",\"what is log gap in oracle\",\"what is log gap in oracle database\",\"what is logs gap in oracle database\",\"What is Redo GAP\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/\",\"name\":\"Automatic GAP Resolution - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-4.png\",\"datePublished\":\"2020-01-08T07:03:05+00:00\",\"description\":\"Automatic GAP Resolution\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-4.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-4.png\",\"width\":565,\"height\":340},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Automatic GAP Resolution\"}]},{\"@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":"Automatic GAP Resolution - Database Tutorials","description":"Automatic GAP Resolution","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\/2020\/01\/08\/automatic-gap-resolution\/","og_locale":"en_US","og_type":"article","og_title":"Automatic GAP Resolution - Database Tutorials","og_description":"Automatic GAP Resolution","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-08T07:03:05+00:00","og_image":[{"width":565,"height":340,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-4.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Automatic GAP Resolution","datePublished":"2020-01-08T07:03:05+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/"},"wordCount":274,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-4.png","keywords":["ARCHIVE GAP DETECTION AND RESOLUTION","Automatic Gap Detection and Resolution","automatic gap detection and resolution in standby database","Automatic GAP Resolution","Check How Much LAG is between Primary and Standby","Check LAG is between Primary and Standby","Check Last Processed Archive at Stanby","Data Guard archive redo gap","data guard automatic gap resolution","Data Guard Gap Detection and Resolution","LAG between Primary and Standby","oracle data guard automatic gap resolution","Resolving Gaps in Data Guard","what is log gap in oracle","what is log gap in oracle database","what is logs gap in oracle database","What is Redo GAP"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/","name":"Automatic GAP Resolution - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-4.png","datePublished":"2020-01-08T07:03:05+00:00","description":"Automatic GAP Resolution","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-4.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-4.png","width":565,"height":340},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/08\/automatic-gap-resolution\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Automatic GAP Resolution"}]},{"@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\/14635","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=14635"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14635\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14637"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}