Skip to Content
Author's profile photo Gerard Clarence Christopher Aloysius

DB Refresh of HANA Based systems using HANA Studio Backup/Recovery without SWPM

DB Refresh using HANA Studio DB Restore  with SID Modification –  NON SAPinst

HANA Studios DB restore option and hdbuserstore there after makes the whole process of a  System copy a lot simpler . The only limitation would be that the target schema would still remain as source.

The idea of this blog is to explain the process of performing  a simple homogeneous system copy of a HANA based system using the recovery of the source backup on the target HANA DB using HANA Studio.

In this case ,we will be  considering a situation of copying a Prod backup and refreshing it in a already running quality system

These are the salient steps involved in achieving this

Step 1 ) Take a complete DB backup of the source Database

Step 2) Move the database backup to the Target system

Step 3) Using HANA Studio recover the source db in the target HANA box

Step 4) Supply the license text so that the HANA Studio can automatically apply the license after install

Step 5) Modification of Schema access at the target DB

Step 6) Modify the default key  using the hdbuserstore on the application servers  and DB instance.

Step 7 ) Start sap

Step 8 ) Post activities.

Activities in the Source System :

Step 1 – Backup of the source DB .

Use the HANA studio backup studio to take a complete DB backup either at the disk level or using Backint.



image Courtesy : SAP HANA Backup/Recovery Overview by Andrea Kristen in SCN

Usually this should be sufficient to perform a DB Refresh but if you are looking for a  point in time recovery you may want the backups from the log area as well to include them post the recovery.

Step 2 ) : Move the database backup to the Target system

Once the backup is completed you will have to move the backup to a location in the target system , you should have 4 separate files with the your backup prefix . In this case the prefix is “COMPLETE_DATA_BACKUP_20122015”





Activities in the Target system

Step 3 ) Using HANA Studio recover the source db in the target HANA box

→ Shutdown SAP Application alone

→ Open HANA Studio and right click on the SID ( target) where you want to perform the recovery.

You will have to specify the destination location and the Backup Prefix for the HANA studio to recognize the backups .

If you just have a Complete data backup and not planning to recover log segments you can select the option “ Initialize Log area”… This is something like reset logs in oracle.

Step 4) Supply the license text so that the HANA Studio can automatically apply the license after install

  Post recovery your existing HANA License will be invalid , so here is a opportunity to mention the license text so that that can be installed automatically. If not this can be performed manually later.

Step 5 ) Proceed with the recovery . Please note that the Target and source version must have the same configuration. Is there are specific configuration thats required in the target system that can be done manually as part of the Post steps.

Post recovery you should be able to see the Overview tab in HANA Studio with the Memory and Host Details.

However you may expect to see all the schemas under Catalog but it will error out as below. Same would occur when you try to expand Content.

The reason being the new SID will probably be looking for a schema name as SAPSID and it cannot find it , so there are few changes that need to be done in the target system

Step 6) Modify the default key hdbuserstore on the application servers and the DB instance.

  • Go to /usr/sap/<SID>/hdbclient   and execute the below

hdbuserstore set default <dbhost>:<dbport> <dbuser> <dbpassword>

Let say for example our target host is : host01 and Source SID is  PRD and System No : 00  and lets assume that the source schema is SAPPRD and its password is sapprd#!

hdbuserstore set default host01:30015 SAPPRD sapprd#!


The above example is for the Unix system for Windows its a bit different (Refer SAP Note 1709838)


Execute a hdbuserstore list you should find the new Key set as below

KEY DEFAULT

   ENV:host01:30015

User: SAPPRD

This confirms that the key is set .

This has to be done on the appservers , else R3trans -d would fail.

Go back to HANA Studio and you should be able to see the contents under Catalog and Contents. You should also find the source Schema under Catalog.

At this point there is one more thing that needs to be done before we start the apps on the target system.

go to the DEFAULT profiles and modify the /dbs/hdb/schema to SAPPRD ( or whatever your source schema is ) .

At this point you are good to start SAP.

Follow the standard Post Refresh activities from there..

Few points to remember

– > You may want to disable the btc processes before starting SAP

→ Perform standard post steps like SE06/STMS/BDLS etc and activities specific to your case.

Assigned Tags

      30 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Dear  Gerard Christopher,


        Thanks for sharing . It'll be helpful for further reference .


      Regards,

      Amarnath Naik

      Author's profile photo Former Member
      Former Member

      Thanks  for sharing.  Got a good insight.

      Author's profile photo Former Member
      Former Member

      Thanks , but tell me one thing that i want to keep the schema of my Quality system same say" SAPQAS" and not SAPPRD.

      Can you let me know if we have to go for SYSTEM RENAME for HANA.

      Author's profile photo Gerard Clarence Christopher Aloysius
      Gerard Clarence Christopher Aloysius
      Blog Post Author

      Sharad,

      if you want to retain the scehma as SAPQAS , one option would be to use SWPM and perform a R3load export/import.

      Rename is to rename the Host and may not effect a schema change.

      I have read about schema mapping  but at a high level i think SWPM export/import would make more sense. Never tried schema mapping though.

      Author's profile photo Former Member
      Former Member

      Sharad,

      You can change the SID of the target system. But you cannot change the name of the database schema(Bakup/Restore) method. I have done multiple system copies with Backup and Restore for the HANA.

      As Gerard said above(Export/Import) ..it might be possible for schema rename from the HANA directory with rename option with the Binary Export/Import. Haven't tried yet to see if that works 🙂  

      Regards,

      Avinash

      Author's profile photo Diego Hernandez
      Diego Hernandez

      Good job, thanks for sharing

      Author's profile photo Gerard Clarence Christopher Aloysius
      Gerard Clarence Christopher Aloysius
      Blog Post Author

      You are welcome!

      Author's profile photo Former Member
      Former Member

      Nice.

      Thanks for sharing.

      Author's profile photo Gerard Clarence Christopher Aloysius
      Gerard Clarence Christopher Aloysius
      Blog Post Author

      You are welcome . Hope its helpful.

      Author's profile photo Former Member
      Former Member

      Thanks for sharing .I think step 5 is missing.

      Author's profile photo Gerard Clarence Christopher Aloysius
      Gerard Clarence Christopher Aloysius
      Blog Post Author

      Hi Mustafa.. No problem.. Just got missed out while formatting . However its there . just that it didnt say Step 5. Corrected it now. Thanks for pointing out.

      Author's profile photo Former Member
      Former Member

      Hi Gerard - We are trying to perform S/4HANA on SAP HANA SPS10 DB refresh and we performed hdbuserstore and other done religiously , but still there is an issue while running R3trans -d .We followed OSS Note -     2154997 but it also did not work. Do we need to do the run of rssecsfx for SAP HANA 10 onwards. Could you comment to help us on solution of the problem.

      Author's profile photo Former Member
      Former Member

      Hi Sharad,

      What issue you are facing. Can you please paste the trans.log file.

      Regards

      Maruthi

      Author's profile photo Prem Sukh Bishnoi
      Prem Sukh Bishnoi

      Hi,

      Lets say production system database  backup is configured via  backint (not file system) and now is there any way that i can restore that backup taken via backint to preprod or quality system directly ?

      Regards,Prem

      Author's profile photo Former Member
      Former Member

      Hi Prem,

      What backint tool are you using? For example in our case we are using Backint (EMC DD Boost). While performing the restore we make changes to the configuration files of backint of quality system to point to production backint configuration and then choose the backup(production) you want to use to restore to a specific date or time. Once the restore is complete then point back the backint configuration files to quality settings.

      Hope this helps

      Regards

      Avinash

      Author's profile photo Prem Sukh Bishnoi
      Prem Sukh Bishnoi

      Ok thanks for reply. What would be impact on production data  and log backup using the same API to recover the data to qaulity. Lets assume that recovery time is 6hrs-8hrs.

      Regards,

      Prem

      Author's profile photo Former Member
      Former Member

      Prem,

      There is no impact as you are not stopping the backint to perform backups for the Production.

      You  are making changes to the quality system backint configuration files to point to production in order to fetch the backups from the backup catalog of the production backint.

      Make sure you point back the config settings to Quality once the restore is complete. Otherwise it will mess up production backups

      Regards,

      Avinash

      Author's profile photo Former Member
      Former Member

      Hi All,

      I believe Schema owner is not possible after Hana backup/restore using Hana Studio. To avoid confusion We have used generic schema name as "SAPBIW" while migrating our BW on oracle to Hana database.

      Regards

      Maruthi

      Author's profile photo Akash Garg
      Akash Garg

      Guys, please help me on this issue.

      SAP system refresh - How to exclude HDB Users and Roles

      Author's profile photo Sadik Iqbal Siddiqui
      Sadik Iqbal Siddiqui

      Hey  Gerard


      Very nice !!


      Thanks

      Sadiq

      Author's profile photo Jitendra Kumar
      Jitendra Kumar

      Hi Gerard,

      Nice one!!

      regards

      jitendra

      Author's profile photo Former Member
      Former Member

      Very nice, seems like it works.

      My only concern though is that when running R3trans -d, the NTAB still refers to the production system. Does anyone have a step to resolve this one? The SWPM seems to change this pointer.

      Thanks !

      Author's profile photo RK V
      RK V

      Blog is very informative.. Thanks. Need expert advice in below scenario.

      Our current environment is as ECC - SLT - HANA (version 10) which is sidecar approach

      whenever we refresh ECC (no-production) system, selected tables will replicated to HANA, which will take almost 6-7 days workload.

      Inorder to optimize, Would like to cut down time avoiding replication from the scratch.

      >Idea is to backup/restore of ECC-SLT-HANA to non-prod environment, later how to proceed further to bring to operational state.

      Can you suggest how it can be achieved, please share if you have useful links/docs info.

      Thanks
      Ram

      Author's profile photo Rodrigo Aoki
      Rodrigo Aoki

      Hello,

      Very helpful for a fast refresh of QA running ECC/ ABAP.

      Does anybody have a recipe for WAS Java? We made a database refresh where the backup contains both ABAP and Java schemas. The main procedure (using SWPM) recovered the entire database and executed the post restore steps for ABAP.

      And now... what to do to executing the post installation steps for WAS Java?

      Regards,
      Rodrigo

      Author's profile photo Former Member
      Former Member

      Hi Gerard,

       

      is this Applicable for Multitenant Database Container, where i would like to Copy production Tenant database to a Quality Tenant Database..

      Any Suggestions will be appreciated.

       

      Regards

      Ahmed Mohammed

       

      Author's profile photo Angel Perales Iecisa
      Angel Perales Iecisa

      Hello Gerard,

       

      yo say i point 5 "so there are few changes that need to be done in the target system" but i can't find what changes need to be done in the documents.

       

      Could you explain what changes are?

       

       

       

      Regards.  Angel

       

      Author's profile photo Former Member
      Former Member

      Guys,

      We are going to perform QAS refresh.We have around 30 hana user created in qas system. After Prod refresh, we would to require same 30 users and profiles QAS hana database.

      Anyone knows how to take backup of  Hana users before starting of refresh.

       

      Regards,

      Baskaran.V

      Author's profile photo Former Member
      Former Member

      how can I perform same for a JAVA system?

      what are all the post activities for SolMan JAVA system refresh?

      Author's profile photo Nitin Wagh
      Nitin Wagh

      Nice information.

      Author's profile photo Dheen AJ
      Dheen AJ

      Hi,

       

      Very usefull blog.

       

      hdbuserstore set default host01:30015 SAPPRD sapprd#!
      go to the DEFAULT profiles and modify the /dbs/hdb/schema to SAPPRD ( or whatever your source schema is )

       

      While restore we are changing above, after restore successful do we have to modify again in target system to previous values?