You can set the log backup interval mode and change the time in the Backup Configuration App in SAP HANA cockpit or the Backup Console in SAP HANA studio. We will be using SAP HANA Studio for this exercise.
Set Log Backup Interval Mode
Once logged in to the database, go to Configuration tab. Look for log_backup_interval_mode parameter. Double click on it to set / change to a new value. Click save to apply the change.
| Mode | Description |
|---|---|
| immediate (Default) | A log backup is created immediately after a log segment becomes full or when the service-specific timeout for a log segment has been reached. If you have configured consolidated log backups (parameter max_log_backup_size); the log backup process does not wait for the configured size of log backups to be queued. If fewer log backups are queued all the queued log backups are processed. |
| service | A log backup is created only after a service-specific timeout has been reached. This backup includes all the log segments in states writing / closed and truncated. |
Change Log Backup Interval Time
You have to enable the automatic log backup and set the log mode to normal. This is the prerequisites for the log backup interval parameter.
The step will be the same as above, from Configuration tab, look for log_backup_timeout_s. Define the timing here. The default value is 15 minutes (900s). For production systems, it’s recommended to set to 15 minutes or less.
