How To Perform Backup of SYSTEM Database/TENANAT Database in SAP HANA Multitenant database containers

Multitenant database containers Overview

MDC allow you to run multiple applications on one SAP HANA system.

  1. One system database and multiple tenant databases
  2. Shared installation of the database system software
  3. Strong isolation features per default, the system database and each of the tenant databases have their own:
    – Database users, database catalog, repository, persistence,
    backups, traces and diagnosis files
  4. The system database contains information about the system
    as a whole and is used for central system administration
  5. The tenant databases contain the actual business data

The system database SYSTEMDB  plays a central role for MDC backup and recovery.

  1.  It can initiate both backups of the system database itself and of individual tenants databases. A tenant database can also carry out its own backups unless this feature has been disabled for this tenant database
    Note that the backup location in the file system is specified system-wide and tenant databases always back up
    to sub-directories of this location.
  2. Recoveries are always initiated from the system database.
  3.  The system privilege DATABASE ADMIN authorizes the administration of tenant databases from the system
    database.
    To recover a complete MDC system, first the system database and then all tenants need to be
    recovered individually.

Multitenant database containers: Backing up the system database

You regularly need to create data backups of the system database The system database contains information about
the system as a whole and all tenant databases and is used for central system administration.
Creating a data backup of the system database
1. In the Systems view in SAP HANA studio, right-click on the system database and choose Backup and Recovery  Backup Up System Database…
2. Specify your backup settings and start the backup

saphanawiki_systemdbbackup

 

Multitenant database containers: Backing up a tenant database from the system DB

You regularly need to create data backups of the tenant databases .The tenant databases contain the business data.
They have their own index servers.

Note: Depending on the system configuration, it may also be possible to initiate a data backup directly from a tenant database

tenantdbsaphanawiki

 

Recovery in Multi Container Database- Click here 

Leave a Reply