How can the storage snapshot support be enabled for the SAP HANA database?
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.
Sign up for STechies
Ask Question From Our Experts
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.