Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP HANA log backup frequency

Dear all,

we configured hana to use the hdbbackint backup interface.

Now we checked and have seen that over 650 logs are saved to the backup library one a day.

logs are genereated randomly but at least every 1 - 3 min.

Parameters are set :

log_backup_timeout_s = 900
log_segement_size_mb = 8 

i attached a screenshot of the log backup catalog.

do you know how we can handle that ? backups every 15 min should be ok i think.

greetings

oliver

Unbenannt.jpg (181448 B)
Former Member
Former Member replied

Hello,

it turned out that - on grouping the entries in backup.log by the service and filtering by states LogBackupStarted/LogBackupSuccess - a log backup is performed every 15 minutes. This is due to the log_backup_timeout_s which is reached as the log-segment was not full after this threshold exceeded.

2015-01-15T14:45:07+01:00  P038871      14aedd63d50 INFO    LOGBCKUP state of service: indexserver, linux:31003, volume: 3, BackupLogStarted
2015-01-15T14:46:20+01:00  P038871      14aedd63d50 INFO    LOGBCKUP state of service: indexserver, linux:31003, volume: 3, BackupLogSuccess

>> 15 Minutes

2015-01-15T15:00:07+01:00  P038871      14aede3f8ed INFO    LOGBCKUP state of service: indexserver, linux:31003, volume: 3, BackupLogStarted
2015-01-15T15:01:20+01:00  P038871      14aede3f8ed INFO    LOGBCKUP state of service: indexserver, linux:31003, volume: 3, BackupLogSuccess

>> 15 Minutes

2015-01-15T15:15:07+01:00  P038871      14aedf1b48e INFO    LOGBCKUP state of service: indexserver, linux:31003, volume: 3, BackupLogStarted
2015-01-15T15:16:20+01:00  P038871      14aedf1b48e INFO    LOGBCKUP state of service: indexserver, linux:31003, volume: 3, BackupLogSuccess

>> 15 Minutes

2015-01-15T15:30:07+01:00  P038871      14aedff702a INFO    LOGBCKUP state of service: indexserver, linux:31003, volume: 3, BackupLogStarted
2015-01-15T15:31:20+01:00  P038871      14aedff702a INFO    LOGBCKUP state of service: indexserver, linux:31003, volume: 3, BackupLogSuccess

Without grouping according to the service, it looks like a log backup happens every couple of minutes:

2015-01-15T14:29:04+01:00  P038871      14aedc754db INFO    LOGBCKUP state of service: nameserver, linux:31001, volume: 1, BackupLogSuccess
2015-01-15T14:31:20+01:00  P038871      14aedc881b0 INFO    LOGBCKUP state of service: indexserver, linux:31003, volume: 3, BackupLogSuccess
2015-01-15T14:39:30+01:00  P038871      14aedd0e2c7 INFO    LOGBCKUP state of service: xsengine, linux:31007, volume: 2, BackupLogSuccess
2015-01-15T14:44:04+01:00  P038871      14aedd5107c INFO    LOGBCKUP state of service: nameserver, linux:31001, volume: 1, BackupLogSuccess
2015-01-15T14:46:20+01:00  P038871      14aedd63d50 INFO    LOGBCKUP state of service: indexserver, linux:31003, volume: 3, BackupLogSuccess
2015-01-15T14:54:21+01:00  P038871      14aedde7c02 INFO    LOGBCKUP state of service: xsengine, linux:31007, volume: 2, BackupLogSuccess

Best regards,

Michael

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question