Patent ID: 7552147

Claim:
A method for facilitating restoration of a database from a data recovery comprising one or more transactions that fail during recovery, the database maintained by a physical processor communicating with a memory module, the method comprising: initializing a data recovery comprising one or more transactions that fail during recovery; detecting the one or more transactions that fail during the data recovery; generating a log error data set during the data recovery comprising log records of each of the one or more failed transactions unapplied to data due to logical inconsistency, the log records configured to identify data objects, to identify the failed transactions on the data objects and to identify a range of the unapplied updates of the data objects; and generating recovery SQL statements, the recovery SQL statements configured to automatically redo the unapplied failed transactions referenced in the log error data set, wherein a user applies the generated recovery SQL statements to complete the data recovery once the inconsistency is resolved.