| understanding recovery from arc/redo logs [message #63188] |
Thu, 16 September 2004 07:09  |
priest holmes
Messages: 2
Registered: September 2004
|
Junior Member |
|
|
Assume running in archive mode. I understand that the redo logs are copied by the ARC processes to another destination. But this is what's confusing me. During db recovery how does Oracle determine which redo records correspond to committed txns and which redo records correspond to aborted txns (and hence shouldn't be applied)???
I mean, you could have a long write txn that causes redo records to be written across 2 or more log files only to be aborted. How does RECO know when rebuilding the db not to apply those redo records?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
