Loading...

Creating a SAP HANA Clone Environment

You can duplicate the source database by cloning the snapshots that were created during the backup when you use any of the following arrays:

  • NetApp
  • Pure Storage
  • EMC Timefinder Clone

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

Create a clone from an existing data and log volume full backup. When you create a clone, the SnapProtect software automatically shuts down the clone database and frees up all resources (including the snapshot clones on the storage array) when the reservation period expires. The default reservation period is 1 hour, but you can modify the time period based on your business needs.

Schedule clones to run periodically so that the clones are refreshed on a regular basis.

Note: You can only create a clone on a the same destination as the source or a new destination, but the SID must be different from the source.

Before You Begin

  1. Verify that the SAP HANA database version on both the source and destination databases are the same.
  2. Install the SAP HANA Agent and the MediaAgent on the SAP HANA destination client.
  3. You can clone a database to the same or different computer. If you clone a database to an instance that resides on a proxy computer, the following criteria must be met:
    1. The SAP HANA database version on the proxy computer must be the same as the version on the source database.
    2. The proxy computer must have access to the storage array that contains the source database volumes.
    3. The SAP HANA  Agent and the MediaAgent must be installed on the SAP HANA destination client.
  4. Perform an SnapProtect  full backup.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > pseudo-client.
  2. Right-click the instance, point to All Tasks and then click Clone.
  3. On the Clone Options dialog box, determine the backup to use for the clone.
    • To use the latest backup, select Latest Backup and then click View Content.
    • To use a backup from a specific time, select the Absolute Time option and then enter the End Time date and time.
  4. In the right pane of the CommCell Browser window, select the entire database to clone, and then click Clone.

    The Clone Options dialog box appears.

  5. On the General tab, specify the destination information.
    1. From the Destination Client list, select the clone destination host.
    2. From the Destination Instance list, select the clone destination instance.
    3. In the Destination Instance HANA Data Directory box, type the full path where the destination instance data resides.
    4. Choose the restore type.
      Expand All

      Recover the database to the most recent state

      1. Select Recover Database To.
      2. Select Most Recent State.

      Restore to a point-in-time

      1. Select Recover Database To.
      2. Select Point In Time.
      3. Select the date and time.

        Note: If the time zone is different on the CommServe computer and client, in the Time Zone box, select the client computer time zone.

      Recover only the data

      1. Select Recover data only.
      2. In the Backup prefix box, type the backup, type the job ID of the backup job that you want to restore.

        For SnapProtect jobs, this has the format of '<job_id>_SNAP'. For information on how to view the job id, see Viewing Job History.

    5. To verify that all the backups required for the recovery operation are available, select the Check Access check box.

      The software selects this option by default.

    6. If you chose to restore to a point-in-time, to have the software initialize the log area after the restore, select the Initialize log area check box.

      Note: For restores that are not to a point-in-time, the software automatically selects this check box and makes this check box unavailable.

    7. Best Practice: Select the Use Delta Backups check box.

      Note: This is the default option. If you do not select this check box, the software only uses the log backups for the recovery operation.

  6. On the Clone Options tab, specify the options.
    1. Optional: To have the software mount the snapshot to a non-default location, in the Snap Mount Location box, type the full path.

      By default, the software mounts the snapshot to the <software_install_path>/Base/Temp/<Restore_JobID> directory, where the Restore_JobID represents the clone job ID.

      Note: The SAP HANA user must have write permissions to this directory.

    2. In the Reservation Period box, specify time in days and hours that the software retains the test environment.

      Note: The default time to retain the clone is 1 hour. When this time expires, the software dismounts the database and deletes the mount point.

    3. If you chose to restore to a point-in-time, to have the software initialize the log area after the restore, select the Initialize log area check box.

      Note: For restores that are not to a point-in-time, the software automatically selects this check box and makes this check box unavailable.

    4. To have the software clean up any existing clone on the destination that has the same clone SID, regardless of the reservation period, select the Overwrite if clone exists check box.
  7. Optional: Have the software automatically refresh the clone with the latest backup:
    1. On the Job Initiation tab, select Schedule, and then click Configure Schedule Pattern.

      For information on how to configure a restore schedule, see Schedule Restores.

  8. Click OK.