Transaction Recovery is a feature of Oracle database that allows DBAs to recover from transactions which have undesirable effects. Sometimes it happens that a transaction performs an undesirable effect, and we determine later that this transaction should not have been committed. In this case, we do not want to perform database point-in-time recovery as the rest of database is working fine. We only have a problem with one transaction. Oracle allows us to provide approximate times of the problematic transaction and search the archived and online redo log files for transactions performed during said time. Then we can identify the transaction and roll it back. Transaction recovery is very easy to use from Oracle Enterprise Manager, but it requires some setup to perform before we can use it.

Comment