One of the biggest requirements of the eDBA is to enhance data availability by reducing or eliminating outages. But with the demands for higher and higher availability traditional forms of database recovery are becoming more and more inadequate. To combat this reality the eDBA should become knowledgeable of transaction recovery techniques. There are many different types of recovery that can be performed. This disaster could be anything from a simple media failure to a natural disaster destroying your data center.
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.