Home > Workload Solutions > SAP > Guides > SAP HANA TDI Guides > Business Continuity and Disaster Recovery with Dell PowerMax Storage for SAP HANA TDI Deployments > Detailed steps
The following steps include command examples.
Note: For a full explanation of the command structure, see the Dell Solutions Enabler SRDF Family: CLI User Guide.
server01:/usr/sap/RDF/HDB01> hdbsql -n server01 -i 01 -u system -p system password BACKUP DATA CREATE SNAPSHOT
where:
symsnapvx –sid 016 –sg HANA_SG_R2 –name R2_HANA_SNAPSHOT establish
Note: Setting an expiration (-ttl) is considered best practice.
Solutions Enabler has a –both_sides option that can be used with synchronous SRDF replication and device groups. Using the –both_sides option with the SRDF group creates two snapshots with the same data—one at the source and one at the target.
To display the snapshot details, run:
symsnapvx –sid 016 list –sg HANA_SG_R2 -detail
To display the snapshot state, run:
symsnapvx –sid 016 list –sg HANA_SG_R2 -summary
The state of the devices should be Established.
Note: SnapVX gives you the ability to create snapshots of an entire storage group by using a single command. A target storage group can be linked to the snapshot to present a point in time for an entire storage group. Use the –sg option on the control commands.
server01:/usr/sap/RDF/HDB01> hdbsql -n server01 -i 01 -u system -p <system password> "SELECT * FROM "PUBLIC"."M_BACKUP_CATALOG" WHERE STATE_NAME = 'prepared'"
The command returns:
ENTRY_ID,ENTRY_TYPE_NAME,BACKUP_ID,SYS_START_TIME,UTC_START_TIME,SYS_END_TIME,UTC_END_TIME,STATE_NAME,COMMENT,MESSAGE,SYSTEM_ID
1436417247184,"data snapshot",1436417247184,”2015-07-09 00:47:27.184000000","2015-07-09 04:47:27.184000000",?,?,"prepared""",""
Use the Backup_ID to close the storage snapshot.
server01:/usr/sap/RDF/HDB01> hdbsql -n server01 -i 01 -u system -p <system password> "BACKUP DATA CLOSE SNAPSHOT BACKUP_ID 1436417247184 SUCCESSFUL 'HANA Storage Snap'"
symsnapvx –sid 016 –sg HANA_SG_R2 –lnsg HANA_SS –snapshot_name R2_HANA_SNAPSHOT –gen 0 link -copy
You can use the data and log clones in the target storage group to start a point-in-time copy of the production database (the SAP HANA snapshot) at the remote site, while still running production at the source site and while SRDF/S or SRDF/A replication to the destination site is active.
To display the snapshot details, run:
symsnapvx –sid 016 list –sg HANA_SG_R2 -detail
Verify that a link exists for the snapshot.
To display the snapshot state, run:
Symsnapvx symsnapvx –sid 016 –sg HANA_SG_R2 list -linked –lnsg HANA_SS –snapshot_name R2_HANA_SNAPSHOT -detail –sid 016 list –sg HANA_SG_R2 -summary
/usr/sap/hostctrl/exe/sapcontrol -nr <instance_number> –function StartSystem HDB
Note: An SAP HANA storage snapshot requires only the data area. If the log area is included in the storage snapshot. Exercise care with how the SAP HANA database is restarted. Any committed transactions will be replayed from the log area between the time of the SAP HANA storage snapshot and the actual storage snapshot. Optionally, in a DR scenario, you can replay the log backups.
i Select and right-click the SAP HANA SID and select Backup and Recovery > Recover System.
ii Select Recover the database to a specific data backup or storage snapshot.
iii Select the SAP HANA storage snapshot from the backup catalog, and then select initialize logs to start the recovery to the consistent point-in-time snapshot.
In both cases, the SAP HANA storage snapshot is used and then removed after successful startup.
Note: For more information about SAP HANA storage snapshots and recovering the SAP HANA database, see the SAP HANA Administration Guide.