{"id":55875,"date":"2024-02-26T16:36:48","date_gmt":"2024-02-26T16:36:48","guid":{"rendered":"https:\/\/dbtut.com\/?p=55875"},"modified":"2024-02-26T16:39:23","modified_gmt":"2024-02-26T16:39:23","slug":"flashback-data-archive","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/","title":{"rendered":"Flashback Data Archive"},"content":{"rendered":"

Flashback Data Archive historically stores changes in the database for a retention period determined at the table level.<\/p>\n

Data at the desired moment is retrieved with Flashback Query or Flashback Versions Query.<\/p>\n

\"\"<\/p>\n

It works at the table level, UNDO works much more effectively without reaching this result by setting the size of TABLESPACE too large.<\/p>\n

The working principle is as follows.<\/p>\n

\"\"<\/p>\n

Once activated, the FBDA background process is created.<\/p>\n

FBDA captures the changing data from UNDO and Buffer Cache every 5 minutes and writes it to the FDA1 table.<\/p>\n

Its management is done entirely internally.<\/p>\n

The FBDA process can create up to 10 slave processes when necessary.<\/p>\n

It automatically purges old data when the retention period comes.<\/p>\n

If the OPTIMIZE DATA clause is used, the data is kept compressed and deduplicated.<\/p>\n

Historical Data is kept in a partitioned manner. At least 1 day and 1 MB.<\/p>\n

If FBDA and Slave processes are too busy, the user’s response time will slow down.<\/p>\n

By default, collection_level is NONE. It can also be TYPICAL and ALL.<\/p>\n

When it is TYPICAL, information such as DB User ID, Global User ID, Client Identifier, Service Name, Module Name, Host is also kept.<\/p>\n

It has DDL support.<\/p>\n

ADD, DROP, MODIFY, RENAME column
\nDROP and TRUNCATE partition
\nRENAME and TRUNCATE table<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

Flashback Data Archive historically stores changes in the database for a retention period determined at the table level. Data at the desired moment is retrieved with Flashback Query or Flashback Versions Query. It works at the table level, UNDO works much more effectively without reaching this result by setting the size of TABLESPACE too large. …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":484,"featured_media":55878,"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-55875","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nFlashback Data Archive - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Flashback Data Archive historically stores changes in the database for a retention period determined at the table level.\" \/>\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\/2024\/02\/26\/flashback-data-archive\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Flashback Data Archive - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Flashback Data Archive historically stores changes in the database for a retention period determined at the table level.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-26T16:36:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-26T16:39:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-26-193431.png\" \/>\n\t<meta property=\"og:image:width\" content=\"696\" \/>\n\t<meta property=\"og:image:height\" content=\"263\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Flashback Data Archive\",\"datePublished\":\"2024-02-26T16:36:48+00:00\",\"dateModified\":\"2024-02-26T16:39:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/\"},\"wordCount\":213,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-26-193431.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/\",\"name\":\"Flashback Data Archive - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-26-193431.png\",\"datePublished\":\"2024-02-26T16:36:48+00:00\",\"dateModified\":\"2024-02-26T16:39:23+00:00\",\"description\":\"Flashback Data Archive historically stores changes in the database for a retention period determined at the table level.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-26-193431.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-26-193431.png\",\"width\":696,\"height\":263},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Flashback Data Archive\"}]},{\"@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":"Flashback Data Archive - Database Tutorials","description":"Flashback Data Archive historically stores changes in the database for a retention period determined at the table level.","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\/2024\/02\/26\/flashback-data-archive\/","og_locale":"en_US","og_type":"article","og_title":"Flashback Data Archive - Database Tutorials","og_description":"Flashback Data Archive historically stores changes in the database for a retention period determined at the table level.","og_url":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/","og_site_name":"Database Tutorials","article_published_time":"2024-02-26T16:36:48+00:00","article_modified_time":"2024-02-26T16:39:23+00:00","og_image":[{"width":696,"height":263,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-26-193431.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Flashback Data Archive","datePublished":"2024-02-26T16:36:48+00:00","dateModified":"2024-02-26T16:39:23+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/"},"wordCount":213,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-26-193431.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/","url":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/","name":"Flashback Data Archive - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-26-193431.png","datePublished":"2024-02-26T16:36:48+00:00","dateModified":"2024-02-26T16:39:23+00:00","description":"Flashback Data Archive historically stores changes in the database for a retention period determined at the table level.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-26-193431.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-26-193431.png","width":696,"height":263},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/26\/flashback-data-archive\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Flashback Data Archive"}]},{"@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\/55875","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=55875"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55875\/revisions"}],"predecessor-version":[{"id":55879,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55875\/revisions\/55879"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/55878"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=55875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=55875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=55875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}