{"id":9949,"date":"2017-04-13T07:28:55","date_gmt":"2017-04-13T05:28:55","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/"},"modified":"2017-04-13T07:28:55","modified_gmt":"2017-04-13T05:28:55","slug":"oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/","title":{"rendered":"Oracle 12c &#8211; Why you shouldn&#8217;t do a crosscheck archivelog all in your regular RMAN backup scripts"},"content":{"rendered":"<h2>By William Sescu<\/h2>\n<p>Crosschecking in RMAN is quite cool stuff. With the RMAN crosscheck you can update an outdated RMAN repository about backups or archivelogs whose repository records do not match their physical status.<\/p>\n<p>For example, if a user removes archived logs from disk with an operating system command, the repository (RMAN controlfile or RMAN catalog) still indicates that the logs are on disk, when in fact they are not. It is important to know, that the RMAN CROSSCHECK command never deletes any operating system files or removes any repository records, it just updates the repository with the correct information. In case you really want to delete something, you must use the DELETE command for these operations.<\/p>\n<p>Manually removing archived logs or anything else out of the fast recovery area is something you should never do, however, in reality it still happens.<\/p>\n<p>But when it happens, you want know which files are not on their physical location. So why not running a crosscheck archivelog all regularly in your backup scripts? Is it not a good idea?<\/p>\n<p>From my point of view it is not. For two reason:<\/p>\n<ul>\n<li>Your backup script runs slower because you do an extra step<\/li>\n<li>But for and foremost you will not notice if an archived log is missing<\/li>\n<\/ul>\n<p>Let&#8217;s run a little test case. I simply move one archived log away and run the backup archivelog all command afterwards.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@dbidg03:\/u03\/fast_recovery_area\/CDB\/archivelog\/2017_03_30\/ [CDB (CDB$ROOT)] mv o1_mf_1_61_dfso8r7p_.arc o1_mf_1_61_dfso8r7p_.arc.20170413a\n\nRMAN&gt; backup archivelog all;\n\nStarting backup at 13-APR-2017 08:03:14\ncurrent log archived\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=281 device type=DISK\nallocated channel: ORA_DISK_2\nchannel ORA_DISK_2: SID=44 device type=DISK\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of backup command at 04\/13\/2017 08:03:17\nRMAN-06059: expected archived log not found, loss of archived log compromises recoverability\nORA-19625: error identifying file \/u03\/fast_recovery_area\/CDB\/archivelog\/2017_03_30\/o1_mf_1_61_dfso8r7p_.arc\nORA-27037: unable to obtain file status\nLinux-x86_64 Error: 2: No such file or directory\nAdditional information: 7<\/pre>\n<p>This is exactly what I have expected. I want to have a clear error message in case an archived log is missing. I don&#8217;t want Oracle to skip over it and just continue as if nothing has happened. But what happens if I run a crosscheck archivelog all before running my backup command?<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">RMAN&gt; crosscheck archivelog all;\n\nreleased channel: ORA_DISK_1\nreleased channel: ORA_DISK_2\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=281 device type=DISK\nallocated channel: ORA_DISK_2\nchannel ORA_DISK_2: SID=44 device type=DISK\nvalidation succeeded for archived log\narchived log file name=\/u03\/fast_recovery_area\/CDB\/archivelog\/2017_03_28\/o1_mf_1_56_dfmzywt1_.arc RECID=73 STAMP=939802622\nvalidation succeeded for archived log\narchived log file name=\/u03\/fast_recovery_area\/CDB\/archivelog\/2017_03_28\/o1_mf_1_57_dfo40o1g_.arc RECID=74 STAMP=939839542\nvalidation succeeded for archived log\narchived log file name=\/u03\/fast_recovery_area\/CDB\/archivelog\/2017_03_29\/o1_mf_1_58_dfovy7cj_.arc RECID=75 STAMP=939864041\nvalidation succeeded for archived log\narchived log file name=\/u03\/fast_recovery_area\/CDB\/archivelog\/2017_03_29\/o1_mf_1_59_dfq7pcwz_.arc RECID=76 STAMP=939908847\nvalidation succeeded for archived log\narchived log file name=\/u03\/fast_recovery_area\/CDB\/archivelog\/2017_03_30\/o1_mf_1_60_dfrg8f8o_.arc RECID=77 STAMP=939948334\nvalidation succeeded for archived log\narchived log file name=\/u03\/fast_recovery_area\/CDB\/archivelog\/2017_03_31\/o1_mf_1_62_dfv0kybr_.arc RECID=79 STAMP=940032607\nvalidation succeeded for archived log\narchived log file name=\/u03\/fast_recovery_area\/CDB\/archivelog\/2017_03_31\/o1_mf_1_63_dfw5s2l8_.arc RECID=80 STAMP=940070724\nvalidation succeeded for archived log\narchived log file name=\/u03\/fast_recovery_area\/CDB\/archivelog\/2017_04_12\/o1_mf_1_64_dgw5mgsl_.arc RECID=81 STAMP=941119119\nvalidation succeeded for archived log\narchived log file name=\/u03\/fast_recovery_area\/CDB\/archivelog\/2017_04_13\/o1_mf_1_65_dgy552z0_.arc RECID=82 STAMP=941184196\nCrosschecked 9 objects\n\nvalidation failed for archived log\narchived log file name=\/u03\/fast_recovery_area\/CDB\/archivelog\/2017_03_30\/o1_mf_1_61_dfso8r7p_.arc RECID=78 STAMP=939988281\nCrosschecked 1 objects\nRMAN&gt;<\/pre>\n<p>The crosscheck validation failed for the archived log which I have moved beforehand. Perfect, the crosscheck has found the issue.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">RMAN&gt; list expired backup;\n\nspecification does not match any backup in the repository\n\nRMAN&gt; list expired archivelog all;\n\nList of Archived Log Copies for database with db_unique_name CDB\n=====================================================================\n\nKey     Thrd Seq     S Low Time\n------- ---- ------- - --------------------\n78      1    61      X 30-MAR-2017 00:45:33\n        Name: \/u03\/fast_recovery_area\/CDB\/archivelog\/2017_03_30\/o1_mf_1_61_dfso8r7p_.arc<\/pre>\n<p>However, If I run the backup archivelog all afterwards, RMAN continues as if nothing has ever happened, and in case you are not monitoring expired archived logs or backups, you will never notice it.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">RMAN&gt; backup archivelog all;\n\nStarting backup at 13-APR-2017 08:05:01\ncurrent log archived\nusing channel ORA_DISK_1\nusing channel ORA_DISK_2\nchannel ORA_DISK_1: starting compressed archived log backup set\nchannel ORA_DISK_1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=56 RECID=73 STAMP=939802622\ninput archived log thread=1 sequence=57 RECID=74 STAMP=939839542\ninput archived log thread=1 sequence=58 RECID=75 STAMP=939864041\ninput archived log thread=1 sequence=59 RECID=76 STAMP=939908847\ninput archived log thread=1 sequence=60 RECID=77 STAMP=939948334\nchannel ORA_DISK_1: starting piece 1 at 13-APR-2017 08:05:01\nchannel ORA_DISK_2: starting compressed archived log backup set\nchannel ORA_DISK_2: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=62 RECID=79 STAMP=940032607\ninput archived log thread=1 sequence=63 RECID=80 STAMP=940070724\ninput archived log thread=1 sequence=64 RECID=81 STAMP=941119119\ninput archived log thread=1 sequence=65 RECID=82 STAMP=941184196\ninput archived log thread=1 sequence=66 RECID=83 STAMP=941184301\nchannel ORA_DISK_2: starting piece 1 at 13-APR-2017 08:05:01\nchannel ORA_DISK_2: finished piece 1 at 13-APR-2017 08:05:47\npiece handle=\/u03\/fast_recovery_area\/CDB\/backupset\/2017_04_13\/o1_mf_annnn_TAG20170413T080501_dgy58fz7_.bkp tag=TAG20170413T080501 comment=NONE\nchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:46\nchannel ORA_DISK_1: finished piece 1 at 13-APR-2017 08:06:07\npiece handle=\/u03\/fast_recovery_area\/CDB\/backupset\/2017_04_13\/o1_mf_annnn_TAG20170413T080501_dgy58fy4_.bkp tag=TAG20170413T080501 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:06\nFinished backup at 13-APR-2017 08:06:07\n\nStarting Control File and SPFILE Autobackup at 13-APR-2017 08:06:07\npiece handle=\/u03\/fast_recovery_area\/CDB\/autobackup\/2017_04_13\/o1_mf_s_941184367_dgy5bh7w_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 13-APR-2017 08:06:08\n\nRMAN&gt;<\/pre>\n<p>But is this really what I want? Probably not. Whenever an archived log is missing, RMAN should stop right away and throw an error message. This gives me the chance to check what was going wrong and the possibility to correct it.<\/p>\n<h3>Conclusion<\/h3>\n<p>I don&#8217;t recommend to run the crosscheck archivelog all in your regular RMAN backup scripts. This is a command that should be run manually in case it is needed. You just make your backup slower (ok, not too much but still), and you will probably never notice when an archived log is missing, which can lead to a database which can only be recovered to the point before the missing archived log.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By William Sescu Crosschecking in RMAN is quite cool stuff. With the RMAN crosscheck you can update an outdated RMAN repository about backups or archivelogs whose repository records do not match their physical status. For example, if a user removes archived logs from disk with an operating system command, the repository (RMAN controlfile or RMAN [&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":[1025,270],"type_dbi":[],"class_list":["post-9949","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-oracle-12cr2","tag-rman"],"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>Oracle 12c - Why you shouldn&#039;t do a crosscheck archivelog all in your regular RMAN backup scripts - 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\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 12c - Why you shouldn&#039;t do a crosscheck archivelog all in your regular RMAN backup scripts\" \/>\n<meta property=\"og:description\" content=\"By William Sescu Crosschecking in RMAN is quite cool stuff. With the RMAN crosscheck you can update an outdated RMAN repository about backups or archivelogs whose repository records do not match their physical status. For example, if a user removes archived logs from disk with an operating system command, the repository (RMAN controlfile or RMAN [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-13T05:28:55+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=\"6 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\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 12c &#8211; Why you shouldn&#8217;t do a crosscheck archivelog all in your regular RMAN backup scripts\",\"datePublished\":\"2017-04-13T05:28:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/\"},\"wordCount\":476,\"commentCount\":0,\"keywords\":[\"Oracle 12cR2\",\"RMAN\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/\",\"name\":\"Oracle 12c - Why you shouldn't do a crosscheck archivelog all in your regular RMAN backup scripts - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-04-13T05:28:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 12c &#8211; Why you shouldn&#8217;t do a crosscheck archivelog all in your regular RMAN backup scripts\"}]},{\"@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":"Oracle 12c - Why you shouldn't do a crosscheck archivelog all in your regular RMAN backup scripts - 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\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 12c - Why you shouldn't do a crosscheck archivelog all in your regular RMAN backup scripts","og_description":"By William Sescu Crosschecking in RMAN is quite cool stuff. With the RMAN crosscheck you can update an outdated RMAN repository about backups or archivelogs whose repository records do not match their physical status. For example, if a user removes archived logs from disk with an operating system command, the repository (RMAN controlfile or RMAN [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/","og_site_name":"dbi Blog","article_published_time":"2017-04-13T05:28:55+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 12c &#8211; Why you shouldn&#8217;t do a crosscheck archivelog all in your regular RMAN backup scripts","datePublished":"2017-04-13T05:28:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/"},"wordCount":476,"commentCount":0,"keywords":["Oracle 12cR2","RMAN"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/","name":"Oracle 12c - Why you shouldn't do a crosscheck archivelog all in your regular RMAN backup scripts - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-04-13T05:28:55+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12c-why-you-shouldnt-do-a-crosscheck-archivelog-all-in-your-regular-rman-backup-scripts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 12c &#8211; Why you shouldn&#8217;t do a crosscheck archivelog all in your regular RMAN backup scripts"}]},{"@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\/9949","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=9949"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9949\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9949"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}