Conversion of HANA DB from single container to combination of system DB and tenant DB.

 The system can be installed on one or multiple system hosts, which are configured to operate as worker or standby hosts. As of SAP HANA 2.0 Support Package Stack (SPS) 01, the SAP HANA system can only be installed or configured to be a tenant database system. A tenant database system contains one system database and can contain multiple tenant databases. A single-container system will be automatically converted to a tenant database system during the upgrade to SPS 01.

Backup

Default location of HANA DB backup.

HANA DB backup using HANA studio

what is contained in the backup file?

The data backup includes not only data, but also data structure that are required for restore of DB.

why to take backup on regular basis?

To save data during disk failures

Pre-requsites:

DB user with roles: Backup Admin
                                Backup Operator

                                Catalog read

Note: same roles are enough for performing the recovery of HDB also.

SQL query for check the backup size:

select sum (allocated_page_size) from M_converter_Stastistics

select volume id, sum (allocated_page_size) from M_Converter_Stasticstics) group by volume id,

based on the out put of the above query --> make space arrangements.

Process:

Method1

• Open HANA studio.
• select the correct system for backup amomgs all systems.
• Right click
• choose backup
• choose type as full / differential /incremental 
• specify the location and prefix for the backup file.
• conform 

Method 2

• Open HANA studio.
• login to system
• open hdbsql
• execute the query:

BACKU DATA USING FILE ('/usr/sap/<SID>/HDBXX/backup/data')