SAP Basis Online Trainings
SAP HANA Database Administration
The administration console of the SAP HANA studio provides an all-in-one support environment for system monitoring, backup and recovery, and user provisioning.
In case of scenarios like data center failures due to fire, power outages, earthquake, and so on, or hardware failures, such as the failure of a node, SAP HANA supports the hot-standby concept using synchronous mirroring with a redundant data center concept, including redundant SAP HANA databases (see Figure 2).
is in addition to the cold-standby concept using a standby system within one SAP HANA landscape, where the failover is triggered automatically (see Figure 3).
 |
SAP HANA is an ACID-compliant database supporting atomicity, consistency, isolation, and durability (ACID) of transactions. In addition to recovery for online analytical processing (OLAP), SAP HANA also provides transactional recovery for online transactional processing (OLTP) through the administrative console in the SAP HANA studio.
Currently supported processes are:
•• Recovery to last data backup
•• Recovery to last and older (previous) data backup
•• Recovery to last state before crash
•• Point-in-time recovery
User provisioning is supported with authentication, role-based security, and analysis authorization using analytic privileges, which enable security for analytical objects based on a set of attribute values.
The administration console in the SAP HANA studio enables the version control mechanism for models of SAP HANA and SAP BusinessObjects Data Services.
Supported is the export and import function of XML files, which can be used to back up and restore versions of models.
SAP HANA can be run in a single production landscape, especially if the initial use-case scenario is not business critical and the data load performance for the initial load is acceptable for reloading the data.
However, we recommend aligning the SAP Landscape Transformation and SAP BusinessObjects Data Services environment with the existing source system landscapes. In an enterprise-grade business support mode, SAP HANA needs to run in standard SAP development, quality assurance and staging, and production environments.