SAP system copy using backup and restore for hana system replication

[former_member1291785]

Dear Experts,

I and doing SAP hana system replication ( my primary server On-Premises and secondary server on AzureI am using SAP HANA database version 2.0 sp4 on suse enterprise linux 12 sp4. I am stuck in database restoration in secondary server.

When I was migrate my sap database from Oracle to HANA During the installation of hana database software gave HDB databased name ( which was dummy ) sap create user with then name hdbadm and all folders etc. during the migration of hana using SUM DMO I gave taget DB SID ERP

After the migration I have 3 databases (1.SYSTEMDB2. HDB3. ERP ( which is for SAP ) and my schema name SAPERP not SAPABAP1 ) SAP working fine , now I am creating system replication for the I am using system copy usingbackup and restore method .

I taken complete database backup for all above three databases and first restored SYSTEMDB database in secondary system (which is located in azure and my primary database On-Premises) which was successfully completed then HDB which was also completed successfully but which I repeat the same process for ERP usinghana studio which is not give any response during restoration and blank screen in same status last 2 hour no job running I am not able to understand why it’s happened how can I analyst restoration issue because no error in hana studio

Regards

Shahid

[dennispadia · Accepted solution]

Hello Shashid,

NOTE: The method you have described in your question is not HANA System replication, you are trying to migrate HANA database using backup / restore.

So let me rephrase it based on my understanding, you have HANA Database On Premise and want to migrate to Azure. For that, you have installed similar version on azure and now you are trying to move each database from on-premise to azure using backup / restore. You were able to successfully restore two database i.e. SYSTEMDB and HDB (Tenant 1) but you are unable to restore ERP (Tenant 2) on azure.

Proposal: On azure side, try to delete old ERP tenant and re-create it again with the same SID and then perform backup / restore.

If you don't encounter any error in HANA Studio try to check the trace files at OS level.

Regards,

Dennis

[waqasnaved_siddiqi2 · Accepted solution]

HI Dennis,

Thank you for your guidance,

yes you are right I am stuck in manually restore system using hana backup and recovery but this my goal is to achieve system replication ,

I have tried to drop and recreate Tenant database but unfortunately no luck also I am unable to find any information why tenant database recovery not start

I also uninstalled and installed HANA software again and restored systemDB but now even I am unable to restore HDB tenant database same issue with ERP DB

I have compare all serveries in source system and target system are same .

db-status.jpg

source-system.jpg

target-services.jpg

Regards

Shahid

[dennispadia · Accepted solution]

Hello Shahid,

I think there is some sort of discrepancy in your understanding between what you want to achieve (HANA System Replication) and the thing you are actually doing (backup/restore). Because in your every comment you are talking about configuring system replication but you steps talks about backup/restore. So it's quite confusing in what's your approach of moving database from On Premise to Azure. You can switch HANA database in both ways i.e. backup/restore or HANA System Replication.

I hope you have read this guide, to understand how to configure HANA System Replication.

High Level Step of System Replication

Configuration:

You have Primary/Secondary HANA Database installed on same version > Enable System Replication On Primary > Shutdown Secondary HANA Database > Register System Replicaton on Secondary (Replication Mode: Sync, SyncMem, Asyn | Operation Mode: Log replay, delta datashipping) > All the primary and secondary HANA database services will be in Sync

Takeover

Shutdown Primary > Takeover Secondary > Now your secondary act as Primary > Change hdbuserstore of application to point it to new Primary > Application server will now connect to new Primary

Regarding Backup/Restore

As per your comment, you cannot see progress in HANA Studio when you restore tenant database. Have you tried to check trace file at OS level, it will give you some hint because with this blank screen of HANA Studio nothing can be figured out. Also, try to use HANA Studio of the same version as that of your Database version. Kindly attach tenant database backup.log file

Regards,

Dennis Padia

[former_member1291785]

Thank you Dennis for helpful guidance.

With your guidance My system replication started from yesterday 10 am ,but still it's completed 68% ( around 110 GB of data total ) I have confirmed from my network team to verify network utilization, they said avearage 6.4Mb utilization from 10am to til time our 25 Mb dedicated bandwidth from our primary server to Azure ( secondary server ) I my point of view it's too slow synchronization .

Tanks a lot again for your support

Regards Shahid

[dennispadia]

Hello Shahid,

Glad to know your issue is resolved. If possible, kindly close the thread.

Regards,

Dennis

[former_member1291785]

Hi Dennis Padia,

In most of system replication documents one step is backup of systemDB and all tenant DB for primary server and restoration of SystemDB in secondary site ( as concept of oracle data Guard configuration we take backup of primary database and store in secondary database and then configure primary and standby server data guard configuration then logfile shipped and apply in secondary site ).

Please correct me if i am wrong, as per your last reply I understand that no need to restore tenant databases in secondary site ( what about SYSTEMDB it's require to restore in secondary site ?)

Just install same version sap HANA database software install in secondary server and configure the system replication process as your last reply

Regards

Shahid

[dennispadia]

Hello Shahid,

You have to understand the terminology here, there are several methods that are available to attain High Availability for HANA database (each method has its own RTO/RPO). I hope, you are referring to this document, which describe several different method (Backups, Storage Replication, System Replication etc) to achieve High Availability.

Backup/Restore and System Replication are two different ways to achieve High Availability of HANA. You can refer to more details in this link.

Also any of the two method can be used to migrate your HANA database from on-premise to Azure. When you use HANA System replication method, high level steps described above it replicate entire HANA database (SYSTEMDB + All TENANTDBs) as whole to secondary site. You can refer this document to understand system replication and follow the steps mentioned here. System Replication does not required any restoration of HANA database.

Regards,

Dennis.