iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Oracle 11g New Features

Online Oracle Training

 

How to identify and roll back by backing out specific transactions

 

 

In Oracle 11g, you can use OEM to examine and rollback transactions using LogMinor to extract DML statements from the redo log files.

The following are the steps:
Enable log mining:
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

In OEM, from the Database homepage, go to the "Availability" tab.

Then under Manage click on the "View and Manage Transactions" link. This will bring the LogMinor interface.

 

On the LogMinor interface, you can enter specific ranges in time or SCN plus DBA user and specific table. Enter your criteria filter and click Continue.

Now, you have kicks up the LogMinor to list all transactions from online and archived redo log files. You see your number of DML transactions.

On Oracle 11g, now you can view the Dependent Transactions, if you click on "Flashback transaction."

But Submit all the dependent transactions will be backed out.

 

 

 

Good Luck!

 

Google
 
Web web site