{"id":221,"date":"2014-04-07T12:26:24","date_gmt":"2014-04-07T10:26:24","guid":{"rendered":"https:\/\/www.carajandb.com\/2014\/04\/07\/flashback-archive-second-edition-en\/"},"modified":"2018-02-09T12:27:18","modified_gmt":"2018-02-09T11:27:18","slug":"flashback-archive-second-edition-en","status":"publish","type":"post","link":"https:\/\/carajandb.com\/en\/2014\/04\/07\/flashback-archive-second-edition-en\/","title":{"rendered":"Flashback Archive second Edition"},"content":{"rendered":"<p>Flashback Archive becomes more and more my top Oracle feature as it is easy to implement and has a huge advantage for all kind of applications and compliance of course.<br \/>\nSo in <a href=\"en\/blogs\/blog-jahrends-en\/122-flashback-query\">my blog from January 2014<\/a> I already explained the idea of flashback data archive. Some of you might found some time to test and wondering about additional features or behaviors they wouldn\u2019t have expected.<br \/>\n<!--more--><br \/>\nLet&#8217;s go through some additional features:<\/p>\n<h3>Flashback Data Archive and Compression<\/h3>\n<p>As you probably know Flashback Archive is no longer limited to the Enterprise Edition or a separate license but can be used in Standard Edition and Standard Edition One as well. But either way the Flashback Archive tables are partitioned or a new partition is created every day! As the extend size of a single partition is 8 MB you can easily end up in Gigabyte of wasted store within one single month. On the other hand: if you archive all your DML operations the size of the individual partitions might even exceed the 8 MB like it will if you drop or rename a column because ALL old values will be stored in the corresponding archive table immediately.<\/p>\n<p>With the option \u201cOPTIMIZE DATA\u201d severval levels of compression will be added to the flashback area depending on the datatype or machine (Exadata). Those are:<\/p>\n<ul>\n<li>Advanced Row Compression<\/li>\n<li>Advanced Lob Compression<\/li>\n<li>Advanced LOB Deduplication<\/li>\n<li>Segment-Level Compression Tiering<\/li>\n<\/ul>\n<pre>CREATE FLASHBACK ARCHIVE fda_opt \r\nTABLESPACE fda_tablespace \r\nRETENTION 2 YEAR OPTIMIZE DATA;<\/pre>\n<p>You don&#8217;t have to care about any compression (as long as you are using Enterprise Edition and have a valid license for the Advanced Compression option) but the FBA process will look after the best approach for compression.<\/p>\n<h3>Flashback Archive Application<\/h3>\n<p>Tables do not stand at their own in fact there is probably an application or more than one associated with the tables of your schema. So the idea with Flashback Archive Application is that a set of tables belong to an application and are no longer managed individual.<\/p>\n<p>First of all you have to create a Flashback Data Archive application:<\/p>\n<pre>\r\nBEGIN\r\n   dbms_flashback_archive.register_application (\r\n       application_name =&gt; 'CUSTOMER',\r\n\t   flashback_archive_name =&gt; 'FBA_OPT'); \r\nEND;<\/pre>\n<p>Now the individual tables can be added to this application. In this example I will add all current tables of the schema to the application:<\/p>\n<pre>\r\nBEGIN\r\n   FOR c_tab IN (\r\n      SELECT table_name          \r\n\t  FROM user_tables    \r\n   )\r\n   LOOP\r\n      DBMS_FLASHBACK_ARCHIVE.ADD_TABLE_TO_APPLICATION (\r\n\t     application_name =&gt; 'CUSTOMER',\r\n\t\t schema_name      =&gt; 'FBA2',\r\n\t\t table_name       =&gt; c_tab.table_name);\r\n\t  dbms_output.put_line ('Table added '||c_tab.table_name);\r\n   END LOOP; -- c_tab    \r\n   COMMIT; \r\nEND; \/<\/pre>\n<p>The tables are now added to the application and the application is registered to be used with Flashback archive but actually the archiving is not activated. And this is where the main difference between the individual management of tables and the application usage comes into play. While individual tables must be activated or deactivated one by one the application can be managed with one single command:<\/p>\n<pre>EXECUTE dbms_flashback_archive.enable_application (application_name =&gt; 'CUSTOMER');<\/pre>\n<p>With a corresponding command the archiving can be disabled (<samp>dbms_flashback_archive.disable_application<\/samp>). This association even exists if you drop the flashback data archive. When you recreate it you can simply enable your application again which makes management much easier.<\/p>\n<h3>Management of Table DDL<\/h3>\n<p>What happens if you want to make changes to the table layout, e.g. change the name of a column, add or remove columns? This was not possible with older release but with the actual version you can simply add columns and remove them if necessary. One additional flashback table is maintained for every ordinary table which is named<samp>sys_fba_ddl_colmap_<\/samp>. This table lists all changed to the structure of a table.<\/p>\n<pre>\r\nSQL&gt; ALTER TABLE personen DROP COLUMN bemerkung; \r\n\r\nTable altered. \r\n\r\nSQL&gt; SELECT startscn, endscn, column_name, TYPE, historical_column_name\r\n       FROM sys_fba_ddl_colmap_25308; \r\nSTARTSCN  ENDSCN   COLUMN_NAME          TYPE        HISTORICAL_COLUMN_NAME \r\n-------- -------- -------------------- ------------ ---------------------- \r\n11156386          PERSID               NUMBER(10)   PERSID \r\n11156386          ANREDE               VARCHAR2(5)  ANREDE \r\n11156386          VORNAME              VARCHAR2(50) VORNAME \r\n11156386          NACHNAME             VARCHAR2(50) NACHNAME \r\n11156386          GEBURTSTAG           DATE         GEBURTSTAG \r\n11503985 11504152 D_11504152_BEMERKUNG VARCHAR2(20) BEMERKUNG\r\n<\/pre>\n<p>As you can see the dropped column is named <samp>D_11504152_BEMERKUNG<\/samp> to indicate that it has been dropped.<\/p>\n<p>But be aware your changes are archived and in case you drop one column the entire content of the table is stored in the flashback archive table.<\/p>\n<h3>Historical Data Movement<\/h3>\n<p>But what if you want to migrate your database? Data Pump simply ignores any flashback tables. So how can we move the archived information to a new location? The solution is: via a temporary history table.<\/p>\n<p>As it isn\u2019t possible to export the flashback archive tables you must create interim tables first like with the following command:<\/p>\n<pre>CREATE TABLE adressen_archive AS SELECT * FROM SYS_FBA_HIST_25389;<\/pre>\n<p>To ensure that you get all data regardless if the query is limited to actual data or not you should execute the following command on both the source and the target database:<\/p>\n<pre>EXECUTE dbms_flashback_archive.extend_mappings();<\/pre>\n<p>Now you can use data pump for the export and import of all data despite the fact that \u201cadressen_archive\u201d is holding the content of the flashback archive.<\/p>\n<p>On the target you need to enable flashback archive for your tables again as this information will get lost during the export and import procedure.<\/p>\n<pre>ALTER TABLE adressen FLASHBACK ARCHIVE;<\/pre>\n<p>And as the last step you import your history data in the corresponding flashback archive table again using the following command:<\/p>\n<pre>\r\nBEGIN\r\n   dbms_flashback_archive.import_history (\r\n      owner_name1 =&gt; 'FBA3',\r\n\t  table_name1 =&gt; 'ADRESSEN',\r\n\t  temp_history_name =&gt; 'ADRESSEN_ARCHIVE');\r\nEND; \/<\/pre>\n<p>The correctness can be verified by quering the corresponding Flashback Archive history table again:<\/p>\n<pre>SELECT * FROM SYS_FBA_HIST_25373;<\/pre>\n<p>Keep in mind that the number is different from the one on the source database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Flashback Archive becomes more and more my top Oracle feature as it is easy to implement and has a huge advantage for all kind of applications and compliance of course. So in my blog from January 2014 I already explained the idea of flashback data archive. Some of you might found some time to test and wondering about additional features or behaviors they wouldn\u2019t have expected.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_crdt_document":"","_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[],"tags":[182,183,112,23,41,181],"class_list":["post-221","post","type-post","status-publish","format-standard","hentry","tag-enterprise-edition","tag-flashback-archive-application","tag-flashback-data-archive","tag-oracle-11g","tag-oracle-12c","tag-standard-edition"],"acf":{"occupation":"Write the Occupation of the Person","person_can-be-speaker":true,"person_is-team":true,"person_related-user-account":null,"person_ordering-number":50,"publication_speakers":null,"publication_content-language":["de"],"publication_files":null,"publication_event":"","publication_date":null},"spectra_custom_meta":{"_fgj2wp_old_id":["221"],"_yoast_wpseo_metadesc":["Oracle 12c Flashback Data Archive"],"_yoast_wpseo_metakeywords":["Flashback Data Archive, Oracle 12c, Standard Edition, Enterprise Edition, Flashback Archive Application"],"_fgj2wp_translation_association_key":["06a9e0df42780919194010867a2f111f"],"layout_show-author-box":["1"],"_layout_show-author-box":["field_5a64ee9cc6490"],"_edit_lock":["1518175731:3"],"_edit_last":["3"],"_vc_post_settings":["a:1:{s:10:\"vc_grid_id\";a:0:{}}"],"_yoast_wpseo_content_score":["30"],"layout_header":["light"],"_layout_header":["field_5a48111185e5f"],"layout_background":[""],"_layout_background":["field_5a481193c0995"],"layout_hide_services":["0"],"_layout_hide_services":["field_5a4811c5c0996"],"layout_show-categories-tags":["1"],"_layout_show-categories-tags":["field_5a64eee4c6491"],"blogpost_related-publications":[""],"_blogpost_related-publications":["field_5a480debdac62"],"blogpost_related-files":[""],"_blogpost_related-files":["field_5a480f377db29"],"_yoast_wpseo_primary_category":[""],"_wpml_location_migration_done":["1"],"rank_math_primary_category":[""],"rank_math_description":["Oracle 12c Flashback Data Archive"],"rank_math_news_sitemap_robots":["index"],"rank_math_robots":["a:1:{i:0;s:5:\"index\";}"],"rank_math_internal_links_processed":["1"],"wpil_sync_report3":["1"],"wpil_links_inbound_internal_count":["1"],"wpil_links_inbound_internal_count_data":["eJx1Ustu2zAQ\/BWDdz+kxIm7PvWSU\/q4FeiFWJO0tTVNCuSqaRL437sUFcNJ0Ru5nJmdGRChgVeC1fYbNGtQP3ry+ku0zutHCkcFzQ28ZrgH5eWqyaptAWe4ATUkr+R034DqmHtYLpPzOATTtav2dmEw4S8Mdrcw8bTce8zdDs1xjsl09NvNX4bT\/OXJEbswt27R8WmUuxW1mLkc2ztQ\/5csiA0oCuxSQOHuoKn8fuT\/E+h7GU+BWiGOWdabuxJHkEzsndp+rRr83Dt1LZdB3GRGHnIFSScmyvLA9b6uHeWLRPbDoV6EaTyZt7fNqElMMdRBMRrTAQMZzQn3ezIXorPEMU04qRrNXn\/cG2Iwo\/XzSEHpq1Ak5idQD2\/Nzz7X5mfS\/OxnbV5N29FaZ\/XuWfdimkIpc1Wd+miwOn0fWcRX06946ij3LmmTHLK7fJHilrLGgWOBXY8lpDlSOFx9qDI+RTt4p9+h22nJuPgP1\/n5\/BcVU+GI"],"wpil_links_outbound_internal_count":["1"],"wpil_links_outbound_internal_count_data":["eJx1UMtuwyAQ\/BWLu2ND0qbd\/EHUx7FHtAYSk2Bweai1ovx7wY6q9NALWkazM7ODQOGiod29A30A8jFqw1+dVIa\/aHsmQNdwCbAFYvKXa0l2hRxgDSR5Q\/K0fQbSxzhC03hlMFnRs5ZtVgI9ntDKbiXc0CjbdMYdw\/zWJ+y9sjLUGaaM1QeDoe9QnOvPpPxUZDdZ1YVYRvYI5H\/pwngCom1U3mKO1AFd9sd5\/y1\/sgDmZednuXznMFUlSHXwbqj2aBP6qWIt3RRCKQKlVJJ3Ex9NOmpbVNvFyDiBUTs73w5EuGxsl5ztraavXodReS68wqh+O6M0xwwcU3SFdg9Hn4\/X9njXcIEHJ5NR\/A+b3Uxm4++44NfrD3EylO4="],"wpil_links_outbound_external_count":["0"],"wpil_links_outbound_external_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_sync_report2_time":["2024-08-27T11:47:30+00:00"],"astra_style_timestamp_css":["1773813735"],"copied_media_ids":["a:0:{}"],"referenced_media_ids":["a:0:{}"],"_uag_css_file_name":["uag-css-221.css"],"_uag_page_assets":["a:9:{s:3:\"css\";s:25301:\".uag-blocks-common-selector{z-index:var(--z-index-desktop) !important}@media (max-width: 976px){.uag-blocks-common-selector{z-index:var(--z-index-tablet) !important}}@media (max-width: 767px){.uag-blocks-common-selector{z-index:var(--z-index-mobile) !important}}\n.uagb-icon-list__wrap{display:flex;align-items:flex-start;justify-content:flex-start}.wp-block-uagb-icon-list-child{padding:0;transition:all 0.2s;display:inline-flex;color:#3a3a3a;align-items:center;text-decoration:none;box-shadow:none}.wp-block-uagb-icon-list-child span.uagb-icon-list__source-wrap{display:block;align-items:center}.uagb-icon-list__source-wrap svg{display:block}.uagb-icon-list__source-image{width:40px}.uagb-icon-list__outer-wrap .uagb-icon-list__content-wrap{color:#3a3a3a;display:flex;align-items:center}\n.wp-block-uagb-icon-list-child{position:relative}.wp-block-uagb-icon-list-child>a{position:absolute;top:0;left:0;width:100%;height:100%}img.uagb-icon-list__source-image{max-width:unset}.wp-block-uagb-icon-list-child .uagb-icon-list__label{word-break:break-word}\n.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 20px;height: 20px;font-size: 20px;color: var(--ast-global-color-0);fill: var(--ast-global-color-0);}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{border-color: #28368200;padding: 0px;border-radius: 100px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__label{font-size: 20px;text-decoration: !important;line-height: 1.5em;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__label{text-align: left;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child{text-decoration: !important;font-size: 20px;line-height: 1.5em;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-wrap{margin-right: 15px;}.uagb-block-d4bae936.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{fill: var(--ast-global-color-0) !important;color: var(--ast-global-color-0) !important;}.uagb-block-d4bae936.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-d4bae936.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-d4bae936.wp-block-uagb-icon-list-child.wp-block-uagb-icon-list-child.wp-block-uagb-icon-list-child{margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.uagb-block-375284f0.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-375284f0.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-dfc53cb7.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-dfc53cb7.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}@media only screen and (max-width: 976px) {.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 20px;height: 20px;font-size: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap {padding: 0px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}}@media only screen and (max-width: 767px) {.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 20px;height: 20px;font-size: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{padding: 0px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 20px;height: 20px;font-size: 20px;color: var(--ast-global-color-0);fill: var(--ast-global-color-0);}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{border-color: #28368200;padding: 0px;border-radius: 100px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__label{font-size: 20px;text-decoration: !important;line-height: 1.5em;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__label{text-align: left;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child{text-decoration: !important;font-size: 20px;line-height: 1.5em;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-wrap{margin-right: 15px;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{fill: var(--ast-global-color-0) !important;color: var(--ast-global-color-0) !important;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child.wp-block-uagb-icon-list-child.wp-block-uagb-icon-list-child{margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.uagb-block-66131845.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-66131845.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-b2264876.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-b2264876.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}@media only screen and (max-width: 976px) {.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 20px;height: 20px;font-size: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap {padding: 0px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}}@media only screen and (max-width: 767px) {.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 20px;height: 20px;font-size: 20px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{padding: 0px;border-width: 0px;align-self: center;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}}.wp-block-uagb-container{display:flex;position:relative;box-sizing:border-box;transition-property:box-shadow;transition-duration:0.2s;transition-timing-function:ease}.wp-block-uagb-container .spectra-container-link-overlay{bottom:0;left:0;position:absolute;right:0;top:0;z-index:10}.wp-block-uagb-container.uagb-is-root-container{margin-left:auto;margin-right:auto}.wp-block-uagb-container.alignfull.uagb-is-root-container .uagb-container-inner-blocks-wrap{display:flex;position:relative;box-sizing:border-box;margin-left:auto !important;margin-right:auto !important}.wp-block-uagb-container .wp-block-uagb-blockquote,.wp-block-uagb-container .wp-block-spectra-pro-login,.wp-block-uagb-container .wp-block-spectra-pro-register{margin:unset}.wp-block-uagb-container .uagb-container__video-wrap{height:100%;width:100%;top:0;left:0;position:absolute;overflow:hidden;-webkit-transition:opacity 1s;-o-transition:opacity 1s;transition:opacity 1s}.wp-block-uagb-container .uagb-container__video-wrap video{max-width:100%;width:100%;height:100%;margin:0;line-height:1;border:none;display:inline-block;vertical-align:baseline;-o-object-fit:cover;object-fit:cover;background-size:cover}.wp-block-uagb-container.uagb-layout-grid{display:grid;width:100%}.wp-block-uagb-container.uagb-layout-grid>.uagb-container-inner-blocks-wrap{display:inherit;width:inherit}.wp-block-uagb-container.uagb-layout-grid>.uagb-container-inner-blocks-wrap>.wp-block-uagb-container{max-width:unset !important;width:unset !important}.wp-block-uagb-container.uagb-layout-grid>.wp-block-uagb-container{max-width:unset !important;width:unset !important}.wp-block-uagb-container.uagb-layout-grid.uagb-is-root-container{margin-left:auto;margin-right:auto}.wp-block-uagb-container.uagb-layout-grid.uagb-is-root-container>.wp-block-uagb-container{max-width:unset !important;width:unset !important}.wp-block-uagb-container.uagb-layout-grid.alignwide.uagb-is-root-container{margin-left:auto;margin-right:auto}.wp-block-uagb-container.uagb-layout-grid.alignfull.uagb-is-root-container .uagb-container-inner-blocks-wrap{display:inherit;position:relative;box-sizing:border-box;margin-left:auto !important;margin-right:auto !important}body .wp-block-uagb-container>.uagb-container-inner-blocks-wrap>*:not(.wp-block-uagb-container):not(.wp-block-uagb-column):not(.wp-block-uagb-container):not(.wp-block-uagb-section):not(.uagb-container__shape):not(.uagb-container__video-wrap):not(.wp-block-spectra-pro-register):not(.wp-block-spectra-pro-login):not(.uagb-slider-container):not(.spectra-image-gallery__control-lightbox):not(.wp-block-uagb-info-box),body .wp-block-uagb-container>.uagb-container-inner-blocks-wrap,body .wp-block-uagb-container>*:not(.wp-block-uagb-container):not(.wp-block-uagb-column):not(.wp-block-uagb-container):not(.wp-block-uagb-section):not(.uagb-container__shape):not(.uagb-container__video-wrap):not(.wp-block-spectra-pro-register):not(.wp-block-spectra-pro-login):not(.uagb-slider-container):not(.spectra-container-link-overlay):not(.spectra-image-gallery__control-lightbox):not(.wp-block-uagb-lottie):not(.uagb-faq__outer-wrap){min-width:unset !important;width:100%;position:relative}body .ast-container .wp-block-uagb-container>.uagb-container-inner-blocks-wrap>.wp-block-uagb-container>ul,body .ast-container .wp-block-uagb-container>.uagb-container-inner-blocks-wrap>.wp-block-uagb-container ol,body .ast-container .wp-block-uagb-container>.uagb-container-inner-blocks-wrap>ul,body .ast-container .wp-block-uagb-container>.uagb-container-inner-blocks-wrap ol{max-width:-webkit-fill-available;margin-block-start:0;margin-block-end:0;margin-left:20px}.ast-plain-container .editor-styles-wrapper .block-editor-block-list__layout.is-root-container .uagb-is-root-container.wp-block-uagb-container.alignwide{margin-left:auto;margin-right:auto}.uagb-container__shape{overflow:hidden;position:absolute;left:0;width:100%;line-height:0;direction:ltr}.uagb-container__shape-top{top:-3px}.uagb-container__shape-bottom{bottom:-3px}.uagb-container__shape.uagb-container__invert.uagb-container__shape-bottom,.uagb-container__shape.uagb-container__invert.uagb-container__shape-top{-webkit-transform:rotate(180deg);-ms-transform:rotate(180deg);transform:rotate(180deg)}.uagb-container__shape.uagb-container__shape-flip svg{transform:translateX(-50%) rotateY(180deg)}.uagb-container__shape svg{display:block;width:-webkit-calc(100% + 1.3px);width:calc(100% + 1.3px);position:relative;left:50%;-webkit-transform:translateX(-50%);-ms-transform:translateX(-50%);transform:translateX(-50%)}.uagb-container__shape .uagb-container__shape-fill{-webkit-transform-origin:center;-ms-transform-origin:center;transform-origin:center;-webkit-transform:rotateY(0deg);transform:rotateY(0deg)}.uagb-container__shape.uagb-container__shape-above-content{z-index:9;pointer-events:none}.nv-single-page-wrap .nv-content-wrap.entry-content .wp-block-uagb-container.alignfull{margin-left:calc(50% - 50vw);margin-right:calc(50% - 50vw)}@media only screen and (max-width: 767px){.wp-block-uagb-container .wp-block-uagb-advanced-heading{width:-webkit-fill-available}}.wp-block-uagb-image--align-none{justify-content:center}\n.wp-block-uagb-container.uagb-block-add44f6f .uagb-container__shape-top svg{width: calc( 100% + 1.3px );}.wp-block-uagb-container.uagb-block-add44f6f .uagb-container__shape.uagb-container__shape-top .uagb-container__shape-fill{fill: rgba(51,51,51,1);}.wp-block-uagb-container.uagb-block-add44f6f .uagb-container__shape-bottom svg{width: calc( 100% + 1.3px );}.wp-block-uagb-container.uagb-block-add44f6f .uagb-container__shape.uagb-container__shape-bottom .uagb-container__shape-fill{fill: rgba(51,51,51,1);}.wp-block-uagb-container.uagb-block-add44f6f .uagb-container__video-wrap video{opacity: 1;}.wp-block-uagb-container.uagb-is-root-container .uagb-block-add44f6f{max-width: 100%;width: 100%;}.wp-block-uagb-container.uagb-block-add44f6f{box-shadow: 0px 0px   #00000070 ;padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;overflow: visible;order: initial;border-color: inherit;flex-direction: column;align-items: stretch;justify-content: center;flex-wrap: nowrap;row-gap: 20px;column-gap: 20px;max-width: 100% !important;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 25px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 25px;height: 25px;font-size: 25px;color: var(--ast-global-color-0);fill: var(--ast-global-color-0);}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{border-color: #28368200;padding: 0px;border-radius: 100px;border-width: 0px;align-self: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__label{font-size: 20px;text-decoration: !important;line-height: 1.5em;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__label{text-align: left;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child{text-decoration: !important;font-size: 20px;line-height: 1.5em;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-wrap{margin-right: 20px;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{fill: var(--ast-global-color-0) !important;color: var(--ast-global-color-0) !important;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-05f838d1.wp-block-uagb-icon-list-child.wp-block-uagb-icon-list-child.wp-block-uagb-icon-list-child{margin-top: 0px;margin-right: 0px;margin-bottom: 0px;margin-left: 0px;padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}.uagb-block-66131845.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-66131845.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-bb602a54.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-bb602a54.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-b2264876.wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}.uagb-block-b2264876.wp-block-uagb-icon-list-child:hover .uagb-icon-list__source-wrap{background:  !important;border-color:  !important;}@media only screen and (max-width: 976px) {.wp-block-uagb-container.uagb-is-root-container .uagb-block-add44f6f{width: 100%;}.wp-block-uagb-container.uagb-block-add44f6f{padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;order: initial;align-items: stretch;max-width:  !important;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 25px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 25px;height: 25px;font-size: 25px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap {padding: 0px;border-width: 0px;align-self: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}}@media only screen and (max-width: 767px) {.wp-block-uagb-container.uagb-is-root-container .uagb-block-add44f6f{max-width: 100%;width: 100%;}.wp-block-uagb-container.uagb-block-add44f6f{padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;order: initial;align-items: stretch;flex-wrap: wrap;max-width: 100% !important;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__source-image{width: 25px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap svg{width: 25px;height: 25px;font-size: 25px;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .wp-block-uagb-icon-list-child .uagb-icon-list__source-wrap{padding: 0px;border-width: 0px;align-self: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84 .uagb-icon-list__wrap{display: flex;flex-direction: column;justify-content: center;-webkit-box-pack: center;-ms-flex-pack: center;-webkit-box-align: flex-start;-ms-flex-align: flex-start;align-items: flex-start;}.wp-block-uagb-icon-list.uagb-block-51f78a84.wp-block-uagb-icon-list .wp-block-uagb-icon-list-child{margin-left: 0;margin-right: 0;margin-bottom: 0px;}}.wp-block-uagb-container.uagb-block-e8cad69e .uagb-container__shape-top svg{width: calc( 100% + 1.3px );}.wp-block-uagb-container.uagb-block-e8cad69e .uagb-container__shape.uagb-container__shape-top .uagb-container__shape-fill{fill: rgba(51,51,51,1);}.wp-block-uagb-container.uagb-block-e8cad69e .uagb-container__shape-bottom svg{width: calc( 100% + 1.3px );}.wp-block-uagb-container.uagb-block-e8cad69e .uagb-container__shape.uagb-container__shape-bottom .uagb-container__shape-fill{fill: rgba(51,51,51,1);}.wp-block-uagb-container.uagb-block-e8cad69e .uagb-container__video-wrap video{opacity: 1;}.wp-block-uagb-container.uagb-is-root-container .uagb-block-e8cad69e{max-width: 100%;width: 100%;}.wp-block-uagb-container.uagb-block-e8cad69e{box-shadow: 0px 0px   #00000070 ;padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;overflow: visible;order: initial;border-color: inherit;flex-direction: column;align-items: center;justify-content: center;flex-wrap: nowrap;row-gap: 20px;column-gap: 20px;max-width: 100% !important;}@media only screen and (max-width: 976px) {.wp-block-uagb-container.uagb-is-root-container .uagb-block-e8cad69e{width: 100%;}.wp-block-uagb-container.uagb-block-e8cad69e{padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;order: initial;max-width:  !important;}}@media only screen and (max-width: 767px) {.wp-block-uagb-container.uagb-is-root-container .uagb-block-e8cad69e{max-width: 100%;width: 100%;}.wp-block-uagb-container.uagb-block-e8cad69e{padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;order: initial;flex-wrap: wrap;max-width: 100% !important;}}.wp-block-uagb-container.uagb-block-0921a5e7 .uagb-container__shape-top svg{width: calc( 100% + 1.3px );}.wp-block-uagb-container.uagb-block-0921a5e7 .uagb-container__shape.uagb-container__shape-top .uagb-container__shape-fill{fill: rgba(51,51,51,1);}.wp-block-uagb-container.uagb-block-0921a5e7 .uagb-container__shape-bottom svg{width: calc( 100% + 1.3px );}.wp-block-uagb-container.uagb-block-0921a5e7 .uagb-container__shape.uagb-container__shape-bottom .uagb-container__shape-fill{fill: rgba(51,51,51,1);}.wp-block-uagb-container.uagb-block-0921a5e7 .uagb-container__video-wrap video{opacity: 1;}.wp-block-uagb-container.uagb-is-root-container .uagb-block-0921a5e7{max-width: 100%;width: 100%;}.wp-block-uagb-container.uagb-block-0921a5e7{box-shadow: 0px 0px   #00000070 ;padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;overflow: visible;order: initial;border-color: inherit;flex-direction: column;align-items: center;justify-content: center;flex-wrap: nowrap;row-gap: 20px;column-gap: 20px;max-width: 100% !important;}@media only screen and (max-width: 976px) {.wp-block-uagb-container.uagb-is-root-container .uagb-block-0921a5e7{width: 100%;}.wp-block-uagb-container.uagb-block-0921a5e7{padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;order: initial;max-width:  !important;}}@media only screen and (max-width: 767px) {.wp-block-uagb-container.uagb-is-root-container .uagb-block-0921a5e7{max-width: 100%;width: 100%;}.wp-block-uagb-container.uagb-block-0921a5e7{padding-top: 10px;padding-bottom: 10px;padding-left: 10px;padding-right: 10px;margin-top:  !important;margin-bottom:  !important;order: initial;flex-wrap: wrap;max-width: 100% !important;}}\";s:2:\"js\";s:0:\"\";s:18:\"current_block_list\";a:14:{i:0;s:15:\"core\/categories\";i:1;s:17:\"core\/latest-posts\";i:2;s:14:\"core\/tag-cloud\";i:3;s:14:\"core\/paragraph\";i:4;s:11:\"core\/search\";i:5;s:12:\"core\/heading\";i:6;s:9:\"core\/list\";i:7;s:14:\"core\/list-item\";i:8;s:14:\"uagb\/icon-list\";i:9;s:20:\"uagb\/icon-list-child\";i:10;s:10:\"core\/group\";i:11;s:14:\"uagb\/container\";i:12;s:10:\"core\/image\";i:13;s:17:\"uagb\/loop-builder\";}s:8:\"uag_flag\";b:1;s:11:\"uag_version\";s:10:\"1776403483\";s:6:\"gfonts\";a:1:{s:7:\"Default\";a:2:{s:10:\"fontfamily\";s:7:\"Default\";s:12:\"fontvariants\";a:0:{}}}s:10:\"gfonts_url\";s:77:\"https:\/\/fonts.googleapis.com\/css?family=Default&subset=latin&display=fallback\";s:12:\"gfonts_files\";a:0:{}s:14:\"uag_faq_layout\";b:0;}"]},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Johannes Ahrends","author_link":"https:\/\/carajandb.com\/en\/author\/9aa6cdb2095bd409\/"},"uagb_comment_info":0,"uagb_excerpt":"Flashback Archive becomes more and more my top Oracle feature as it is easy to implement and has a huge advantage for all kind of applications and compliance of course. So in my blog from January 2014 I already explained the idea of flashback data archive. Some of you might found some time to test&hellip;","_links":{"self":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/comments?post=221"}],"version-history":[{"count":0,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/221\/revisions"}],"wp:attachment":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/media?parent=221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/categories?post=221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/tags?post=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}