Data Recovery / Security White Papers
Oracle Flashback: Techniques for Recovering From Human Error
Overview The unpredictable nature of human error makes prevention of any sort extremely difficult. Thus, correcting these types of errors is largely an ad hoc task. Oracle Flashback technology makes this possible with a set of simple SQL queries for viewing data as it looked like at a point-in-time in the past, tracing a version history of data changes, locating changes affected by a particular transaction, and retrieving undo SQL to reverse the changes. With the new Flashback Table, Flashback Drop, and Flashback Database capabilities, errors manifested in multiple tables, accidentally dropped tables, and database-wide logical corruptions can be instantly 'undone' with a single SQL command. Experience simpler, shorter data recovery times today with breakthrough Flashback technology.
| Publisher | Oracle | File Format | PDF, requires Acrobat Rdr 5 |
|---|---|---|---|
| Date Published | November 2004 | Downloads | 466 |
| Format | White Papers | ||
| Topics | |||



