Wednesday, 3 February 2016

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

SAP HANA Tutorial, SAP HANA Certifications


SAP HANA Homogeneous


Profile Directory Of App server

SAP HANA Back-up

Provide default Master Password for all users

SAP HANA Certifications, SAP HANA Material

Provide passwords for SIDADM & SAPServiceSID

SAP HANA Recovery, SAP HANA

Provide path of kernel Directory

SAP HANA  Homogeneous  Backup/Recovery

Select Homogeneous System Copy method

SAP HANA Tutorial, HANA Cerifications

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

SAP HANA Certifications

SWPM will take the below schemas

SAP HANA Backup and Recovery

Here Schema name should be SAPPRD

SAP HANA Recovery

Provide SIDADM Password

SAP HANA Tutorial

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).

SAP HANA System

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

SAP HANA Homogeneous

Provide DDIC password

SAP HANA Backup/Recovery Method
Select Local Client directory as HANA Client software Patch. Perhaps you can select "central directory also" Depends on the requirement.

SAP HANA Backup/Recovery Method


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

SAP HANA Backup and Recovery Method

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.

Source: scn.sap.com