I am using Log Rescue on a database which backup-files are not recognized as backups of this database. But the backup-files are correct and I'm able to restore them into another database.
To restore the rest - from backup-time to a certain timestamp - I want to use the transaction log.
This works pretty well. All inserts, deletions and updates of inserted rows are found and corresponding statements can be created.
But Log Rescue is not able to restore some update-statements of older rows since old and new value are not available.
I understand that the old value is not available because Log Rescue has no backup to retrieve the information but the new values should be in the transaction log so Log Rescue should be able to create the update statement.
Is there any way to get these update-statements?