Oracle Database 10g Flashback Features
Oracle Database 10g offers a new set of
“Flashback” features that allow you to review database data, and
even reset the database, or database objects, to a point in time in
the past without actually having to perform a recovery.
Flashback query is a very powerful feature in
the Oracle database that was introduced in Oracle9i, and enhanced in
Oracle9i Release 2. Now, Oracle10g offers even more functionality in
the form of Flashback Database. Flashback database allows you to
flashback the entire database to a specific point in time.
Oracle10g offers flashback drop. This feature
allows you to undo the effects of a drop table command via
the new flashback table SQL command using the to before
Flashback Versions Query
Flashback versions query allows you to define
a minimum and maximum time (using the versions between timestamp
clause of the select statement) or scn range (using the
versions between SCN clause of the select statement), and
then query a specific row or set of rows in a table to see a list of
all values assigned to those rows.
Flashback Transaction Query
Oracle10g provides the ability to easily
reconstruct SQL statements that have been executed by SQL
statements. Previously, you would need to use Log Miner to generate
SQL redo statements that could be used to replicate SQL statements
executed in the database. Now, Flashback Transaction Query can be
used to reconstruct the SQL statements used to make changes in the
database, and those that can be used to undo the change.
The flashback table command allows you
to flashback an Oracle table based on timestamp or database SCN. All
flashback table operations must be at the beginning of any
transaction and flashback table operations are not supported for the