{"id":33702,"date":"2022-03-12T17:08:19","date_gmt":"2022-03-12T17:08:19","guid":{"rendered":"https:\/\/dbtut.com\/?p=33702"},"modified":"2022-03-12T17:08:41","modified_gmt":"2022-03-12T17:08:41","slug":"standby-max-data-delay","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/","title":{"rendered":"Standby Max Data Delay"},"content":{"rendered":"<p>In today&#8217;s article, we will talk about Standby Max Data Delay.<\/p>\n<p>While some of the reporting users who make inquiries from Active Data Guard expect the retrieved data to be the same as the Production at that moment, others do not care if LAG has been formed for a few seconds.<\/p>\n<p>The time until this LAG in between is not important to them. But they do not want the result of such a query for higher. For such cases, ORACLE has created the STANDBY_MAX_DATA_DELAY parameter, which will be valid at the session level for the Standby side. This parameter takes seconds.<\/p>\n<h4>Use of:<\/h4>\n<pre class=\"lang:default decode:true \">ALTER SESSION SET STANDBY_MAX_DATA_DELAY = {INTEGER|NONE}\r\n<\/pre>\n<p>Let&#8217;s test it.<\/p>\n<p>1. We check whether the Data Guard is working properly on the Primary and Standby sides.<\/p>\n[Primary -1]\n<pre class=\"lang:default decode:true \">SQL&gt; select status from gv$instance;\r\n\r\nSTATUS\r\n------------\r\nOPEN\r\nOPEN\r\n<\/pre>\n[Primary -1]\n<pre class=\"lang:default decode:true \">SQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\r\n\r\nMAX(SEQUENCE#)    THREAD#\r\n-------------- ----------\r\n           107          1\r\n            57          2\r\n<\/pre>\n[Primary -2]\n<pre class=\"lang:default decode:true \">SQL&gt; alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\r\n\r\nMAX(SEQUENCE#)    THREAD#\r\n-------------- ----------\r\n           107          1\r\n            58          2\r\n<\/pre>\n[Primary -1]\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\r\n\r\nMAX(SEQUENCE#)    THREAD#\r\n-------------- ----------\r\n           107          1\r\n            58          2\r\n<\/pre>\n[Standby-1]\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\r\n\r\nMAX(SEQUENCE#)    THREAD#\r\n-------------- ----------\r\n           107          1\r\n            58          2\r\n<\/pre>\n[Standby-2]\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\r\n\r\nMAX(SEQUENCE#)    THREAD#\r\n-------------- ----------\r\n           107          1\r\n            58          2\r\n<\/pre>\n<p>2. We set the relevant parameter at session level to a user other than SYS.<\/p>\n[Standby -1]\n<pre class=\"lang:default decode:true \">SQL&gt; conn test\/test\r\nConnected.\r\nSQL&gt; show user\r\nUSER is \"TEST\"\r\nSQL&gt; alter session set standby_max_data_delay=5;\r\n\r\nSession altered.\r\n\r\nSQL&gt; select * from v$dataguard_stats;\r\n\r\nNAME                   VALUE                          UNIT                           TIME_COMPUTED        DATUM_TIME\r\n---------------------- ------------------------------ ------------------------------ -------------------- --------------------\r\ntransport lag          +00 00:00:00                   day(2) to second(0) interval   01\/04\/2017 10:27:03  01\/04\/2017 10:27:02\r\napply lag              +00 00:00:00                   day(2) to second(0) interval   01\/04\/2017 10:27:03  01\/04\/2017 10:27:02\r\napply finish time      +00 00:00:00.000               day(2) to second(3) interval   01\/04\/2017 10:27:03\r\nestimated startup time 31                             second                         01\/04\/2017 10:27:03\r\n<\/pre>\n<p>3.We stop the RECOVER process so that LAG can occur.<\/p>\n[Standby -1]\n<pre class=\"lang:default decode:true \">SQL&gt; alter database recover managed standby database cancel;\r\n\r\nDatabase altered.\r\n<\/pre>\n<p>4.We do a delete operation on the primary side.<\/p>\n[Primary-1]\n<pre class=\"lang:default decode:true\">SQL&gt; select * from test.countries_yedek;\r\n\r\nCO COUNTRY_NAME                              REGION_ID\r\n-- ---------------------------------------- ----------\r\nAR Argentina                                         2\r\nAU Australia                                         3\r\nBE Belgium                                           1\r\nBR Brazil                                            2\r\nCA Canada                                            2\r\nCH Switzerland                                       1\r\nCN China                                             3\r\nDE Germany                                           1\r\nDK Denmark                                           1\r\nEG Egypt                                             4\r\nFR France                                            1\r\n\r\nCO COUNTRY_NAME                              REGION_ID\r\n-- ---------------------------------------- ----------\r\nIL Israel                                            4\r\nIN India                                             3\r\nIT Italy                                             1\r\nJP Japan                                             3\r\nKW Kuwait                                            4\r\nML Malaysia                                          3\r\nMX Mexico                                            2\r\nNG Nigeria                                           4\r\nNL Netherlands                                       1\r\nSG Singapore                                         3\r\nUK United Kingdom                                    1\r\n\r\nCO COUNTRY_NAME                              REGION_ID\r\n-- ---------------------------------------- ----------\r\nUS United States of America                          2\r\nZM Zambia                                            4\r\nZW Zimbabwe                                          4\r\n\r\n25 rows selected.\r\n\r\nSQL&gt; delete test.countries_yedek where country_name='Zimbabwe';\r\n\r\n1 row deleted.\r\n\r\nSQL&gt; commit;\r\n\r\nCommit complete.\r\n<\/pre>\n<p>5. On the standby side, we make a query to see if the delete operation has taken place on the relevant table.<\/p>\n[Standby-1]\n<pre class=\"lang:default decode:true \">SQL&gt; select * from test.countries_yedek;\r\nselect * from test.countries_yedek\r\n                   *\r\nERROR at line 1:\r\nORA-00604: error occurred at recursive SQL level 1\r\nORA-03172: STANDBY_MAX_DATA_DELAY of 5 seconds exceeded<\/pre>\n<p>6.We learn the duration of the LAG to see that the system is working correctly.<\/p>\n[Standby-1]\n<pre class=\"lang:default decode:true\">SQL&gt; conn sys\/Passw0rd4 as sysdba\r\nConnected.\r\nSQL&gt; show user\r\nUSER is \"SYS\"\r\nSQL&gt; column name format a22\r\nSQL&gt; column value format a15\r\nSQL&gt; column value format a30\r\nSQL&gt; column datum_time format a20\r\nSQL&gt; column time_computed format a20\r\nSQL&gt; set linesize 9000\r\nSQL&gt; select * from v$dataguard_stats;\r\n\r\nNAME                   VALUE                          UNIT                           TIME_COMPUTED        DATUM_TIME\r\n---------------------- ------------------------------ ------------------------------ -------------------- --------------------\r\ntransport lag          +00 00:00:00                   day(2) to second(0) interval   01\/04\/2017 10:32:04  01\/04\/2017 10:32:04\r\napply lag              +00 00:02:57                   day(2) to second(0) interval   01\/04\/2017 10:32:04  01\/04\/2017 10:32:04\r\napply finish time      +00 00:00:00.025               day(2) to second(3) interval   01\/04\/2017 10:32:04\r\nestimated startup time 31                             second                         01\/04\/2017 10:32:04\r\n<\/pre>\n<p>7. Since the user&#8217;s session is broken, we reconnect and query.<\/p>\n[Standby-1]\n<pre class=\"lang:default decode:true \">SQL&gt; conn test\/test \r\nConnected.\r\nSQL&gt; select * from test.countries_yedek;\r\n\r\nCO COUNTRY_NAME                              REGION_ID\r\n-- ---------------------------------------- ----------\r\nAR Argentina                                         2\r\nAU Australia                                         3\r\nBE Belgium                                           1\r\nBR Brazil                                            2\r\nCA Canada                                            2\r\nCH Switzerland                                       1\r\nCN China                                             3\r\nDE Germany                                           1\r\nDK Denmark                                           1\r\nEG Egypt                                             4\r\nFR France                                            1\r\n\r\nCO COUNTRY_NAME                              REGION_ID\r\n-- ---------------------------------------- ----------\r\nIL Israel                                            4\r\nIN India                                             3\r\nIT Italy                                             1\r\nJP Japan                                             3\r\nKW Kuwait                                            4\r\nML Malaysia                                          3\r\nMX Mexico                                            2\r\nNG Nigeria                                           4\r\nNL Netherlands                                       1\r\nSG Singapore                                         3\r\nUK United Kingdom                                    1\r\n\r\nCO COUNTRY_NAME                              REGION_ID\r\n-- ---------------------------------------- ----------\r\nUS United States of America                          2\r\nZM Zambia                                            4\r\nZW Zimbabwe                                          4\r\n\r\n25 rows selected.\r\n<\/pre>\n<p>8.We initiate the RECOVER operation and query.<\/p>\n[Standby-1]\n<pre class=\"lang:default decode:true \">SQL&gt; conn sys\/Passw0rd4 as sysdba\r\nConnected.\r\nSQL&gt; alter database recover managed standby database using current logfile disconnect;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; conn test\/test\r\nConnected.\r\nSQL&gt; select * from test.countries_yedek;\r\n\r\nCO COUNTRY_NAME                              REGION_ID\r\n-- ---------------------------------------- ----------\r\nAR Argentina                                         2\r\nAU Australia                                         3\r\nBE Belgium                                           1\r\nBR Brazil                                            2\r\nCA Canada                                            2\r\nCH Switzerland                                       1\r\nCN China                                             3\r\nDE Germany                                           1\r\nDK Denmark                                           1\r\nEG Egypt                                             4\r\nFR France                                            1\r\n\r\nCO COUNTRY_NAME                              REGION_ID\r\n-- ---------------------------------------- ----------\r\nIL Israel                                            4\r\nIN India                                             3\r\nIT Italy                                             1\r\nJP Japan                                             3\r\nKW Kuwait                                            4\r\nML Malaysia                                          3\r\nMX Mexico                                            2\r\nNG Nigeria                                           4\r\nNL Netherlands                                       1\r\nSG Singapore                                         3\r\nUK United Kingdom                                    1\r\n\r\nCO COUNTRY_NAME                              REGION_ID\r\n-- ---------------------------------------- ----------\r\nUS United States of America                          2\r\nZM Zambia                                            4\r\n\r\n24 rows selected.\r\n<\/pre>\n<p>9.Everything is Ok.<\/p>\n<p>10. If I want, I can make this process permanent with an AFTER LOGON TRIGGER.<\/p>\n[Primary-1]\n<pre class=\"lang:default decode:true \">SQL&gt; conn test\/test\r\nConnected.\r\nSQL&gt; show user\r\nUSER is \"TEST\"\r\nSQL&gt; CREATE OR REPLACE TRIGGER sla_logon_trigger\r\n  2  AFTER LOGON\r\n  3  ON TEST.SCHEMA\r\n  4  BEGIN\r\n  5  IF (SYS_CONTEXT('USERENV', 'DATABASE_ROLE')\r\n  6  IN ('PHYSICAL STANDBY'))\r\n  7  THEN execute immediate\r\n  8  'alter session set standby_max_data_delay=5';\r\n  9  END IF;\r\n 10  END;\r\n 11  \/\r\n\r\nTrigger created\r\n<\/pre>\n<p>11. RECOVER is stopped so that LAG can occur.<\/p>\n[Standby-1]\n<pre class=\"lang:default decode:true \">SQL&gt; alter database recover managed standby database cancel;\r\n\r\nDatabase altered.<\/pre>\n<p>12. The user tries to login.<\/p>\n[Standby-1]\n<p id=\"jAhdsRx\"><img loading=\"lazy\" decoding=\"async\" width=\"634\" height=\"208\" class=\"size-full wp-image-33736 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/img_622cd1b1e4e4a.png\" alt=\"\" \/><\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; conn test\/test\r\nERROR:\r\nORA-03172: STANDBY_MAX_DATA_DELAY of 5 seconds exceeded\r\n[oracle@standby1 ~]$\r\n<\/pre>\n<p>13. We check if other users have problems.<\/p>\n[Standby-1]\n<pre class=\"lang:default decode:true\">SQL&gt; conn standby\/standby\r\nConnected.\r\n<\/pre>\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_33702\" class=\"pvc_stats all  \" data-element-id=\"33702\" 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>In today&#8217;s article, we will talk about Standby Max Data Delay. While some of the reporting users who make inquiries from Active Data Guard expect the retrieved data to be the same as the Production at that moment, others do not care if LAG has been formed for a few seconds. The time until this &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_33702\" class=\"pvc_stats all  \" data-element-id=\"33702\" 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":33739,"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-33702","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":138,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Standby Max Data Delay - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today&#039;s article, we will talk about Standby Max Data Delay.While some of the reporting users who make inquiries from Active Data Guard\" \/>\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\/12\/standby-max-data-delay\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Standby Max Data Delay - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today&#039;s article, we will talk about Standby Max Data Delay.While some of the reporting users who make inquiries from Active Data Guard\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-12T17:08:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-12T17:08:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-8.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"778\" \/>\n\t<meta property=\"og:image:height\" content=\"270\" \/>\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=\"5 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\/12\/standby-max-data-delay\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Standby Max Data Delay\",\"datePublished\":\"2022-03-12T17:08:19+00:00\",\"dateModified\":\"2022-03-12T17:08:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/\"},\"wordCount\":275,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-8.jpg\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/\",\"name\":\"Standby Max Data Delay - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-8.jpg\",\"datePublished\":\"2022-03-12T17:08:19+00:00\",\"dateModified\":\"2022-03-12T17:08:41+00:00\",\"description\":\"In today's article, we will talk about Standby Max Data Delay.While some of the reporting users who make inquiries from Active Data Guard\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-8.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-8.jpg\",\"width\":778,\"height\":270},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Standby Max Data Delay\"}]},{\"@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":"Standby Max Data Delay - Database Tutorials","description":"In today's article, we will talk about Standby Max Data Delay.While some of the reporting users who make inquiries from Active Data Guard","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\/12\/standby-max-data-delay\/","og_locale":"en_US","og_type":"article","og_title":"Standby Max Data Delay - Database Tutorials","og_description":"In today's article, we will talk about Standby Max Data Delay.While some of the reporting users who make inquiries from Active Data Guard","og_url":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/","og_site_name":"Database Tutorials","article_published_time":"2022-03-12T17:08:19+00:00","article_modified_time":"2022-03-12T17:08:41+00:00","og_image":[{"width":778,"height":270,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-8.jpg","type":"image\/jpeg"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Standby Max Data Delay","datePublished":"2022-03-12T17:08:19+00:00","dateModified":"2022-03-12T17:08:41+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/"},"wordCount":275,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-8.jpg","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/","url":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/","name":"Standby Max Data Delay - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-8.jpg","datePublished":"2022-03-12T17:08:19+00:00","dateModified":"2022-03-12T17:08:41+00:00","description":"In today's article, we will talk about Standby Max Data Delay.While some of the reporting users who make inquiries from Active Data Guard","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-8.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/03\/Ekran-Alintisi-8.jpg","width":778,"height":270},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/03\/12\/standby-max-data-delay\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Standby Max Data Delay"}]},{"@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\/33702","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=33702"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/33702\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/33739"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=33702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=33702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=33702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}