SAP Knowledge Base Article - Preview

2765887 - Changing parameter "log_mode" does not work

Symptom

Even though changed value of parameter log_mode from normal to overwrite, log backup files are still generated.

[persistence]
log_mode = overwrite

There are error message from trace file.
==
[32719]{308817}[122/244275022] 2019-03-07 12:58:36.521458 i SQLSessionCmd Statement.cc(06895) : INI configuration is changed by 308817, client ip=xx.xx.xx.xx, client port=6772, query=alter system alter configuration ('global.ini','SYSTEM') set ('persistence','log_mode') = 'overwrite' with reconfigure
...

[32331]{308817}[122/244275022] 2019-03-07 12:58:36.525290 w Logger LoggerImpl.cpp(00476) : Unknown log mode specified, value not changed
[32331]{308817}[122/244275022] 2019-03-07 12:58:36.528726 w Logger LoggerImpl.cpp(00476) : Unknown log mode specified, value not changed
[32331]{308817}[122/244275022] 2019-03-07 12:58:36.532195 w Logger LoggerImpl.cpp(00476) : Unknown log mode specified, value not changed
[32331]{308817}[122/244275022] 2019-03-07 12:58:36.535823 w Logger LoggerImpl.cpp(00476) : Unknown log mode specified, value not changed
[32331]{308817}[122/244275022] 2019-03-07 12:58:36.539196 w Logger LoggerImpl.cpp(00476) : Unknown log mode specified, value not changed
[32331]{308817}[122/244275022] 2019-03-07 12:58:36.543284 w Logger LoggerImpl.cpp(00476) : Unknown log mode specified, value not changed
[32331]{308817}[122/244275022] 2019-03-07 12:58:36.546722 w Logger LoggerImpl.cpp(00476) : Unknown log mode specified, value not changed
[32331]{308817}[122/244275022] 2019-03-07 12:58:36.550208 w Logger LoggerImpl.cpp(00476) : Unknown log mode specified, value not changed
[32331]{308817}[122/244275022] 2019-03-07 12:58:36.553353 w Logger LoggerImpl.cpp(00476) : Unknown log mode specified, value not changed
[32331]{308817}[122/244275022] 2019-03-07 12:58:36.556376 w Logger LoggerImpl.cpp(00476) : Unknown log mode specified, value not changed
[32331]{308817}[-1/-1] 2019-03-07 12:58:36.562173 w Logger LoggerImpl.cpp(00476) : Unknown log mode specified, value not changed
===

Image /data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • HANA1.0
  • HANA2.0 

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

HANA, log_mode, normal, overwrite, alter system, HOST, Unknown log mode specified, value not changed , KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.