Sap Hana - (Redo) Log

1 - About

Redo log entries (in-memory) are written to the log volumes consistently for all changes to persistent data.

3 - Status

3.1 - Off

While logging is disabled no log entries will be persisted, only the data area will be written when a savepoint is reached.

3.2 - Log Mode

Default: Normal. The redo log must not be overwritten before a backup took place.

4 - Configuration

4.1 - System


ALTER SYSTEM LOGGING [OFF|ON]; 

hana_one/html/sql_alter_system_logging.html

4.2 - Table

For a table column, see the Sap Hana - Table Column - Column Store

4.3 - System parameters

Hana - System parameters - (System Property|Configuration File|Parameter)


select 
  * 
from 
  M_INIFILE_CONTENTS 
where 
  key like 'log%'
order
  by key asc

4.4 - Path

Log volume:


/hana/log/<SID>

The default path to the log directory depends on the system ID of the SAP HANA host


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap