2 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 2 Whatsapp 0 Email What is redo? Let’s look briefly at the redo process. When Oracle blocks (the smallest unit of storage in a database) are changed, including UNDO blocks, Oracle records the changes in vector changes, which are referred to as redo entries or…
Category: Undo
Differences between UNDO and REDO
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email To clear this question we have this table: UNDO REDO Record of How to undo a change How to reproduce a change Used for Rollback, Read-Consistency Rolling forward DB Changes Stored in Undo segments Redo log files Protect Against Inconsistent reads…
What is the difference between Rollback and Undo Tablespace? OTN Forum By user user503050
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email There might be confusion while undo and rollback segment terms are used interchangeably in db world. It is due to the compatibility issue of oracle. Undo Oracle Database must have a method of maintaining information that is used to roll back,…