Tuesday 9 May 2017

Restore SingleDB on 122.08 to Multi Tenant DB on HANA 2.0 SPS01

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

SAP HANA Guide, SAP HANA Materials, SAP HANA Certifications

3 HANA services were backup.

SAP HANA Guide, SAP HANA Materials, SAP HANA Certifications

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

SAP HANA Guide, SAP HANA Materials, SAP HANA Certifications
SAP HANA Guide, SAP HANA Materials, SAP HANA Certifications

Restore using the backup taken on SingleDB on SPS122.08

SAP HANA Guide, SAP HANA Materials, SAP HANA Certifications

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

SAP HANA Guide, SAP HANA Materials, SAP HANA Certifications

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.

SAP HANA Guide, SAP HANA Materials, SAP HANA Certifications

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

SAP HANA Guide, SAP HANA Materials, SAP HANA Certifications

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.

No comments:

Post a Comment