Home » Database » hana » What are hana log segments?

What are hana log segments?

The short URL of the present article is: https://ipraby.com/mlu4

What are HANA Log Segments?

When we make changes in SAP, the data usually first gets saved in log segments, then data from log segments gets transferred to data volume once it is in status BackedUp whenever a savepoint is triggerred and then the logs gets state free, so hana logs can have below states.

States of HANA Log Segments

State Description
Writing Currently writing to this segment.
Closed Segment is closed by the writer.
Truncated Truncated, but not yet backed up. Backup will remove it.
BackedUp Segment is already backed up, but a savepoint has not yet been written. Therefore it needs to be kept for instance recovery.
Free Segment is free for reuse.

when we set parameter log_mode = normal and enable_auto_log_backup=yes then log files gets created.

if we set log_mode = overwrite then no log segments are created.

Note: Log Segments and Log Backups are different.

The short URL of the present article is: https://ipraby.com/mlu4

Leave a Reply

%d