Skip to Content

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


Pavan Gunda

You must be Logged on to comment or reply to a post.