Like This Site? 
RSS Feed Follow Us 

on Twitter! Be Our Fan!

Oracle : FlashBack Architecture

Share this post!
 Vote this!

There are a number of flashback levels
row level flashback query, flashback versions query, flashback transaction query
table level flashback table, flashback drop 
database level flashback database
Oracle 10g has several error-correction techniques that use undo data, however they are only available if you use automatic undo management (AUM),
  • Flashback query - retrieves data from a past point in time
  • Flashback versions query - shows you different versions of data rows, plus start and end times of a particular transaction that created that row
  • Flashback transaction query - lets you retrieve historical data for a given transaction and the SQL code to undo the transaction.
  • Flashback table - recovers a table to its state at a past point in time, without having to perform a point in time recovery.  more...


Post a Comment