11G

Flashback Transaction Backout using the Database Control

User Rating:

/ 1

Details: Parent Category: Articles; Created on Monday, 12 April 2010 20:53; Last Updated on Monday, 12 March 2012 13:54; Published on Monday, 12 April 2010 20:53; Written by Guy Lambregts; Hits: 3377

Flashback Transaction Backout using the Database Control

Flashback Transaction Backout is about backout of transaction(s) as well as dependant "child" transactions. Flashback Transaction Backout is built on top of the somewhat cumbersome logminer. You can use the GUI Database Control for it as well as the command line. We use here the Database Control

STEP 1 : On the availability page we click on "View and Manage Transactions"

ftb1

STEP 2 : On the next page we specify the timestamp range and optional we filter for transactions related to a specific schema, to a specific schema object. Note the word LOGMINER. Flashback Transaction Backout is built on top of logminer technology.

ftb2