Applications are completely unavailable until the recovery is complete. PIT recovery usually is performed to deal with an application level problem. Conventional techniques to perform a point in time recovery will remove the effects of all transactions since that specified point in time. This sometimes can cause problems if there were some valid transactions during that timeframe that still need to be applied. Thus, Transaction Recovery is an application recovery whereby the effects of specific transactions during a specified timeframe are removed from the database.
Most technicians think about recovery in order to resolve disasters such as hardware failures.
Hardware failures are just not as prevalent as they used to be. So, if the reason you need to recover has changed, it makes sense to rethink your recovery strategies. Transaction Recovery is the process of removing the undesired effects of specific transactions from the database. Sounds easy, but the actual details are somewhat complicated. Let s examine transaction recovery in a bit more detail.