Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 

SAP HANA system copy Procedure- Below is the HANA System copy using Recovery method from PRD to QAS using Hana Studio

  • Take the backup of HANA PRD system

  • Copy/Move the backup form PRD Host to QAS Host

  • Ensure that QAS is having enough space for Backup.

  • Login to Hana Studio of QAS system with ID “SYSTEM”.

  • After Login to QAS system, go to Backup and recovery option.

  • From there select recover system option. Once you select this option database will shut down to process recovery.

  • Once the system got shut down, recover screen will open. Kindly select the option based on your requirement. Since I am doing refresh from PRD to QAS with Data backup. I selected the Last option.

  • If you want to backup from the specific path where the data file is stored, select option “Specify backup without catalog”.

  • Now provide the backup path and the same backup prefix name there in the “Backup Data file”.

  •  Provide the New license key path or you can skip this option and you can update license after recovery.


  • Make sure the backup file copied from the PRD system have proper permission of QAS system.

  • Once the recovery completed successfully, the database will start automatically. Make sure all services are running in HANA DB.

  • Please follow below steps at application Server:

    • Modify the default key hdbuserstore on the application servers and the DB instance.

  •                  Go to /usr/sap/<SID>/hdbclient   and execute the belowhdbuserstore set default <dbhost>:<dbport> <dbuser> <dbpassword>

    • Unlock the SAP<SID> and DBACOCKPIT ids in HANA DB.

    • Change the /dbs/hdb/schema parameter value to <Source schema value> in RZ10 DEFAULT.PFL

    • Try to check the R3tans –d in application server to establish a connection to the HANA DB, if the result is RC = 12. Analyse the trans.log file.

After changing all the things in Application server, start the SAP using cmd "STARTSAP R3".

  • Next install the license key for application server and HANA if not installed during recovery.

  • Once the SAP system service started, kindly run the transaction to complete the post refresh activities SICK, SGEN, BDLS, RZ10, RZ12, SCOT, SOST do the changes.

  • Call transaction SECSTORE.

  • Choose "Execute" (F8).In the entries that are displayed, delete the entry /HMAC_INDEP/RFC_INTERNAL_TICKET_4_TRUSTED_SYSTEM if it is marked with a red traffic light.In the entries that are displayed, delete the entry /HMAC_INDEP/RFC_EXTERNAL_TICKET_4_TRUSTED_SYSTEM if it is marked with a red traffic light.

  • In transaction SE37, execute the function module RFC_PING with the destination NONE. If the system displays an error message, execute the function module RFC_PING again; the error message cannot appear a second time in this case.

Labels in this area