Flashback Technologies Features

General

Flashback Database

Restore the entire database to a specific point-in-time, using Oracle-optimized flashback logs, rather than via backups and forward recovery.

Flashback Table

Easily recover tables to a specific point-in-time. The feature is extremely useful when a logical corruption is limited to one or a set of tables instead of the entire database.

Flashback Drop

Recover an accidentally dropped table. The feature restores the dropped table, and all its indexes, constraints, and triggers, from the Recycle Bin (a logical container of all dropped objects).

Flashback Transaction

Undo the effects of a single transaction, and optionally, all its dependent transactions. via a single PL/SQL operation or by using an Enterprise Manager wizard.

Flashback Transaction Query

View all the changes made by a specific transaction. The feature is useful when an erroneous transaction changed data in multiple rows or tables.

Flashback Query

Query any data at some point-in-time in the past. This powerful feature can be used to view and logically reconstruct corrupted data that may have been deleted or changed inadvertently.

Flashback Versions Query

Retrieve different versions of a row across a specified time interval instead of a single point-in-time.

Flashback Time Travel

Efficiently manage and query long-term historical data. Flashback Time Travel automatically tracks every transactional change made to database data and maintains a secure, and easily accessible, archive of historic data.