The newly offered Oracle 11g database provides further features on flashback transaction upon oracle 10g. Comparing to Flashback Versions Query and Flashback Transaction Query, new feature of Flashback Transaction Backout can back out one or more independent or dependent transactions. The new Oracle 11g feature overcomes the limitation of similar features in oracle 10g, which is dependent on database undo tablespace.

In oracle enterprise manager, this new features could be implemented by Logminer  (more enhancement on logminer).

• LogMiner query parameters are easily specified at either the time stamp or SCN granularity
• A long-running LogMiner query can now be halted so that any corresponding partial results can be displayed; equally impressive, it’s now possible to show the remaining estimated time to complete the query if execution was resumed.
• The original LogMiner query can be used as a target of a “re-mining” operation based on the initial results retrieved, and the original LogMiner query results can now be saved for future evaluations.
• Finally, the detailed results of a LogMiner query – including all transaction details, dependencies, and the compensating undo SQL scripts – can be easily obtained, and this feature set facilitates a brand-new feature set in Oracle 11g: the ability to quickly and accurately reverse individual committed transactions via Flashback Transaction Backout.

For details on implementing Flashback Transaction Backout, please read complete article as attached.

For additional resource related: Supplemental Log visit http://www.juliandyke.com/Presentations/SupplementalLogging.ppt