Configuring SAP HANA Persistent Log Backups

The SAP HANA database can produce a large number of log files that you must back up to successfully restore your database.

By default, the SAP HANA agent backs up the log files from all the SAP HANA database services as one persistent log backup job every 6 hours. This operation caches the media resources throughout the job.

The agent gracefully shuts down the SAP HANA service, and marks the backup job as complete when any of the following conditions are met:

  • There is a job failure

  • The specified time period expires

  • There is no log activity for one hour

After the service is shut down, the next log request starts the process with a new job ID.

You can disable the persistent log backup feature or configure your agent to run one persistent log backup job for each SAP HANA database service, using additional settings.

When you disable the feature, the agent backs up each log file as separate backup jobs.

Procedure

  • To the SAP HANA client, add the additional settings as shown in the following table.

    For instructions on how to add additional settings from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.

    Additional Setting

    Category

    Type

    Value

    nPersistentLogBackup

    SapHanaAgent

    Integer

    0 - to disable persistent log backup

    1 - to enable persistent log backup

    nPersistentJobPerService

    SapHanaAgent

    Integer

    0 - to run one persistent log backup job for all the database services.

    1 - to run one persistent log backup job for each database service

Loading...