Sap Hana - (Redo) Log

Sap Hana Architecture

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





Discover More
Sap Hana Architecture
SAP Hana - Data and Log Volume (File)

Each volume contains one file (datavolume_0000.dat) in which data is organized into pages, ranging in size from 4KB to 16MB (page size class). During the installation process, the following default...
Sap Hana Architecture
SAP Hana - Database Start/Stop/Restart

The data belonging to a savepoint represents a consistent state of the data on disk and remains so until the next savepoint operation has completed. Redo log entries are written to the log volumes for...
Sap Hana Architecture
SAP Hana - Savepoint

SAP HANA persists in-memory data by using savepoints. Each SAP HANA service has its own separate savepoints. logs During a savepoint operation, the SAP HANA database flushes all changed data from...
Hana Column Store Write Read Operations
Sap Hana - Table Column - Column Store

Table column. Data Structure Access Pattern Compression Main Storage Optimized for read access Advanced Delta Storage Optimized for write access Basic Read operations are performed on...



Share this page:
Follow us:
Task Runner