23ai New Feature - Flashback Time Travel Enhancements (Doc ID 3053032.1)

Last updated on OCTOBER 29, 2024

Applies to:

Goal

The intent of this document is to introduce 23ai New Feature Flashback Time Travel Enhancements.

• Flashback Data Archive (FDA), also known as Flashback Archive (FBA), Flashback Time Travel or Oracle Total Recall, was introduced in Oracle 11gR2 to provide long term storage of undo data, allowing undo-based flashback operations to be performed over an extended period of time.
• Oracle Database 12c introduces several enhancements that will enable the Flashback Data Archive (FDA) to appeal to a broader audience.
• Starting from Database 19c, some flashback functionalities have been rebranded as Flashback Time Travel. This typically combines features of Flashback Data Archive and Flashback Query (SELECT AS OF and VERSIONS).
• Flashback Time Travel has been enhanced for improved efficiency and performance in the 23ai release.

Using Flashback Time Travel, you can enable tracking of DML (such as INSERT and DELETE) and DDL operations (such as creating and truncating tables) on a table that is being tracked (also called tracked table). You can then use Flashback Data Archive to archive the changes made to the rows of the tracked table in history tables. Flashback Time Travel also maintains a history of the evolution of a table schema. Having the history of the table and schema enables you to issue flashback queries (SELECT AS OF and VERSIONS) on the table and its schema. You can also view the history of DDL and DML changes made to the table.

Flashback Time Travel provides the ability to track and store transactional changes to a table over its lifetime, which helps organization with compliance, audit, historical reporting, selective data recovery. Flashback Time Travel helps to meet compliance requirements based on record-stage policies and audit reports by tracking and storing transactional changes to a table, which has also been made more efficient and performant in 23ai release.

Please also refer to the following online documentation for more details:

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.