Search notes:

Oracle Flashback Technology

Oracle Flashback Technology allows to view past states of data and winding data back and forth in time, without the need to restore backups or point-in-time recovery

Flashback is extremely helpful if someone accidentally dropped a table.

With Oracle Flashback Technology, the following two functionalities are possible:

There are 4 (5?) flashback related features (or options? or management packs?):

Flashback Table
Flashback Database
Flashback Transaction
Flashback Transaction Query
? Optimization for Flashback Data Archive

Flashback Database

An entire database can be rewound to a previous point in time. This might be helpful to correct user errors.

Flashback Database might also be used to complement

Data Guard
Data Recovery Advisor
Synchronizing cloned databases

Requirements

In order to use Oracle Flashback, the database needs be in archivelog mode and Flashback Database must be enabled.

If this is the case can be checked with

select
   name,
   dbid,
   flashback_on,
   log_mode
from
   gv$database;

Enabling flashback:

alter database flashback on;

Queries

select * from v$flashback_database_log;
select * from v$flashback_database_logfile;
select * from v$flashback_database_stat
select * from v$flashback_txn_graph;
select * from v$flashback_txn_mods;
select * from v$flashfilestat;
select * from v$flash_recovery_area_usage;

Oracle Flashback Technology

Flashback Database

Requirements

Queries

See also

Links