Hi,
I am little confused about redo log entries.
I learned that LGWR writes redo log entries in SGA, into redo log files in the next circumstances :
- 3 seconds after last commit
- redo log buffer has 1MB
- redo log buffer has 1/3 data
When I take a transaction and if I modify wrong data, I have to rollback that transaction BUT in that time,
what if the LGWR writes redo log entries to disk?
Is the bad transaction committed permanently?