HANA tenant backup restore on multi-node

[Former Member]

Please consider our below scenario as we need to restore backup of source (DC1) to target (DC2)-

DC1 is single host HANA system which has 1 system DB and 3 tenant DBs (DB1, DB2 and DB3)

DC2 is a scale-out HANA system where:

Host1 has system DB and 1 tenant DB- VB1

Host 2 has 1 tenant DB- VB2

Host 3 has 1 tenant DB- VB3

We need to copy/restore DC1 (source) to DC2 (target), so in this case is it possible to restore single-host tenant DBs to tenant DBs distributed accross multi host?

like restore system DB from DC1 to DC2 and then restore tenant DB1 to VB1, DB2 to VB2 and DB3 to VB3 ?

Thanks

[Former Member]

I hope that this note

2130603 - How to restore a backup from Single node (scale-up) to Multi node (scale-out) system (n-m)

It help you.

[Former Member]

Thanks Alvaro for your response.

As per my understanding, this note (as well as my knowledge from HA 200, admin guide) suggests that single-node to multi-node restore is not possible in as-is case (without converting it to single-node).

However I am not able to find any documentation / SAP Notes which mention the same scenario for MDC tenant databases.

We had also raised an OSS message, and SAP agreed that there is no present documentation to support this fact however this "may" work.

Thanks

Puneet

[Former Member]

I forgot to mention the release, it is HANA 1.0 SP 12