Transaction recovery use undo tablespace
frank, October 09, 2021 - 2:11 pm UTC
Hey tom from what i know the transaction recovery(which rollback the uncomitted transaction) use the undo information stored in undo tbs not in redo log
Is this concept wrong?
October 11, 2021 - 10:53 am UTC
Yes but we need to get that information *back* into the undo tablespace after a power outage, so that we can then *use* it to undo any uncomitted transactions.
We use the redo to bring the undo tablespace back to a correct state.