Skip to Content
Author's profile photo Former Member

SAP HANA System Copy- Homogeneous Backup/Recovery Method

SAP HANA system copy Procedure-  Below is the HANA System copy (SWPM) using Backup/Recovery method from PRD to QAS.

— SID of HANA production is PRD- > So, schema will be SAPPRD

— SID of HANA Quality is QAS- > So, Schema will be SAPQAS

1. Take the backup of HANA Prd system

2. Copy/Move the the backup form PRD Host to QAS Host

3. Ensure that QAS is having enough space for Backup.

4. Download SWPM latest

5. Download Kernel.

6. Download SAP HANA License of QAS

Start SWPM and select Database refresh or DB Move

Profile Directory Of App server

Provide default Master Password for all users

Provide passwords for SIDADM & SAPServiceSID

Provide path of kernel Directory

Select Homogeneous System Copy method

Provide your DBSID as QAS , DatabaseHost will be QAS Host name & Instance number of QAS

SWPM will take the below schemas

Here Schema name should be SAPPRD

Provide SIDADM Password

Provide the location of the backup path as per Point 2 . Backup name should be the prefix name of the complete data backup. I have used the default backup name (COMPLETE_DATA_BACKUP).

Provide the location of SAP HANA QAS License as per Point 6.

Provide DDIC password

Select Local Client directory as HANA Client software Patch. Perhaps you can select “central directory also” Depends on the requirement.

After clicking “Next” You will be asked to check the final list of parameters and after confirming your actual HANA Refresh will start

Post Successful Completion, You need to update the hdbuserstore on SAP Application server. -> This will connect the SAP Application and HANA DB.

Run Report RS_BW_POST_MIGRATION to adjust SAP HANA Calculation views.

P.S: I am not including Post refresh activity steps. This will be common like other refresh activity.

Refrence Note:

1844468 – Homogeneous system copy on SAP HANA

1709838 – BW 7.3 on HANA: System copy using backup and recovery

Regards,

Pavan Gunda

Assigned Tags

      22 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo atul jain
      atul jain

      Good Pavan,Your shared your knowledge ,After learning in this Schema conversion after HANA refresh.

      BR

      AKJ

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Atul- I read in SAP Note 1709838 ..that Schema cannot be converted in HANA. 🙂  

      Author's profile photo Former Member
      Former Member

      Hi Pavan and other colleagues...

      • Folks

      just wanted to seek your opinion , guidance and direction... to see which is a better tool for generated reduced volume system copies from / for SAP Business Suite on HANA and BW on HANA.

      TDMS and EPI-USE - do very well when SAP runs on Non-HANA RDBMS.... what about when SAP runs on In-Memory HANA....

      Do you have any experience or can you advise - which is the best tool/ methodology for creating smaller Dev, QA etc from production size HANA systems

      Author's profile photo Brindavan Mookaiah
      Brindavan Mookaiah

      Hi Gunda,

      very valuable information you have shared....

      Thanks,

      Brindavan

      Author's profile photo Former Member
      Former Member

      HI Pavan,

      Thankyou. Nicely Presented..

      Regards

      Maruthi

      Author's profile photo Former Member
      Former Member

      Hi Pavan,

      Thanks for sharing.

      few questions:

      is this suite on HANA copy? BW on HANA copy ? or HANA in a side car environment (plateform edition) copy? was your backup on Disk or tape? what the SP of HANA?

      Regards

      Sachin

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Sachin,

      I don't think there will be a difference for "HANA copy? BW on HANA copy ? or HANA in a side car environment?".

      But However, this is for BW on HANA copy

      Regards,

      Pavan Gunda

      Author's profile photo Former Member
      Former Member

      Pavan-thanks for taking the time to provide  screen shots .  That's always extremely helpful and supplements what is in 1844468 - Homogeneous system copy on SAP HANA


      Regards,


      Dave

      Author's profile photo Former Member
      Former Member

      Hello Pavan,

      Thanks for the blog. 

      We need to do this exercise but the source and targets are tenants from separate multi-tenant databases with different SIDs and schemas (e.g. SAPDEV and SAPPRD).  Does this technique work for my scenario?

      Rex

      Author's profile photo Former Member
      Former Member

      Thank you Pavan

      Author's profile photo Former Member
      Former Member

      Thank you Dear Pavan

      Author's profile photo Tabrayz Abdul
      Tabrayz Abdul

      Hi Pavan,

      Thanks for the blog!! just wanted to ask one question in traditional database swpm use to stop at restore backup point and then we use to restore database and continue but as per your screen shots in hana we do not have to do that swpm it self will do the restore? kindly clarrify.

      Thanks

      Tabrayz

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Abdul,

      We dont need to stop SWPM. SWPM will it self do the restore.

      Regards,

      Gunda

      Author's profile photo Tabrayz Abdul
      Tabrayz Abdul

      Thanks Pavan appreciate your quick response !!!

      Thanks

      Tabrayz

      Author's profile photo Felipe Pezo A.
      Felipe Pezo A.

      Thanks Pavan, great job!

      Regards,

      @Fepezoabarca

      Author's profile photo Sankara Bavirisetti
      Sankara Bavirisetti

      Thanks Pavan,

      my scenario

      I would like to build new SID using backup restore from my multi tenant DB( two SIDs)

      using SWPM, any ideas please share and any differences when compare to traditional methods of make a new SID using system copy methods?

      Regards,

      Sankar

      Author's profile photo Mani Mandadi
      Mani Mandadi

      Thanks Pavan !!

      Author's profile photo Amar Dhamana boina
      Amar Dhamana boina

      Hi Pavan

       

      Thanks for the blog , was the production hana system encrypted , if so did you have to do manage the keys or was swpm took care of the encryption keys while doing the system copy to QA ?

      Author's profile photo Darren Martin
      Darren Martin

      I would like to know this as well

      Author's profile photo Ramazan Ekinci
      Ramazan Ekinci

      Great work.

      Author's profile photo Manoj Deverapalli
      Manoj Deverapalli

      Thanks for Sharing (y)

      Author's profile photo Gerardo Ramon Espino
      Gerardo Ramon Espino

      Hi,

      If you use the SAP HANA System Copy Homogeneous Backup/Recovery Method, and in the target system you have more than one schema, let's say a BW schema and a Native HANA schema, will this overwrite both schemas from the source to the target system? or would it be selective and only overwrite the schema of the BW system from source to target?

      Thank you.