Sap Hana - (Redo) Log

About

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

Status

Off

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

Log Mode

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

Configuration

System

ALTER SYSTEM LOGGING [OFF|ON]; 

hana_one/html/sql_alter_system_logging.html

Table

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

System parameters

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

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

Path

Log volume:

/hana/log/<SID>

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


Powered by ComboStrap