{"id":9218,"date":"2016-11-03T21:00:47","date_gmt":"2016-11-03T20:00:47","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/"},"modified":"2016-11-03T21:00:47","modified_gmt":"2016-11-03T20:00:47","slug":"dbvisit-replicate-when-you-flashback-the-target","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/","title":{"rendered":"Dbvisit replicate when you flashback the target"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nI had a quick question today about Dbvisit replicate as a solution to feed an Operational Data Store. The need is to run some end-of-month jobs on data from a specific state. The best way is to stop the APPLY at that fixed state for the duration of the job. Then no need for flashback query and no risk of ORA-1555. And what if we know this state only afterwards? Easy if the target is in Enterprise Edition, running in FLASHBACK ON. Then how to continue the APPLY? It&#8217;s easy with Dbvisit replicate. Here is an example.<br \/>\n<!--more--><br \/>\nOne solution would be to create a restore point before doing the flashback in order to be able to get forth to the state before the flashback and re-start the APPLY where it was stopped. But if we do that, we need to open the database READ ONLY for running the job on it.<br \/>\nThe other solution is to be able to re-start the apply at the point where the database has been flashed back. Do you think we have to get the right SCN, reset some configuration with it, etc? No. There&#8217;s something very simple and practical with Dbvisit replicate:<\/p>\n<ul>\n<li>The MINE configuration is stored in the source database<\/li>\n<li>The APPLY configuration is stored in the destination database<\/li>\n<\/ul>\n<p>When you install Dbvisit for the first time, you may wonder why there is not only one repository. But this architecture makes it easy as the metadata is stored with the related data.<\/p>\n<p>In my case, if I flashback the target database, the APPLY repository is flashed back as well, so the APPLY continues exactly at the right point<\/p>\n<p>But just in case let&#8217;s test it.<br \/>\nI use my old #repattack VMs, which explains why the dbvrep version is old, and why the time is on New Zealand time zone. Here is a running replication:<\/p>\n<pre><code>\n\/ Dbvisit Replicate 2.7.06.4485(MAX edition) - Evaluation License expires in 30 days\nMINE IS running. Currently at plog 392 and SCN 6648759 (11\/04\/2016 09:14:08).\nAPPLY IS running. Currently at plog 392 and SCN 6648742 (11\/04\/2016 09:14:06).\nProgress of replication dbvrep_XE:MINE-&gt;APPLY: total\/this execution\n--------------------------------------------------------------------------------------------------------------------------------------------\nREPOE.CUSTOMERS:              100%  Mine:210\/210         Unrecov:0\/0         Applied:210\/210     Conflicts:0\/0       Last:04\/11\/2016 09:09:13\/OK\nREPOE.ADDRESSES:              100%  Mine:210\/210         Unrecov:0\/0         Applied:210\/210     Conflicts:0\/0       Last:04\/11\/2016 09:09:13\/OK\nREPOE.CARD_DETAILS:           100%  Mine:195\/195         Unrecov:0\/0         Applied:195\/195     Conflicts:0\/0       Last:04\/11\/2016 09:09:13\/OK\nREPOE.ORDER_ITEMS:             99%  Mine:1553\/1553       Unrecov:0\/0         Applied:1550\/1550   Conflicts:0\/0       Last:04\/11\/2016 09:09:13\/OK\nREPOE.ORDERS:                  99%  Mine:1245\/1245       Unrecov:0\/0         Applied:1243\/1243   Conflicts:0\/0       Last:04\/11\/2016 09:09:13\/OK\nREPOE.INVENTORIES:             99%  Mine:1523\/1523       Unrecov:0\/0         Applied:1521\/1521   Conflicts:0\/0       Last:04\/11\/2016 09:09:13\/OK\nREPOE.LOGON:                   99%  Mine:1493\/1493       Unrecov:0\/0         Applied:1491\/1491   Conflicts:0\/0       Last:04\/11\/2016 09:09:13\/OK\n--------------------------------------------------------------------------------------------------------------------------------------------\n<\/code><\/pre>\n<p>I want to flashback to a quarter before, at 09:00, and because I&#8217;m in Oracle XE I&#8217;ll restore rather than flashback:<\/p>\n<pre><code>[oracle@target ~]$ rman target \/\n&nbsp;\nRecovery Manager: Release 11.2.0.2.0 - Production on Fri Nov 4 09:10:40 2016\n&nbsp;\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\n&nbsp;\nconnected to target database: XE (DBID=2736105154)\n&nbsp;\nRMAN&gt; startup force mount;\n&nbsp;\nOracle instance started\ndatabase mounted\n...<\/code><\/pre>\n<pre><code>RMAN&gt; restore database until time \"timestamp'2016-11-04 09:00:00'\";\n&nbsp;\nStarting restore at 04-NOV-16\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=10 device type=DISK<\/code><\/pre>\n<pre><code>RMAN&gt; recover database until time \"timestamp'2016-11-04 09:00:00'\";\n&nbsp;\nStarting recover at 04-NOV-16\nusing channel ORA_DISK_1\n&nbsp;\nstarting media recovery\n...\nmedia recovery complete, elapsed time: 00:02:17\nFinished recover at 04-NOV-16\n&nbsp;\nRMAN&gt; sql \"alter database open resetlogs\";\nsql statement: alter database open resetlogs<\/code><\/pre>\n<p>So the APPLY stopped because the destination was down, but the MINE continues:<\/p>\n<pre><code>- Dbvisit Replicate 2.7.06.4485(MAX edition) - Evaluation License expires in 30 days\nMINE IS running. Currently at plog 392 and SCN 6654476 (11\/04\/2016 09:27:12).\nCould not connect to APPLY process. Process not started or connection refused.\nProgress of replication dbvrep_XE:MINE-&gt;APPLY: total\/this execution\n--------------------------------------------------------------------------------------------------------------------------------------------\nREPOE.CUSTOMERS:              ---%  Mine:300\/300         Unrecov:0\/0         Applied:0\/0         Conflicts:0\/0       Last:--\/--\nREPOE.ADDRESSES:              ---%  Mine:300\/300         Unrecov:0\/0         Applied:0\/0         Conflicts:0\/0       Last:--\/--\nREPOE.CARD_DETAILS:           ---%  Mine:277\/277         Unrecov:0\/0         Applied:0\/0         Conflicts:0\/0       Last:--\/--\nREPOE.ORDER_ITEMS:            ---%  Mine:2178\/2178       Unrecov:0\/0         Applied:0\/0         Conflicts:0\/0       Last:--\/--\nREPOE.ORDERS:                 ---%  Mine:1735\/1735       Unrecov:0\/0         Applied:0\/0         Conflicts:0\/0       Last:--\/--\nREPOE.INVENTORIES:            ---%  Mine:2129\/2129       Unrecov:0\/0         Applied:0\/0         Conflicts:0\/0       Last:--\/--\nREPOE.LOGON:                  ---%  Mine:2109\/2109       Unrecov:0\/0         Applied:0\/0         Conflicts:0\/0       Last:--\/--\n--------------------------------------------------------------------------------------------------------------------------------------------<\/code><\/pre>\n<p>My database has been flashed back to its state at 09:00 and I can do what I want. Then I just re-start the APPLY:<\/p>\n<pre><code>[oracle@target dbvrep_XE]$ sh dbvrep_XE-run-target.sh\nInitializing......done\nDDC loaded from database (352 variables).\nDbvisit Replicate version 2.7.06.4485\nCopyright (C) Dbvisit Software Limited.  All rights reserved.\nDDC file \/u01\/app\/oracle\/dbvrep_XE\/dbvrep_XE-APPLY.ddc loaded.\nStarting process APPLY...started<\/code><\/pre>\n<p>and nothing to do manually, it restarts from where it needs, applying the changes from 09:00<\/p>\n<pre><code>\/ Dbvisit Replicate 2.7.06.4485(MAX edition) - Evaluation License expires in 30 days\nMINE IS running. Currently at plog 392 and SCN 6655130 (11\/04\/2016 09:28:33).\nAPPLY IS running. Currently at plog 392 and SCN 6645037 (11\/04\/2016 09:05:53).\nProgress of replication dbvrep_XE:MINE-&gt;APPLY: total\/this execution\n--------------------------------------------------------------------------------------------------------------------------------------------\nREPOE.CUSTOMERS:               46%  Mine:312\/312         Unrecov:0\/0         Applied:145\/12      Conflicts:0\/0       Last:04\/11\/2016 09:22:39\/OK\nREPOE.ADDRESSES:               46%  Mine:312\/312         Unrecov:0\/0         Applied:145\/12      Conflicts:0\/0       Last:04\/11\/2016 09:22:39\/OK\nREPOE.CARD_DETAILS:            46%  Mine:289\/289         Unrecov:0\/0         Applied:135\/11      Conflicts:0\/0       Last:04\/11\/2016 09:22:39\/OK\nREPOE.ORDER_ITEMS:             49%  Mine:2247\/2247       Unrecov:0\/0         Applied:1105\/80     Conflicts:0\/0       Last:04\/11\/2016 09:22:39\/OK\nREPOE.ORDERS:                  49%  Mine:1793\/1793       Unrecov:0\/0         Applied:890\/60      Conflicts:0\/0       Last:04\/11\/2016 09:22:39\/OK\nREPOE.INVENTORIES:             49%  Mine:2199\/2199       Unrecov:0\/0         Applied:1083\/77     Conflicts:0\/0       Last:04\/11\/2016 09:22:39\/OK\nREPOE.LOGON:                   48%  Mine:2183\/2183       Unrecov:0\/0         Applied:1055\/75     Conflicts:0\/0       Last:04\/11\/2016 09:22:39\/OK\n--------------------------------------------------------------------------------------------------------------------------------------------<\/code><\/pre>\n<p>This is quick as it has already been mined. The APPLY quickly resolved the gap:<\/p>\n<pre><code>- Dbvisit Replicate 2.7.06.4485(MAX edition) - Evaluation License expires in 30 days\nMINE IS running. Currently at plog 392 and SCN 6655589 (11\/04\/2016 09:29:36).\nAPPLY IS running. Currently at plog 392 and SCN 6655567 (11\/04\/2016 09:29:34).\nProgress of replication dbvrep_XE:MINE-&gt;APPLY: total\/this execution\n--------------------------------------------------------------------------------------------------------------------------------------------\nREPOE.CUSTOMERS:               99%  Mine:319\/319         Unrecov:0\/0         Applied:317\/184     Conflicts:0\/0       Last:04\/11\/2016 09:23:32\/OK\nREPOE.ADDRESSES:               99%  Mine:319\/319         Unrecov:0\/0         Applied:317\/184     Conflicts:0\/0       Last:04\/11\/2016 09:23:32\/OK\nREPOE.CARD_DETAILS:            99%  Mine:296\/296         Unrecov:0\/0         Applied:294\/170     Conflicts:0\/0       Last:04\/11\/2016 09:23:32\/OK\nREPOE.ORDER_ITEMS:             99%  Mine:2291\/2291       Unrecov:0\/0         Applied:2289\/1264   Conflicts:0\/0       Last:04\/11\/2016 09:23:32\/OK\nREPOE.ORDERS:                 100%  Mine:1828\/1828       Unrecov:0\/0         Applied:1828\/998    Conflicts:0\/0       Last:04\/11\/2016 09:23:32\/OK\nREPOE.INVENTORIES:            100%  Mine:2238\/2238       Unrecov:0\/0         Applied:2238\/1232   Conflicts:0\/0       Last:04\/11\/2016 09:23:32\/OK\nREPOE.LOGON:                   99%  Mine:2235\/2235       Unrecov:0\/0         Applied:2232\/1252   Conflicts:0\/0       Last:04\/11\/2016 09:23:32\/OK\n--------------------------------------------------------------------------------------------------------------------------------------------<\/code><\/pre>\n<p>Things are simple when they are well designed. The APPLY has to synchronize with the destination, so they have put the APPLY repository into the destination. No problem if the replication went further than the point in time you need to freeze. Any solution is possible as long ans the whole database is consistent: Flashback database, PITR, snapshots, etc.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . I had a quick question today about Dbvisit replicate as a solution to feed an Operational Data Store. The need is to run some end-of-month jobs on data from a specific state. The best way is to stop the APPLY at that fixed state for the duration of the job. Then [&hellip;]<\/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":[429,524,96],"type_dbi":[],"class_list":["post-9218","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-dbvisit-replicate","tag-flashback","tag-oracle"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Dbvisit replicate when you flashback the target - 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\/dbvisit-replicate-when-you-flashback-the-target\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dbvisit replicate when you flashback the target\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . I had a quick question today about Dbvisit replicate as a solution to feed an Operational Data Store. The need is to run some end-of-month jobs on data from a specific state. The best way is to stop the APPLY at that fixed state for the duration of the job. Then [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-03T20:00:47+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\/dbvisit-replicate-when-you-flashback-the-target\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Dbvisit replicate when you flashback the target\",\"datePublished\":\"2016-11-03T20:00:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/\"},\"wordCount\":471,\"commentCount\":0,\"keywords\":[\"Dbvisit replicate\",\"flashback\",\"Oracle\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/\",\"name\":\"Dbvisit replicate when you flashback the target - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-11-03T20:00:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dbvisit replicate when you flashback the target\"}]},{\"@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":"Dbvisit replicate when you flashback the target - 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\/dbvisit-replicate-when-you-flashback-the-target\/","og_locale":"en_US","og_type":"article","og_title":"Dbvisit replicate when you flashback the target","og_description":"By Franck Pachot . I had a quick question today about Dbvisit replicate as a solution to feed an Operational Data Store. The need is to run some end-of-month jobs on data from a specific state. The best way is to stop the APPLY at that fixed state for the duration of the job. Then [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/","og_site_name":"dbi Blog","article_published_time":"2016-11-03T20:00:47+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\/dbvisit-replicate-when-you-flashback-the-target\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Dbvisit replicate when you flashback the target","datePublished":"2016-11-03T20:00:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/"},"wordCount":471,"commentCount":0,"keywords":["Dbvisit replicate","flashback","Oracle"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/","url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/","name":"Dbvisit replicate when you flashback the target - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-11-03T20:00:47+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-replicate-when-you-flashback-the-target\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Dbvisit replicate when you flashback the target"}]},{"@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\/9218","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=9218"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9218\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9218"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}