Register Login

How can the storage snapshot support be enabled for the SAP HANA database?

Updated May 19, 2018

How can the storage snapshot support be enabled for the SAP HANA database?


Comments

  • 16 Apr 2015 4:45 pm Shalesh Singh Helpful Answer

    Storage snapshot support is enabled using a loose coupling between the SAP HANA database and the storage system. The creation of a storage snapshot is done in three steps that must be executed on the SAP HANA database site as well as on storage system level. The SAP HANA database offers SQL statements to PREPARE, CONFIRM and if needed ABANDON a storage snapshot.

    Step 1: The SAP HANA database has to be requested to PREPARE itself for the storage snapshot. This is done by executing the SQL statement BACKUP DATA CREATE SNAPSHOT which has to be given once to an arbitrary HANA index server.

    Step 2: The storage snapshot of the entire data area of all database services must be created using the storage system functionality.

    Step 3: Finally the result of the storage snapshot creation must be reported to the SAP HANA database even if the storage snapshot failed, because the SAP HANA database has to clear internal states. For that purpose use the SQL statement "BACKUP DATA CLOSE SNAPSHOT BACKUP_ID <backup_id> SUCCESSFUL <external_id>" for confirmation or "BACKUP DATA CLOSE SNAPSHOT BACKUP_ID <backup_id> UNSUCCESSFUL [<string>]" for abandoning the snapshot.

    Please be aware that the confirmation of a snapshot might result in an SQL error, if a database service was restarted during storage snapshot creation.

    Following these steps most storage system vendors offer plugins that encapsulate the SAP HANA storage snapshot functionality, i.e. storage snapshots can be performed using the storage system administration console only. Please ask your storage vendor for more details.


×