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
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.