SAP HANA One Migration via Data Backup and Recovery

Swapan Saha

Posted by Swapan Saha on September 26, 2013

Senior Director, Big Data Product Management

More by this author

Use Cases

  • Migrate older versions of HANA One to the latest HANA One Rev 52.1 (HANA Upgradable)
  • Migrate HANA contents from HANA Dev Edition to HANA One Rev 52.1 (HANA Upgradable)

Motivation

SAP released HANA One Rev 38, HANA One Rev 48 and HANA Rev 52 prior to the releasing HANA One Rev 52.1. HANA One Rev 52.1 has self-service upgrade capability via Addon Manager [blog]. Customers using HANA One Rev 52.1 can continuously upgrade to the latest HANA version as a self-service option and can also extend 1 year license key at its expiry or install a valid license key, if needed. However, customers using HANA One prior to HANA One Re 52.1, cannot upgrade HANA nor can extend license key. This blog provides a step by step procedure to migrate older releases of HANA One to the latest HANA One to take advantage of new Addon feature in HANA One Rev 52.1.

With the availability of HANA License Key 1.0 in HANA One Rev 52.1 from September 23 2013, customers can use database backup and recovery (system copy) to migrate their HANA contents from HANA One Rev 48 or HANA One Rev 52 to HANA One Rev 52.1. However, this feature is not applicable to HANA One Rev 38 (1 year license expires in early October 2013). The only option to migrate HANA contents from HANA One Rev 38 to HANA One Rev 52.1 is using HANA export and import utility. Even though the focus here is HANA One migration, the same procedure can be followed, if anyone wants to migrate HANA contents to HANA Dev Edition to HANA One.

In HANA One at AWS (an example of a public cloud), a database copy is possible as it uses file-based backups only. To simplify the migration in the cloud, only the data backup files are considered here. This restores the content exactly as of the point in time at which the data backup was created.

Prerequisites

However, few prerequisites must be met:

  • A database backup of the source system is available.
  • The version of the target system is the same or higher than the source system. Except HANA One Rev 38, all HANA One versions met this criterion.
  • The target system has sufficient disk space and memory. Once a new HANA One Rev 52.1 instance is launched, it meets this criterion.
  • The target system configuration is usable for the recovery of the source system. The type and number of services (for example, indexserver) must be identical in both systems. HANA One is not expected to change any internal configuration and hence, it meets this criterion too.
  • A license key file is available for the target database. The license key of the source system will not work in the target system. HANA One Rev 52.1 includes HANA One License Version 1.0 since September 23, 2013.

Procedure

  1. Stop the source HANA instance.
  2. Take data backup. You can use HANA Studio to take data backup or use HANA One management console (Rev 52 and onward).
  3. Launch a new HANA One Rev 52.1 instance as your new target system (Start an Instance on AWS).
  4. Transfer backup files from your source system to your target system.
  5. Use HANA Studio (Rev 52) to recover the data only.
  6. Use Addon feature in HANA One Rev 52.1 to install HANA Rev 52.1 License Key 1.0, Once recovery is successful,.
  7. Verify the license at your Rev 52.1 instance and content.

Example – Migrate HANA One Rev 48 to HANA One Rev 52.1

Step -1: Check Studio and Server version of the source system as shown here. Stop Source HANA System Using HANA Studio Rev 48.
/wp-content/uploads/2013/09/rev48version.png

Step 2: Take Rev 48 backup using HANA Studio Backup Wizard as shown below

/wp-content/uploads/2013/09/backupoption.png

Choose the location of backup files

/wp-content/uploads/2013/09/backupstart.png

After clicking Next and then click Finish; backup starts and completes as shown:

/wp-content/uploads/2013/09/backupsucess.png

Step 3: Launch a new HANA One Rev 52.1 instance as your new target system

Step 4: Transfer backup files from the source system to the transfer system

Transfer backup data files /backup/HDB/REV48_* from the source system to the target system as shown below using the target instance *.pem file placed at /root/Demo.pem of the source system. Here, the same key-pairs is used in the source and target system.

/wp-content/uploads/2013/09/filepermission.png

Then using scp, files from the source system are copied to the target system’s /backup/HDB/data

/wp-content/uploads/2013/09/filetransfer.png

After files are transferred 100% successfully, change the ownership of the files at the target system to <sid>adm (hdbadm here).

/wp-content/uploads/2013/09/filetransferred.png

File transfer is complete and necessary permission to the <sid>adm user is added to the target system. Now these files are ready for recovery at the target system.

Step 5: Use HANA Studio (Rev 52) to recover the data only (no logs) Rev 52 Studio

/wp-content/uploads/2013/09/recoverywizard.png

Agree to shutdown the system and then select only a specific data backup option.

/wp-content/uploads/2013/09/recoverydata.png

Specify the backup files as shown below

/wp-content/uploads/2013/09/recoverylocation.png

Check all the parameter and click on Finish button to start recovery. Ignore new license key install.

/wp-content/uploads/2013/09/recoverynext.png

/wp-content/uploads/2013/09/recoveryfinish.png

Wait till recovery is complete and after successful recovery, you will see the following message.

/wp-content/uploads/2013/09/rcoverysuccess.png

After recovery, license became invalid as shown in the Studio.

/wp-content/uploads/2013/09/licenseexpired.png

Step 6: Install License Key using Addon Manager

In the Addons tab, find HANA License 1.0 package and click on Download & Install button.

/wp-content/uploads/2013/09/downloadinstall.png

Enter SYSTEM DB password and hit on Submit button.

/wp-content/uploads/2013/09/installlicense.png

After license key is installed, under installed tab, you will see the package installed successfully.

/wp-content/uploads/2013/09/licenseinstallsuccess.png

Step 7: Verify license key and HANA content

You can verify the license key both at HANA One Management Console Admin page and at HANA Studio.

License key confirmation at HANA Studio

/wp-content/uploads/2013/09/newrev52license1.png

License key information at HANA One management Console Admin tab

/wp-content/uploads/2013/09/newrev52license2.png

Conclusion

Congratulations! You have successfully migrated to HANA One Rev 52.1. You can further upgrade your instance from HANA Rev 52 to the latest SP (HANA Rev 66 at the time of this blog). Even though the blog is created to migrate HANA contents from older releases to the latest HANA One release, similar steps (with minor changes in the file locations) can be followed when a wiling HANA Dev Edition customer is ready to move to HANA One as long as the source version of HANA is greater than Rev 45.

VN:F [1.9.22_1171]
Average User Rating
Rating: 5.0/5 (2 votes cast)
SAP HANA One Migration via Data Backup and Recovery, 5.0 out of 5 based on 2 ratings

10256 Views