I have been receiving regular questions on guidelines for backup and restore of SAP HANA and from the questions it seems many customers follow old guidelines for file based backup, especially when using 'alter system reclaim log'. With SAP HANA SPS5, in addition to the existing file based backup there is a new option to use certified 3rd party tools using the new BACKINT API (see SAP Note 1730932). Guidelines for BACKINT based backup and restore using certified 3rd party tools as introduced with SPS5 will be provided by the 3rd party tool vendor. This blog assumes you have read and understood the SAP HANA Backup & Restore documentation. Please note that with SAP HANA SPS5 the Backup & Restore guide was merged into the SAP HANA administration guide: http://help.sap.com/hana/hana_admin_en.pdf.
After discussions with SAP HANA Development and Product Management in Berlin we agreed on the guidelines below for file based backup. In SAP HANA there are four main basepath parameters which you find in the ‘configuration’ tab in SAP HANA Studio:
“ALTER SYSTEM RECLAIM LOG” before and after SAP HANA SPS3:
Before SAP HANA SPS3 it was recommended to run this command manually after every backup to ensure disk space was reclaimed. The command physically removes the log segments that are no longer needed. With SPS3 log backup functionality was introduced which automates log segment reuse and can eliminate the need to run “ALTER SYSTEM RECLAIM LOG”.
In most SAP HANA instances, especially productive systems, the log_mode is set to ‘normal’ and enable_auto_log_backup set to ‘yes’. This means that log backups are created automatically when a log segment is full or a log segment is closed after exceeding the configured time threshold. The log backup allows the log segment to be reused for new log entries, which eliminates the need to run “ALTER SYSTEM RECLAIM LOG” under normal circumstances. So after SAP HANA SPS3 “ALTER SYSTEM RECLAIM LOG” should only be used in exceptional situations, for example if there is a problem with writing the log backup and you get an alert the log volume disk/path is close to full.
This note can be helpful to schedule backups: https://service.sap.com/sap/support/notes/1651055 - if you read the attachment to the note it gives you an option to identify which log backups can be to deleted.
As always, feedback is welcome!
Serge Muts
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
38 | |
19 | |
13 | |
13 | |
11 | |
10 | |
10 | |
10 | |
8 | |
8 |