Since there will be rollback after roll-forward, all uncommitted transactions will be purged when the database opens-up after an instance crash. Of course, redologs might contain several transactions uncommitted at the the time of crash, but can they be recovered? I am not sure.




Reply With Quote