Loading...

SAP HANA Clone Environments

You can duplicate the source database by cloning the snapshots that were created during the backup.For information on the supported arrays, see Instant Clone for Applications.

Clone operations are supported on SAP HANA Multitenant Database Containers with the following configuration:

  • SAP HANA 2.0 SPS01 and higher Multitenant Database Containers on a single node setup.
  • A SYSTEMDB that has one tenant database

The cloning feature uses the storage array hardware capability.

You can use the cloning feature to:

  • Duplicate large databases in a short amount of time
  • Create test environments
  • Retrieve data quickly without intensive resource use on the production environment
  • Alleviate the load on production servers

During the clone operation, 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.

The following example displays the basepath_datavolumes and basepath_logvolumes value in the global.ini for SYSTEM and TST tenant databases. You will notice that the value reverts back to the original after the clone expires.

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:

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:

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

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.

Last modified: 9/5/2019 9:38:55 PM