Background documentationLog Entry Locate this document in the navigation structure

 

Using log entries, the database system logs all transactions that change data in the database. There are undo log entries (before images) and redo log entries (after images).

The database system needs the log entries to be able to undo SQL statements or to restore after a system failure (transaction consistency).

Types of Log Entries

Name

Alternative Name

Use

Undo Log Entries

Before Images

  • Enable the rollback of transactions that are not yet complete

  • Enable consistent views (only for SAP liveCache databases)

Redo Log Entries

After Images

  • Enable repetition of completed transactions

More Information

Concepts of the Database System, How Databases Log Data Changes

Database Administration, Backing up Log Entries