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.