Skip to Content

Hi All,

Just tested recover a single Database to Multi Tenant Database without the need to convert them to MDC beforehand with below scenario and thought it is a good idea to share.

This enhancement only work on target >= HANA 2.0 SPS01 and is particularly useful where it keeps your source/ productive database intact and allows you to to perform a series of testing before converting them to MDC, especially if you plan to upgrade to HANA 2.0 SPS01 since MDC would be the standard and only operation mode.

Source

HANA revision: 122.08 (HANA Platform Ed 1.0)

SID: NC2

Mode: SingleDB

 

Target

HANA Revision: 2.00.010 (HANA 2.0 SPS01)

SID: NC1

Mode: MultiDB (MDC)

 

Scenario:

Restore the backup taken from NC2 (singleDB) to tenant NC2_MULTIDB@NC1

i. Backup source singleDB NC2 on HANA platform Ed 1 – SPS122.08

3 HANA services were backup.

ii. Once backup completed, in HANA 2.0 SPS01, you can either restore the backup taken directly to the available tenant or to a newly created tenant.

In below, the singleDB will restore to tenant NC2_MULTIDB on NC1 on HANA 2.0 SPS01

Restore using the backup taken on SingleDB on SPS122.08

If you noticed, only 2 services – indexserver and xsengine were restored. 

iii. Once recovery completed, you’ll need to re-enter the NC2 SYSTEM user password into tenant NC2_MULTIDB@NC1 in HANA Studio as source password was overwritten from restore.

And now your singleDB is restored to a tenant in MDC without the need to convert them to MDC beforehand.

 

I’ve tested and it works perfectly on source revision 122.07 and 122.08 and assume it should work on SPS12. For revision <=SPS11, further testing will be needed.

 

Hope it helps,

 

Cheers,

Nicholas Chang

 

To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

  1. Sandipkumar Teli

    Thanks Nicholas,

    I helped me resolving upgrading and migrating database from Hana 1.0 revision 122.06 to Hana 2.0 SP02 just in one step procedure.

     

     

     

    (0) 
  2. Tabrayz Abdul

    Yes I tested with HANA 1.0 SP12 (1.00.122.04.1478575636) to HANA 2.0 SP02 (2.00.022.00.1511184640)  and it works fine

    Restored single db backup to MDC Hana 2.0 works fine. However I did not find any note about this approach.

    Thanks

    Tabrayz

     

     

    (0) 
  3. Akhila P

    Hello,

     

    Is there any official SAP note to recover a multi tenant from a single tenant DB?

    I remember seeing notes which says backup and recovery is not possible from single to multitenant.

     

    Thanks

    Akhila

    (0) 
  4. Siming Fu

    Great Blog, thanks!

    According to the Blog and Comments.

    The min. requirement for this SDC restore to MDC tenantDB is:

    Source revision: >=1.00.122.04

    Target revision:   >=2.00.010.00

    If someone tested further, please update here.

     

    Thanks,

    (0) 
    1. Nicholas Chang Post author

      Hi,

      We had performed this  without any problems.

      Source revision: >=1.00.122.05

      Target revision: >=2.00.020.23

       

      Cheers,

      Nicholas Chang

      (0) 
  5. Ravikiran Chikati

    Hi Nicholas Chang

    We have installed HANA 2.0 SP03 on scale out . And we are planing to do  restore HANA 1.0 SPS1 system to HANA 2.0 SP03.

     

    Source system is having 4 nodes ( 4 index servers+1 xs engine+1 name server)

    Target System is with 3 nodes. (3 Index Severs+1 xs engine )

    So I need to build 1 additional index server and 1 name server.

    As per the note 2093572 we need to match the services before we start with the restore process.

    As we already had a nameserver on System DB, do we need to create additional nameserver on tenant DB?

    Thanks

    Ravi

    (0) 
  6. Ravikiran Chikati

    Hi Nicholas Chang

     

    Thanks for the reply, Yes I have seen system guide and we will have one SYSTEMDB DB for scale out.

    My question is as per the note 2093572 we need to match the number of services before we start with the restore process. So my source system is having 4 nodes ( 4 index servers+1 xs engine+1 name server).

    In order to match same number of reservices as source do I need to create additional name server on tenanat DB or as we have already have name server on systemdb,so we no need to do it ?

     

    Thanks

    Ravi

    (0) 
  7. Nicholas Chang Post author

    I believe it would be fine as long as there’s 4 indexservers and 1 xsengine on your tenantDB. Nameserver will run on SYSTEMDB, you don;t need nameserver to tenanddb.

    (0) 

Leave a Reply