What’s on the Log File?

• Transaction starts/stops

• DB writes: "before" and/or "after" images of DB records

  • befores can be used to rollback an aborted transaction
  • afters can be used to redo a transaction (recovery from catastrophe)

• COMMITs and ABORTs

The log itself is as critical as the DB!

Previous slide

Next slide

Back to first slide

View graphic version