2018-12-13 07:02 AM
As "Snapshot backup of HANA 2.x MDC with multiple tenant" is not supported by SAP now, I'd like to know if
at least the "file-based backup of HANA MDC with multiple tenants" is possible with SnapCenter....
Solved! See The Solution
3 REPLIES 3
Re: SnapCenter file-based backup for SAP HANA MDC with multiple tenants
2018-12-14 06:48 AM
first, I have to correct myselfe, I shoud have asked if SnapCenter can do file-based backups of HANA 1.0 MDC Multitenant.
I figured out that there is a difference at the sqlcli backup command string formed by snapcenter, depending on what type of hana resorce is created at SnapCenter Resource configuration:
- chosing single container: the backup command looks like
backup data using file ('SnapCenter_hostname_hana_sid_hostname_date_time') asynchronous
- chosing multitenant database container: it looks like
BACKUP DATA FOR SYSTEMDB USING FILE ('SC_SnapCenter_hostname_hana_sid_tenant_hostname_date_time') ASYNCHRONOUS COMMENT 'hostname_hana_sid_tenant_hostname_date_time'
the comment statement is not supported on hana 1.0, so the file-backup failed.
the same string executed in hana sqlcli (hana 2.0 MDC single tenant) works (also with the comment statement.
I still have some tests outstanding with hana 2.0 MDC multitenant.
So, as it looks now: it seems to be possible to me hat SnapCenter based fiel-backup of hana 2.0 mdc, multitenant will work.
I'll keep you updated.
2018-12-14 07:01 AM
For a file-based backup of a HANA single container, SnapCenter is executing a single SQL backup statement.
- Backup data using file ...
For a file-based backup of a HANA MDC single tenant system SnapCenter executes the backup of the SystemDB as well as the backup of the tenant DB using two SQL commands.
- Backup data for systemdb ...
- Backup data for <tenant name> ...
For a file-based backup of an MDC multiple tenant system, SnapCenter would need to execute the backup of the SystemDB as well as a backup for each tenant. This is not implemented in SnapCenter and therefore won't work.