Skip to Content
avatar image
Former Member

HANA tenant backup restore on multi-node

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 07 at 10:48 AM

    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.
    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    May 04 at 06:10 AM

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

    Add comment
    10|10000 characters needed characters exceeded