{"id":8061,"date":"2016-05-26T09:20:21","date_gmt":"2016-05-26T07:20:21","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/"},"modified":"2016-05-26T09:20:21","modified_gmt":"2016-05-26T07:20:21","slug":"db_flashback_retention_target-may-hang-your-database","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/","title":{"rendered":"DB_FLASHBACK_RETENTION_TARGET may hang your database"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nDB_FLASHBACK_RETENTION_TARGET is set to keep enough flashback logs to be able to flashback database within the specified retention window. But it&#8217;s supposed to be a target only, meaning that on space pressure some files can be deleted. But be careful, there are cases where they are not and then the database hangs until you set a lower retention.<br \/>\n<!--more--><br \/>\nThe fun part is the message telling you that it cannot reclaim space from a 50GB FRA where 0% is used:<\/p>\n<blockquote class=\"twitter-tweet\" data-width=\"500\" data-dnt=\"true\">\n<p lang=\"en\" dir=\"ltr\">Humm&#8230;<br \/>Can&#39;t reclaim space because 0% is used <a href=\"https:\/\/t.co\/4snP3OQZUV\">pic.twitter.com\/4snP3OQZUV<\/a><\/p>\n<p>&mdash; Franck Pachot (@FranckPachot) <a href=\"https:\/\/twitter.com\/FranckPachot\/status\/735747180577718272?ref_src=twsrc%5Etfw\">May 26, 2016<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>Less funny is the primary database hanging because its own FRA is full (deletion policy being APPLIED ON ALL STANDBY)<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCDB02FLASHBACKRET.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCDB02FLASHBACKRET.png\" alt=\"CaptureCDB02FLASHBACKRET\" width=\"1920\" height=\"372\" class=\"alignnone size-full wp-image-8830\" \/><\/a><\/p>\n<h3>What happened<\/h3>\n<p>So, I&#8217;ve a Data Guard configuration where the deletion policy is &#8216;APPLIED ON ALL STANDBY&#8217; and both sites have FLASHBACK ON.<\/p>\n<p>I&#8217;ve no guaranteed restore points:<\/p>\n<pre><code>\nRMAN&gt; list restore point all;\n&nbsp;\nusing target database control file instead of recovery catalog\nSCN              RSP Time  Type       Time      Name\n---------------- --------- ---------- --------- ----\n&nbsp;\n<\/code><\/pre>\n<p>and flashback retention is 1 day to allow a possible reinstate, or simple to allow to use the standby to flashback to recent point in time:<\/p>\n<pre><code>\nSQL&gt; show parameter flashback\n&nbsp;\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_flashback_retention_target        integer     1440\n<\/code><\/pre>\n<p>Here is the space usage of my standby database FRA when I have high activity on the primary:<\/p>\n<pre><code>\nSQL&gt; select * from v$recovery_area_usage;\n&nbsp;\nFILE_TYPE               PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES     CON_ID\n----------------------- ------------------ ------------------------- --------------- ----------\nCONTROL FILE                             0                         0               0          0\nREDO LOG                                 0                         0               0          0\nARCHIVED LOG                             0                         0               0          0\nBACKUP PIECE                            .1                         0               3          0\nIMAGE COPY                               0                         0               0          0\nFLASHBACK LOG                         98.5                         0              50          0\nFOREIGN ARCHIVED LOG                     0                         0               0          0\nAUXILIARY DATAFILE COPY                  0                         0               0          0\n<\/code><\/pre>\n<p>FLASHBACK LOG are filling the 50GB I have because I generate more than 50GB of changes per day. They are not set as reclaimable but I expected that they can be reclaimaible in case of space pressure on FRA because the retention is a target retention &#8211; not a guaranteed retention.<\/p>\n<p>ARCHIVED LOG become reclaimable as soon as they are applied thanks to the deletion policy. And they are actually reclaimed because space is needed for flashback logs.<\/p>\n<p>At that point, I can expect that when new redo is coming the archived logs can always be written because archived logs have priority on non-guaranteed flashback logs.<\/p>\n<p>I forgot to tell you that the UNDO tablespace has not been created with RETENTION GUARANTEE:<\/p>\n<pre><code>\nSQL&gt; select contents,retention from dba_tablespaces;\n&nbsp;\nCONTENTS  RETENTION\n--------- -----------\nPERMANENT NOT APPLY\nPERMANENT NOT APPLY\nUNDO      NOGUARANTEE\nTEMPORARY NOT APPLY\nPERMANENT NOT APPLY\n<\/code><\/pre>\n<p>But actually, my standby database is in an archiver stuck situation:<\/p>\n<pre><code>\nThu May 26 07:42:01 2016\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/cdb_02\/CDB\/trace\/CDB_arc1_5612.trc:\nORA-19815: WARNING: db_recovery_file_dest_size of 53687091200 bytes is 0.00% used, and has 53687091200 remaining bytes available.\nThu May 26 07:42:01 2016\n************************************************************************\nYou have following choices to free up space from recovery area:\n1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,\n   then consider changing RMAN ARCHIVELOG DELETION POLICY.\n2. Back up files to tertiary device such as tape using RMAN\n   BACKUP RECOVERY AREA command.\n3. Add disk space and increase db_recovery_file_dest_size parameter to\n   reflect the new space.\n4. Delete unnecessary files using RMAN DELETE command. If an operating\n   system command was used to delete files, then use RMAN CROSSCHECK and\n   DELETE EXPIRED commands.\n************************************************************************\nThu May 26 07:42:01 2016\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/cdb_02\/CDB\/trace\/CDB_arc1_5612.trc:\nORA-19809: limit exceeded for recovery files\nORA-19804: cannot reclaim 1073741824 bytes disk space from 53687091200 limit\nThu May 26 07:43:01 2016\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/cdb_02\/CDB\/trace\/CDB_arc1_5612.trc:\nORA-19815: WARNING: db_recovery_file_dest_size of 53687091200 bytes is 0.00% used, and has 53687091200 remaining bytes available.\nThu May 26 07:43:01 2016\n************************************************************************\nYou have following choices to free up space from recovery area:\n1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,\n   then consider changing RMAN ARCHIVELOG DELETION POLICY.\n2. Back up files to tertiary device such as tape using RMAN\n   BACKUP RECOVERY AREA command.\n3. Add disk space and increase db_recovery_file_dest_size parameter to\n   reflect the new space.\n4. Delete unnecessary files using RMAN DELETE command. If an operating\n   system command was used to delete files, then use RMAN CROSSCHECK and\n   DELETE EXPIRED commands.\n************************************************************************\nThu May 26 07:43:01 2016\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/cdb_02\/CDB\/trace\/CDB_arc1_5612.trc:\nORA-19809: limit exceeded for recovery files\nORA-19804: cannot reclaim 1073741824 bytes disk space from 53687091200 limit\nThu May 26 07:43:46 2016\n<\/code><\/pre>\n<p>This blocks the standby with a big gap and this may have bad consequence on primary availability and protection.<\/p>\n<h3>Workaround<\/h3>\n<p>The workaround is to lower the flashback retention target so that all changes fit in the FRA:<\/p>\n<pre><code>\nSQL&gt; alter system set db_flashback_retention_target=60;\n<\/code><\/pre>\n<p>and as soon as I did it some flashback logs became reclaimable:<\/p>\n<pre><code>\nSQL&gt; select * from v$recovery_area_usage;\n&nbsp;\nFILE_TYPE               PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES     CON_ID\n----------------------- ------------------ ------------------------- --------------- ----------\nCONTROL FILE                             0                         0               0          0\nREDO LOG                                 0                         0               0          0\nARCHIVED LOG                             0                         0               0          0\nBACKUP PIECE                            .1                         0               3          0\nIMAGE COPY                               0                         0               0          0\nFLASHBACK LOG                         96.5                        68              49          0\nFOREIGN ARCHIVED LOG                     0                         0               0          0\nAUXILIARY DATAFILE COPY                  0                         0               0          0\n<\/code><\/pre>\n<p>Which you can see in the alert.log as they are deleted to reclaim space:<\/p>\n<pre><code>\nThu May 26 07:43:46 2016\nALTER SYSTEM SET db_flashback_retention_target=60 SCOPE=BOTH;\nThu May 26 07:44:01 2016\nDeleted Oracle managed file \/u03\/app\/oracle\/fast_recovery_area\/CDB_02\/flashback\/o1_mf_cncs7qnx_.flb\nDeleted Oracle managed file \/u03\/app\/oracle\/fast_recovery_area\/CDB_02\/archivelog\/2016_05_26\/o1_mf_0_0_cnfbb1b4_.arc\n<\/code><\/pre>\n<h3>Conclusion<\/h3>\n<p>I&#8217;ll open a SR for it (easier to format in WordPress than in MOS). This is in 12<em>c<\/em>R1 multitenant with Patch Set Update : 12.1.0.2.160119<br \/>\nFor the moment, the recommandation is: always monitor the FRA for (used-reclaimable) space even in a standby where archvielogs become reclaimable as soon as they are applied.<\/p>\n<h3>Update 19-JUN-2016<\/h3>\n<p>The recommandation is to monitor ORA-19815 and ignore the 0%. There is a BUG 16664572 (DIAG: IMPROVE DIAGNOSTIC RELATED TO ORA-19815) about that problem under dev.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . DB_FLASHBACK_RETENTION_TARGET is set to keep enough flashback logs to be able to flashback database within the specified retention window. But it&#8217;s supposed to be a target only, meaning that on space pressure some files can be deleted. But be careful, there are cases where they are not and then the database [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":8063,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[220,221,64,96,66,223],"type_dbi":[],"class_list":["post-8061","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-cdb","tag-data-guard","tag-multitenant","tag-oracle","tag-pdb","tag-pluggable-databases"],"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>DB_FLASHBACK_RETENTION_TARGET may hang your database - 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\/db_flashback_retention_target-may-hang-your-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DB_FLASHBACK_RETENTION_TARGET may hang your database\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . DB_FLASHBACK_RETENTION_TARGET is set to keep enough flashback logs to be able to flashback database within the specified retention window. But it&#8217;s supposed to be a target only, meaning that on space pressure some files can be deleted. But be careful, there are cases where they are not and then the database [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-26T07:20:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCDB02FLASHBACKRET-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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\/db_flashback_retention_target-may-hang-your-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"DB_FLASHBACK_RETENTION_TARGET may hang your database\",\"datePublished\":\"2016-05-26T07:20:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/\"},\"wordCount\":466,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCDB02FLASHBACKRET-1.png\",\"keywords\":[\"CDB\",\"Data Guard\",\"multitenant\",\"Oracle\",\"PDB\",\"Pluggable Databases\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/\",\"name\":\"DB_FLASHBACK_RETENTION_TARGET may hang your database - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCDB02FLASHBACKRET-1.png\",\"datePublished\":\"2016-05-26T07:20:21+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCDB02FLASHBACKRET-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCDB02FLASHBACKRET-1.png\",\"width\":1920,\"height\":372},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DB_FLASHBACK_RETENTION_TARGET may hang your database\"}]},{\"@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":"DB_FLASHBACK_RETENTION_TARGET may hang your database - 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\/db_flashback_retention_target-may-hang-your-database\/","og_locale":"en_US","og_type":"article","og_title":"DB_FLASHBACK_RETENTION_TARGET may hang your database","og_description":"By Franck Pachot . DB_FLASHBACK_RETENTION_TARGET is set to keep enough flashback logs to be able to flashback database within the specified retention window. But it&#8217;s supposed to be a target only, meaning that on space pressure some files can be deleted. But be careful, there are cases where they are not and then the database [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/","og_site_name":"dbi Blog","article_published_time":"2016-05-26T07:20:21+00:00","og_image":[{"width":1920,"height":372,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCDB02FLASHBACKRET-1.png","type":"image\/png"}],"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\/db_flashback_retention_target-may-hang-your-database\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"DB_FLASHBACK_RETENTION_TARGET may hang your database","datePublished":"2016-05-26T07:20:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/"},"wordCount":466,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCDB02FLASHBACKRET-1.png","keywords":["CDB","Data Guard","multitenant","Oracle","PDB","Pluggable Databases"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/","url":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/","name":"DB_FLASHBACK_RETENTION_TARGET may hang your database - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCDB02FLASHBACKRET-1.png","datePublished":"2016-05-26T07:20:21+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCDB02FLASHBACKRET-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureCDB02FLASHBACKRET-1.png","width":1920,"height":372},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/db_flashback_retention_target-may-hang-your-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"DB_FLASHBACK_RETENTION_TARGET may hang your database"}]},{"@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\/8061","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=8061"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8061\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8063"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8061"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}