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.
SAP Knowledge Base Article - Preview