Flashback Query was the first example of this
feature made available by Oracle. The concept behind a Flashback Query is simple.
You can execute a query against the database as of a particular time or System
Change Number (SCN). Oracle delivers the result set as it would have appeared if
the query were run at that time, using the undo log information segments to reconstruct
the data, which can then be used to correct the results of the errant action.
Oracle Database 10g added a much wider range of flashback capabilities, including:
Flashback Versions Query
Returns all the versions of rows in a particular query over a span of time.
Flashback Transaction Query
Returns all the changes made by a specific transaction.
Complete Site Failure | 281
Flashback Drop
When an object is dropped, it is placed in a Recycle Bin, so a user can simply undrop
the object to restore it.
Flashback Table
Returns a table to a specific point in time.
Flashback Database
Returns the entire database to a particular point in time. Can be used instead of
point-in-time recovery in some situations.
Pages:
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614