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

Hi @Fredrik Andreasson 

Are you using backint based streaming backup or IntelliSnap?

Thanks,

Sunil-

Hello Sunil,

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

best regards Fredrik 

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 

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-

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 

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

@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 🤓

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-

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

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

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

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

Thanks,

Sunil-

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

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-

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

Hi Fredrik,

Yes, you can check it in the Commvault GUI.

Thanks,

Sunil-

Hello again Sunil,

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

Best regards Fredrik

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-