Solved

Error when doing cross platform restore of SAP HANA database, restoring to secondary node


Badge +2

Hello,

We are running an HANA database in a cluster setup, with a primary and secondery Linux machine.

I have an problem when doing cross platform restore of an HANA database.
We are trying to restore an production enviroment HANA database and restore it from the production Linux machine (host) to a stage/development host / machine.

The restore is starting, but it is restoring the database into the secondary machine (host) in the cluster instead of the primary machine.

I can describe further and attach screenshot to explain better.

Best regards
Fredrik Andreasson
Axians Linux team

icon

Best answer by Mike Struening RETIRED 15 July 2022, 21:13

View original

19 replies

Userlevel 5
Badge +12

Hi @Fredrik Andreasson 

Are you using backint based streaming backup or IntelliSnap?

 

Thanks,

Sunil-

 

Badge +2

Hello Sunil,

 

When doing backup manually throuh comcell gui I think it is backint based.

 

best regards Fredrik 

Badge +2

The problem seems to be that when doing a restore.

It starts restore from the backup.

But it is restoring, to the inactive node in the cluster.

 

best regards Fredrik 

 

Userlevel 5
Badge +12

If it is backint based backup, can you ensure you are using distributed HDB store key?

 

Instructions to create the store key can be found here.

https://documentation.commvault.com/11.24/essential/87400_create_hdbuserstore_key_for_sap_hana.html

 

Are you using username/password in the Commvault GUI instance properties, or HDB store key? If you are using the username/password software creates a distributed store key in the background.

But if you are using your HDB store key, please ensure it’s created properly with all HANA nodes included in the node list.

 

Thanks,

Sunil-

Badge +2

Hello again Sunil,

 

Yes we are using an hdb store key.

And the backups are working also.

This is issue just when doing an restore operation.

 

Best regards Fredrik - Axians Linux team 

Badge +2

Hello again Sunil, 

I now see that this is maybee not registered as an support incident?
Can you create an support incident from this?

Because it is an important error for our customer that we need to have resolved.
We would also like to raise the priority of this ticket.

Is it possible to register an support ticket from this discussion we have had here?
Best regards Fredrik Andreasson - Axians Linux team

Userlevel 7
Badge +23

@Fredrik Andreasson , if you call support, share this thread link with them (or just open a case in Maintenance Advantage and paste the url).  Everyone in support has access to these forums and can read the history and recommendations.

When you do, please share the case number here 🤓

Userlevel 5
Badge +12

Hello again Sunil,

 

Yes we are using an hdb store key.

And the backups are working also.

This is issue just when doing an restore operation.

 

Best regards Fredrik - Axians Linux team 

Hi Fredrick,

Could you also confirm you’ve created the key in distributed fashion? If the key is distributed, regardless of ClSapAgent process starting on the secondary node, the data gets restored to the primary node only.

 

If you still notice the data getting restored to secondary, please go ahead and raise the support ticket.

 

Thanks,

Sunil-

 

Badge +2

Hello again Sunil,

Thank you for your reply. I am a bit unsure.
Is it possible to verify somehow if the key is distributed?

Best regards Fredrik

Userlevel 5
Badge +12

Hi @Fredrik Andreasson 

You can check it on the HANA server. This is also given in the documentation link I shared.

 

 

su – <sid>adm

#here <sid> to be replaced with your instance SID.

Verifying the Key Information for SAP HANA with Four Nodes

This command verifies the key information for HANA SID with four nodes machine01, machine02, machine03, and machine04.

hdbuserstore list MYKEY

KEY MYKEY ENV : machine01:39913,machine01:39915,machine02:39913,machine02:39915,machine03:39913,machine03:39915,machine04:39913,machine04:39915 USER: SYSTEM
Badge +2

Hello again Sunil,
Thank you for all the help.
I have also registered an support ticket: Incident 220603-224

I asked the hana dba to run command: you wrote above.
He has run the command: 
“hdbuserstore list”

Can I paste the output from this command into the support ticket?
To get help verify if the key is distributed?
I can see in the output from this command that both the primary and the secondary hana machine are included.

Thank you in advance
best regards fredrik

Userlevel 5
Badge +12

Yes Please. Add that output also in the support ticket.

 

Thanks,

Sunil-

 

Badge +2

Hello again Sunil,
I just wanted to inform that I have pasted the output from command:
“hdbuserstore list” that the hana database administrator run for me.

Are you able to see this output in the case?
I was just curious if it contains information regarding if the key is distributed.

Best regards Fredrik

Userlevel 5
Badge +12

Hi Fredrick,

The output has multiple keys listed.

What is the name of the store key you are using in Commvault HANA instance properties?

 

Thanks,

Sunil-

Badge +2

Hi Sunil,

Sorry for this.
I will check, I suppose I can check this in the comvault GUI?

Thank you for the help

best regards fredrik

Userlevel 5
Badge +12

Hi Fredrik,

Yes, you can check it in the Commvault GUI.

 

Thanks,

Sunil-

Badge +2

Hello again Sunil,

I could see in the Commvault GUI that “BACKUPM” is the name of the key in use.

Best regards Fredrik

Userlevel 5
Badge +12

Hi Fredrik,

I checked the BACKUPM key detail. It looks to be configured correctly. I’d let Darwin take a look at it as he is working with you on the ticket. If needed we will engage.

 

Thanks,

Sunil-

 

Userlevel 7
Badge +23

Sharing case solution:

Solution:

Requirement : HANA out of place restore Source and Destination both are in replication . When doing the restore the DATA on the destination should be restore to second node (Replication Node)

Work done
-------------
-- On Commcell Destination pseudo client should maintain one node where the DATA needs to restored
-- While configure the destination with single node
1. SSL authentication was failing due to Hostname mismatch in current certificate
2. DB user account used to create HDB user store key was missing authorization
-- After fixing the certificate issue , Customer run out of restore window



Next steps
-----------
Customer will work on getting a new restore window
-- Perform restore with destination having single node

Reply