5 1 0: SAP HANA Konfiguration
Übersicht
|
Unter SEP sesam YouTube Channel finden Sie aktuelle Videos und Webinare. |
|
Unter FAQ finden Sie Antworten auf die häufigsten Fragen. |
|
Im Problemfall nutzen Sie den Troubleshooting Guide. |
|
Falls Sie eine ältere SEP sesam Version verwenden, schauen Sie bitte ins Dokumentationsarchiv. |
SEP sesam offers efficient data protection for your SAP HANA environments. It integrates with the SAP HANA Backint backup interface to back up and restore SAP HANA databases. SEP sesam uses the HDBBackint agent to manage data and log backups and provide instructions through the Backint parameter file, which contains all necessary parameters and settings for the backup process.
When a backup is initiated, SEP sesam uses the HDBBackint agent to interact with the SAP HANA Backint interface and directly access and back up SAP HANA database and log files according to the specified parameters. SAP HANA database backups can be started using SAP HANA Studio, command line, or with a bash script that SEP sesam offers for SAP HANA V2. This script automates the backup process and also enables housekeeping of the SAP HANA backup catalog, ensuring efficient management of backups. For restores, SEP sesam retrieves the required backups and restores them to the SAP HANA database, ensuring data integrity and minimal downtime.
Wichtige Funktionen
- SEP sesam Integration HDBBackint ist zertifiziert und wird von SAP supportet.
- Integration with SAP HANA Studio provides a familiar user experience.
- SAP HANA extension integrates into the existing backup infrastructure, enhancing overall system efficiency.
- It supports high automation capabilities, reducing the need for manual interventions.
- Ensures the integrity and accuracy of your backups with consistency checks at the block level.
- Only the allocated data size needs to be backed up, and additional features like deduplication eliminate redundant data, optimizing storage use and reducing backup times.
- Backups are instantly available for recovery, minimizing downtime.
Voraussetzungen
To successfully integrate SEP sesam with SAP HANA Backint, the following prerequisites must be met:
- Ensure that both SEP sesam and SAP HANA are running compatible versions. Check the support matrix for the list of supported SAP HANA versions.
- SEP sesam must have network access to the SAP HANA database.
- SEP sesam Client for Linux must be installed on the SAP HANA server. It is recommended to use the latest available SEP sesam Client.
- Properly configured SAP HANA database with Backint enabled.
- Appropriate user permissions must be set up to allow SEP sesam to perform backup and restore operations.
- Regular file backups must work (the sample /etc backup must be successful). For details on backup configuration, see Standard Backup Procedure.
Konfigurationsverfahren
The configuration of SEP sesam with SAP HANA Backint involves several steps.
|
Anmerkung |
| {{{1}}} |
- Add and configure SAP HANA database server as SEP sesam Client.
- Add the SAP HANA database server as a SEP sesam Client and create an SAP HANA backup task to enable transporting database and log backups to the SEP sesam Server or RDS.
- Set up and configure the method for backing up the SAP HANA database.
- Recommended option: Create a backup event and use the SESAM_TASKEVENT Backint parameter in the .utl file. This approach allows you to manage and maintain backup settings and related actions in SEP sesam, without modifying the SAP HANA server.
- By configuring backup with a backup event in SEP sesam, you can manage and adjust the backup configuration directly in SEP sesam. After the initial setup of the SAP HANA server, this approach enables you to manage and maintain backup settings and related actions in SEP sesam, and eliminates the need for any further changes to the backup process on the SAP HANA server. However, this method cannot be used with storage systems that offer source-side deduplication.
- Alternative option: Configure the backup manually on the SAP HANA server using available SEP sesam parameters in the .utl file. Changes to the backup process must be made on the SAP HANA database server.
- The alternative method involves preparing the backup environment in SEP sesam and then manually configuring the backup process directly on the SAP HANA server using the SEP sesam backup parameters in the .utl file. This approach requires administrative access to the SAP HANA server and manual intervention and configuration on the SAP HANA server, increasing the potential for errors. However, this method supports using storage systems with source-side deduplication. For instructions, see Configuring SAP HANA Backups with Variable Backint Parameters.
- Install and configure the SAP HANA extension on the SAP HANA database server.
- To install and configure the SEP sesam extension for SAP HANA, SEP provides a binary/script that automates the procedure of setting up and activating the SAP HANA Backint for database backup.
- Verify and test the integration.
- Make sure that the integration between SEP sesam and SAP HANA is functioning as expected and perform tests to validate backups and restores.
Configuring SAP HANA as SEP sesam Client
The procedure for configuring the SAP HANA database server as a SEP sesam Client involves adding the SAP HANA server as a SEP sesam Client and setting up two backup tasks. The first task, with the task type SAP HANA and <SID> as the source, enables the SEP sesam Server to accept backups from the SAP HANA system and serves to transport the database and log backups to the SEP sesam Server or RDS. The second task is intended for backing up SAP HANA configuration files and associated data.
- To add a client, in GUI go to Main selection -> Components -> Clients, select a location, and then click New client. Define the settings and options as required. Make sure that the selected access mode is SM SSH. For more detailed instructions, see Configuring Clients.
- Create backup tasks with task type Path to back up SAP HANA config files and all other required files. It is recommended to create separate backup tasks for global and for local config files. As Source specify all files except the database files.
Die Dateien liegen in den folgenden Verzeichnissen:- Globale Konfigurationsdateien: /usr/sap/<SID>/SYS/global/hdb/custom/config
- Beispiel: /usr/sap/SEP/SYS/global/hdb/custom/config
- Lokale Konfigurationsdateien (auf jedem Host): /usr/sap/<SID>/HDB<instance>/<SAP_hostname>
- Beispiel: /usr/sap/SEP/HDB00/saphanix1
- Select or create a schedule to specify when you want to back up your data, and then create a new backup event for each backup task. Select FULL as a backup level to perform a full backup. For more details, see Creating a Backup Event.
- Erstellen Sie optional einen separaten Medienpool, um die Sicherungen zu speichern.
Abbildungen
Abbildungen
Abbildungen
Configure backup in SEP sesam (recommended option)
To manage SAP HANA database backups externally with SEP sesam, SEP sesam provides the backup environment. On the SAP HANA database server, a Backint .utl parameter file must be created, which will contain instructions for the database backup process. For backup, the SEP sesam HDBBackint module interacts with SAP HANA through Backint. The .utl file includes parameters that SAP HANA requires to perform backup with SEP sesam, such as references to the SEP sesam server, the SSB logfile, and other specific settings necessary for the integration.
To configure the backup of SAP HANA in SEP sesam, the .utl file is set up with only the static SEP sesam parameters (SESAM_SERVER, SESAM_TASKEVENT, SESAM_HANA_SOURCE, SSB_LOGFILE and SESAM_PARALLEL_STREAMS). These parameters can remain fixed and define the core connection details between SAP HANA and SEP sesam. Variable parameters, such as the target media pool or migration task, are managed with backup event configuration directly in SEP sesam GUI. This approach allows you to adjust backup settings without needing access to the HANA host. For the list of all available SEP sesam Backint parameters, see SEP sesam Backint parameters.
- Create a SAP HANA backup task and set the general settings and parameters for the backup. In the Task type drop-down list select SAP HANA and set the Task name. The Source field is not used for backup and you can use it to write any descriptive name for the backup source. For detailed instructions on configuring the backup task, see Creating a Backup Task.
Note that the SAP HANA backup task cannot be used for regular file backups. It is required only for enabling the SEP sesam Server to accept backups from the SAP HANA server. Once all configuration steps are performed, this task is used to transport the database and log backups to the SEP sesam Server or RDS. - Select or create media pools for database and log backups. For detailed instructions on configuring a media pool, see Configuring a Media Pool.
- Optionally, configure a migration task for your SAP Hana database backup. For detailed instructions on configuring the migration task, see Creating a Migration Task.
- Optionally, configure a follow-up task for your SAP HANA database backup. For more information on configuring the follow-up task, see Follow-up Events.
- Configure the backup event for the SAP HANA backup task. You can set a migration task, follow-up event, and failover backup event. This enables you to manage and maintain the backup settings and related subsequent actions in one location, without making any changes on the SAP HANA host. Note that the name of the backup event is visible in the GUI in backup event properties window, not in the SEP sesam DB. For detailed instructions, see Creating a Backup Event.
- Continue the procedure by installing the SAP HANA extension.
Abbildungen
Abbildungen
|
|
Anmerkung |
| {{{1}}} |
Install and configure the SAP HANA extension on the SAP HANA database server
To install and configure the SEP sesam extension for SAP HANA, SEP provides a binary/script /opt/sesam/bin/sesam/sm_install_saphana2 that performs the following actions:
- generates .utl files in
/var/opt/sesam/var/ini/ - inserts the SEP sesam Backint parameters with the correct syntax in the .utl files
- setzen der erforderlichen Dateisystem Rechte
- activates the usage of Backint for database/archive log backup
- activates backup of the backup catalog introduced in SAP HANA V2
- adds the correct path and filename for the .utl file into the HANA database configuration file (specifically, the global.ini file).
Alle diese Schritten können bei Bedarf auch manuell ausgeführt werden.
- Voraussetzungen
Before you begin the installation, prepare the following information:
- SAP HANA Datenbank Name: <database_name>
- SAP HANA SID: <SID>
- SAP HANA Instanz Nummer: <instance>
- SAP user key (<user_key>) or alternatively SAP HANA credentials (<username> und <password>) for backup user
- Hostname (required for hdbsql connection)
- SAP HANA Server Hostname: <SAP_hostname> (default is OS hostname; required for creating TRACE path: /usr/sap/<SID>/HDB<instance>/<SAP_hostname>/trace)
- SEP sesam Server Hostname: <sesam_server_hostname>
- Backup event name: <backup_event_name>
Note that:
- Der Backup Nutzer benötigt die entsprechenden Rechte um die SAP HANA Datenbank zu konfigurieren, zum Beispiel der SYSTEM Nutzer der SYSTEMDB Datenbank.
- The syntax of SEP sesam Server hostname and SEP sesam RDS determines the type of connection between the SAP HANA Client and the SEP sesam Server or SEP sesam RDS including a control connection and/or data transfer. You have to use the same syntax as you find in the SEP sesam GUI -> Client properties (of your SEP sesam Server/RDS) -> Interface field (e.g., bck-srv.sep.de, http://bck-srv.sep.de:11000, https://bck-srv.sep.de:11443).
- Running the sm_install_saphana2 script
You can run the sm_install_saphana2 script by using either SAP HANA user store key or user/password combination. For more information see also Use the user store (hdbuserstore) for logging on to a database.
To install the SEP sesam extension, run the following command as Linux root user on the SAP HANA host:
sm_install_saphana2 -s <SID> -i <instance> {-U <user_key> | -u <username> -p <password>} -D <database_name> -E <backup_event_name> -C <sesam_server_hostname>
Zum Beispiel:
sm_install_saphana2 -s SEP -i 90 -U BackupUser -D SYSTEMDB -E HANA_SystemDB -C sesamServer.sep.de
oder
sm_install_saphana2 -s SEP -i 90 -u SYSTEM -p secret! -D PRD -E HANA_ProductionDB -C https://sesamServer.sep.de:11443
The options, specified with the sm_install_saphana2 command, are converted into SEP sesam Backint parameters and inserted in the .utl configuration file. In addition, the required parameter SSB_LOGFILE is also set automatically. For more information on SEP sesam Backint parameters, see SEP sesam Backint parameters.
For more help on the sm_install_saphana2 command, see the integrated online help by using the relevant command:
- For use with backup configuration using a backup event in SEP sesam (backup configuration of SEP sesam parameters in the SEP sesam database using task without schedule)
/opt/sesam/bin/sesam/sm_install_saphana2 -H
- For use with backup configuration of SEP sesam parameters on the HANA host
/opt/sesam/bin/sesam/sm_install_saphana2 -h
Verify and test the integration
Um zu prüfen ob die Installation und Konfiguration erfolgreich war, die folgenden Schritte ausführen:
- Search the folder
/var/opt/sesam/var/ini/for files with the extension .utl, check the content and verify the SEP sesam parameters. Note that all values in these files are case sensitive. For example, the folder should contain the following .utl files:/var/opt/sesam/var/ini/backint_SEP_PRD_catalog.utl/var/opt/sesam/var/ini/backint_SEP_PRD_data.utl/var/opt/sesam/var/ini/backint_SEP_PRD_log.utl
- Starten des SAP HANA Studio, doppel-klick der Instanz zum Öffnen und den Reiter Konfiguration wählen.
- Zu global.ini -> backup gehen und die backup Sektion ausklappen oder im Filter Feld das Wort backup eintippen. Dann überprüfen ob die folgenden Werte gesetzt sind:
- catalog_backup_using_backint should be set to true.
- log_backup_using_backint should be set to true.
- catalog_backup_parameter_file should have the correct values for System and for all already configured Database(s), for example, /var/opt/sesam/var/ini/backint_SEP_PRD_catalog.utl
- data_backup_parameter_file should have the correct values for System and for all already configured Database(s), for example, /var/opt/sesam/var/ini/backint_SEP_PRD_data.utl
- log_backup_parameter_file should have the correct values for System and for all already configured Database(s), for example, /var/opt/sesam/var/ini/backint_SEP_PRD_log.utl
Abbildungen
Der SAP HANA Backup Catalog verwaltet alle Sicherungen und enthält auch die Historie alles gelaufenen Sicherungen. Er ermöglicht SAP HANA die Prüfung ob eine Wiederherstellung möglich ist, welche Sicherungssätze dazu benötigt werden und welche Sicherungssätze nicht mehr benötigt werden. Bitte beachten, der Backup Catalog enthält nicht den Fortschritt einzelner Sicherungen, dieser wird im backup.log durch SAP HANA aufgezeichnet.
|
Achtung |
| Die Sicherung des Backup catalog ist erforderlich um eine Wiederherstellung einer SAP HANA Instanz auf einem anderen System durchzuführen. Stellen Sie sicher, das die Backup catalog Konfiguration wie oben gezeigt eingerichtet ist. |
SEP sesam Backint parameters
The SAP HANA Backint parameter file contains all relevant information for backing up SAP HANA with SEP sesam.
It contains parameters, which are used by the SEP sesam HDBBackint module. The file(s) are generated in /var/opt/sesam/var/ini/.
You can use different parameter files for different purposes (e.g., to store backups in different media pools). The parameter file used is declared by the -P PARAMETERFILE option for HDBBackint. A template parameter file /opt/sesam/skel/templates/backint_saphana.utl is available. You can copy the file to /var/opt/sesam/var/ini/backint_saphana.utl, rename it and modify it for your environment. Note that all specified parameters are case sensitive.
|
|
Anmerkung |
| {{{1}}} |
The following SEP sesam Backint parameters are available for configuring the backup process.
- SESAM_SERVER=<sesam_server_hostname>
- Name des SEP sesam Server
- SESAM_TASKEVENT=<backup_event_name>
- Dieser Parameter verweist auf den Namen des (ungeplanten) Sicherungstermins, den Oracle bei der Durchführung der Sicherung verwenden soll, so dass Benutzer einen Migrationsauftrag und eine Folgeaktion für die Sicherung festlegen können. Beachten Sie, dass der konfigurierte Sicherungstermin für einen Oracle-Sicherungsauftrag ungeplant sein muss (Option Ohne Zeitplan), was möglicherweise eine zusätzliche Konfiguration erfordert, siehe Termine ohne Zeitplan.
- When configuring the backup event for a SAP HANA backup task, you can set the migration task, follow-up event, and failover backup event, in addition to the general settings and parameters for the backup. This enables you to manage and maintain the backup settings and related subsequent actions in one location, without making any changes on the SAP HANA host. When backup is started, the SEP sesam Client on the SAP HANA host connects to the SEP sesam Server and retrieves all specified settings from the backup event configuration. When backup is finished, the configured migration task and events will be started. For more information on configuring backup events, see Creating a Backup Event.
- Beachten Sie, dass dieser Parameter die Parameter SESAM_JOB, SESAM_POOL, SESAM_TAPE_SERVER, SESAM_DRIVE, SESAM_MIGRATION_TASK und SESAM_FOLLOW_EVENT ersetzt.
- SESAM_PARALLEL_STREAMS=<integer value>
- Anzahl der parallelen Streams die SEP sesam verwendet für die Sicherung der SAP HANA Datenbank.
|
|
Anmerkung |
| {{{1}}} |
- SSB_LOGFILE=<log_file_name>
- Full path of the SEP sesam HDBBackint log file. As of SEP sesam Client ≥ Beefalo V2 the SSB_LOGFILE path is set to SAP HANA trace folder. The log file name contains more useful information and a new file is generated daily. It is recommended that you set the path and dynamic value for the log file name in the parameter as follows:
- SSB_LOGFILE=/usr/sap/<SID>/HDB<instance>/<SAP_hostname>/trace/hdbbackint_<database>_$u-%Y-%m-%d.log
If backup is configured with variable Backint parameters instead of the parameter SESAM_TASKEVENT, the following parameters are mandatory:
- SESAM_JOB=<backup_task_name>
- Name of the backup task that was created for the SAP Client.
- SESAM_POOL=<media_pool_for_DB_backup>
- Exakter Name des SEP sesam Medienpools, in dem die Sicherung abgelegt werden soll.
- SESAM_TAPESERVER=<sesam_RDS_hostname>
- Hostname of the RDS that you want to send the backup to (mandatory only if your backup target storage is connected to an RDS).
The following SEP sesam Backint parameters are optional:
- SESAM_DRIVE=<drive_number>
- Nummer (ID) des SEP sesam Laufwerks welches für die Sicherung verwendet werden soll. Die Laufwerksnummer muss zum Medienpool (der Laufwerksgruppe des Medienpools) passen, welcher im Parameter SESAM_POOL festgelegt wurde.
- Um die quellseitige Deduplizierung für externe Backups zu aktivieren, verwenden Sie den folgenden Parameter:
SESAM_DRIVE=DS@+_SSDD_
|
|
Anmerkung |
| {{{1}}} |
- SESAM_MIGRATION_TASK=<migration_task_name>
- Dieser optionale Parameter verweist auf den Namen des Migrationsauftrags, der nach erfolgreichem Abschluss der Oracle-Sicherung gestartet wird. Wenn SESAM_TASKEVENT verwendet wird, kann der Migrationsauftrag in der Konfiguration des Sicherungstermins angegeben werden.
- SESAM_FOLLOW_EVENT=<follow-up_event>
- Dieser optionale Parameter verweist auf den Namen der Folgeaktion, die gestartet wird, wenn die Oracle-Sicherung erfolgreich abgeschlossen wurde. Weitere Informationen finden Sie unter Folgeaktion. Wenn SESAM_TASKEVENT verwendet wird, kann die Folgeaktion in der Konfiguration des Sicherungstermins angegeben werden.
Additionally, the following parameter is available, but is not yet in use:
- SESAM_HANA_SOURCE=/<SID>/<instance>/<database_name>
- Reserved for future use, e.g, with backup and housekeeping scripts.
Manual installation procedure
In dieser Anleitung wird von den Standardpfaden ausgegangen. Wenn Sie eine SAP HANA-Instanz mit benutzerdefinierten Pfaden verwenden, müssen die Pfade entsprechend angepasst werden.
- Erstellen der Pfade für das hdbbackint-Executable und die Parameterdatei:
- Kopieren Sie die Muster-Parameterdatei aus dem Verzeichnis skel/templates in das SEP sesam ini Verzeichnis.
- Umbenennen der backint_saphana.utl Datei, wenn mehr als eine utl Datei benötigt wird (Empfehlung).
- Anpassung der Parameter in der *.utl Datei auf die SEP sesam Umgebung, siehe Abschnitt Die SAP HANA backint Parameter Datei.
- Erstellen eines Symlinks von
/opt/sesam/bin/sesam/hdbbackintzu dem Verzeichnis, wo SAP HANA das backint erwartet.
Üblicherweise sind hierzu root-Berechtigungen erforderlich. Dem entsprechend muss sichergestellt sein, dass das hdbbackint für den SAP HANA Benutzer ausführbar ist. - Erstellen eines Symlinks von
/var/opt/sesam/var/ini/backint_saphana.utlin das Verzeichnis, wo SAP HANA die Parameterdatei erwartet: - Dann starten des SAP HANA Studios, doppel-klick der Instanz zum Öffnen und Eingabe der korrekten Werte für die zu konfigurierenden Datenbank, so wie beschrieben in Prüfung der Installations-/Konfigurationsresultate.
root@hanasrv:~# mkdir -p /usr/sap/<SID>/SYS/global/hdb/opt/hdbconfig
root@hanasrv:~# cp /opt/sesam/skel/templates/backint_saphana.utl /var/opt/sesam/var/ini/
root@hanasrv:~# ln -s /opt/sesam/bin/sesam/hdbbackint /usr/sap/<SID>/SYS/global/hdb/opt/hdbbackint
root@hanasrv:~# ln -s /var/opt/sesam/var/ini/backint_saphana.utl /usr/sap/<SID>/SYS/global/hdb/opt/hdbconfig/
Repeat this procedure on every node of a scale-out system and for every database on the same system, if required.
Externe Referenz
SAP HANA Administrationshandbuch
Siehe auch
SAP HANA Installation Checkliste – SAP HANA Sicherung – SAP HANA Logbackup und Savepoints – SAP HANA Rücksicherung — Erstellen einer Systemkopie einer SAP HANA-Datenbank