How to Switch HANA Database Log Mode, Normal or Overwrite

In SAP HANA database, we can run the log modes either in normal or overwrite. You can refer to below table on further details and differences between both log modes.

Log Mode Description
normal 1. Default value and it is recommended to set as normal.
2. Log segments are backup automatically.
overwrite 1. It is not recommended for the production system.
2. No log backups are created.
3. Log area space will not grow excessively.

Launch and login to the SAP HANA Studio. Jump to Configuration tab and use the search filter for log_mode.

You can now change the value from normal to overwrite or vice versa.

Click on Save and it will immediately activate the changes.

You May Also Like

1 Comment

Leave a Reply?