You can duplicate a source database by cloning the snapshots that were created during a backup of the database. For information about which arrays are supported, see Application Clone.
Cloning uses the storage array hardware capability.
You can use the cloning feature to do the following:
-
Quickly duplicate large databases
-
Create test environments
-
Quickly retrieve data without intensive resource use on the production environment
-
Alleviate the load on production servers
Clone operations are supported on SAP HANA multi-tenant database containers with the following configuration:
-
SAP HANA 2.0 SPS01 and more recent versions on a single node setup
-
A SYSTEMDB that has one tenant database
Changes to Basepath Values in Clone Operations
During clone operations, the basepath values for data and log volumes are modified in the global.ini file of each target database. After the clone expires, the values for each database are reverted back to the original value.
Example: basepath_datavolumes
and basepath_logvolumes
values for SYSTEM and TST Tenant Databases
Before a Clone Operation
machine2:/usr/sap/TST/SYS/global/hdb/custom/config # grep basepath_datavolumes global.ini DB_TST/global.ini``global.ini:basepath_datavolumes = /hana/data/TST``DB_TST/global.ini:basepath_datavolumes = /hana/data/TST
machine2:/usr/sap/TST/SYS/global/hdb/custom/config # grep basepath_logvolumes global.ini DB_TST/global.ini``global.ini:basepath_logvolumes = /hana/log/TST``DB_TST/global.ini:basepath_logvolumes = /hana/log/TST
During a Clone Operation
Values are modified.
machine2:/usr/sap/TST/SYS/global/hdb/custom/config # grep basepath_datavolume global.ini DB_TST/global.ini
global.ini:basepath_datavolumes = /usr/sap/TST/clone/1147703/data/TST
DB_TST/global.ini:basepath_datavolumes = /usr/sap/TST/clone/1147703/data/TST
machine2:/usr/sap/TST/SYS/global/hdb/custom/config # grep basepath_logvolumes global.ini DB_TST/global.ini
global.ini:basepath_logvolumes = /usr/sap/TST/clone/17413/log
DB_TST/global.ini:basepath_logvolumes = /usr/sap/TST/clone/17413/log
After the Clone Expires
Values are reverted to the original values.
Note
If the values are not reverted after the clone operation, the target SID may not come online. In such cases, you must revert the values in the global.ini file manually.
machine2:/usr/sap/TST/SYS/global/hdb/custom/config # grep basepath_datavolume global.ini DB_TST/global.ini
global.ini:basepath_datavolumes = /hana/data/TST
DB_TST/global.ini:basepath_datavolumes = /hana/data/TST
machine2:/usr/sap/TST/SYS/global/hdb/custom/config # grep basepath_logvolumes global.ini DB_TST/global.ini
global.ini:basepath_logvolumes = /hana/log/TST
DB_TST/global.ini:basepath_logvolumes = /hana/log/TST