SAP HANA ADMINISTRATOR TASKS

SAP HANA ADMINISTRATOR TASKS OVER VIEW:

In this Blog, we will explain the SAP HANA ADMINISTRATOR TASKS details and over view. Based on Tasks/concepts, we will explain the details for further Blogs.

SAP HANA ADMINISTRATOR TASKS :

• • Introduction of SAP HANA
  • Preparing Installation
  • Introduction SAP HANA Lifecycle Management Tools
  • post Installation Steps
  • Hana Monitoring Tools:
  • SAP HANA Studio and Cockpit
  • Starting and Stopping SAP HANA
  • SAP HANA Memory Management and Data Persistence
  • SAP HANA Technical Deployment Options
  • Backup and Recovery
  • User Management
  • Other Admin Concepts:
  • RPO & RTO of Disaster Recovery Features
  • Database Migration to Hana using DMO:
  • Hana Supported OS
  • Hana Latest version and Feature
  • Hana Database OS level Commands

Introduction of SAP HANA

• What is SAP HANA
• What is In Memory Database
• SAP HANA Database Architecture
• Single Host / Multi Node cluster configuration
• SAP HANA Persistence Layer

Preparing Installation

• Sizing of SAP HANA
• T-Shirt Size > Main Memory Sizing
• SAP HANA sizing using the QuickSizer tool
• Conclusion Installation
• SAP HANA Database Media download

Introduction SAP HANA Lifecycle Management Tools

• Platform lifecycle Management
• Application lifecycle Management
• SAP HANA Database Installation
• SAP HANA Installation using hdblcm
• SAP HANA Installation using hdblcmgui
• SAP HANA Installation using hdblcm web
• SAP HANA Studio installation Post Installation

post Installation Steps

• SAP HANA license management
• SAP HANA Support Package strategy
• Updating SAP HANA
• SAP HANA Support Package (Revision)upgrade Admin tools for SAP HANA

Hana Monitoring Tools:

• Hana studio
• Hana cockpit

SAP HANA Studio and Cockpit

• SAP HANA Cockpit
• SAP DBA Cockpit
• Monitoring with SAP HANA Studio
• Monitoring and Troubleshooting SAP HANA Operation

Starting and Stopping SAP HANA

• Tools for Starting and Stopping the SAP HANA Database
• Stopping & Starting HANA DB with SAP HANA Studio
• SAP HANA Database stop options
• Starting and Stopping the SAP HANA Database Using OS Commands
• Stopping and Starting Individual Database Services
• Start of SAP HANA Database — Start—
• Restarting SAP HANA Database
• Configuring SAP HANA Database
• SAP HANA Database ..ini files
• Periodic Manual Tasks

SAP HANA Memory Management and Data Persistence

• SAP HANA Core Processes
• SAP HANA Database Startup Sequence
• SAP HANA Database Server Process Port list

SAP HANA Technical Deployment Options

• Single Component on One System (SCOS)
• Multiple Components on one System (MCOS)
• Multiple Components on one Database (MCOD)
• SAP HANA Multitenant Database Containers (MDC)

Backup and Recovery

• In Memory data and persistent Storage
• Types of Backup
• Backup configuration
• Options for backups
• Overviews of Configuration options
• Log Mode (Overwrite and Normal mode)
• Log Backup Parameters
• Backup Catalog
• SAP HANA Database Backup using HANA Studio
• SAP HANA Database Recovery
• Recovery types
• Recovery Steps
• Recovery Phases
• SAP HANA Database Recovery using HANA Studio Maintaining Users and Authorizations

User Management

• Types of Privileges
• Standard Roles

Other Admin Concepts:

• Managing Password Policy SAP HANA Multitenant Database Containers (MDC)
• What is Multitenant Database Containers
• Administration of Multitenant Database Containers
• Starting / Stopping tenant database
• Creating tenant database >
• Dropping Tenant database HANA Scalability Concepts
• Scale Up (Vertically Scaling)
• Scale Out (Horizontal Scaling) High availability and Disaster Recovery
• Continuous Availability High Availability
• High Availability for Scale up and Scale out
• SAP HANA System Replication
• SAP HANA Host Auto Failover
• High Availability – Overview > HA / DR – KPI

RPO & RTO of Disaster Recovery Features

• SAP HANA System Replication
• SAP HANA System Replication -Overview
• Replication Modes
• Operation Modes
• Data transferred to the secondary
• Operation mode – delta_datashipping
• Operation mode – logreplay
• Prerequisites
• Setup and Configuration Overview >
• Configuration HANA System Replication overview
• Disable HANA System Replication overview
• Hana DB Single Node HA — DR
• SAP HANA Host Auto Failover
• What is SAP HANA Host Auto Failover SAP HANA Cockpit 2.0
• Understand the SAP HANA cockpit 2.0 architecture
• Configure SAP HANA cockpit 2.0
• Adding Remote HANA database to SAP HANA Cockpit
• Creating resource group and user in SAP HANA Cockpit SAP HANA Migration with DMO

Database Migration to Hana using DMO:

• What is DMO
• What is classical Migration
• DMO Benefits
• Preparing for DMO
• Configuration of DMO

Other Admin Concepts:

• Hana database installation
• Hana 1.0 vs Hana2.0
• Hana1.0 database to Hana2.0 Database upgrade
• Hana database SPS update
• Hana database Revision Update
• Hana Performance check
• Hana database consistency check
• Hana database issue
• Hana Log volume full situation

Hana Supported OS :

• How to check Hana supported OS version
• CPU & RAM
• VM Size
• Cloud portal—Azure/AWS/Google

Hana Latest version and Feature:

• Hana2.0 SP7 Version Details
• Feature of SAP HANA Database
• SAP HANA Fast restart option
• Hana File system configuration

Hana Database OS level Commands:

• Start and stop hana database though OS level
• Check Hana database services in OS level
• Check Tenant and system db status in OS level
• Check hdbuserstore details
• How to update schema password in OS level
• How to reset the sap application user password in DB level through SQL command
• Hana database ODBC
• Hana database HA file over and Fail back process.

Conclusion:
In this Blog, we have explained the SAP HANA ADMINISTRATOR TASKS details and over view. Based on Tasks/concepts, we will explain the details for further Blogs for SAP HANA ADMINISTRATOR TASKS

We will publish next blogs for SAP HANA ADMINISTRATOR TASKS

Other Blogs:
Hana Database:

1. Hana database upgrade From Hana1.0 to Hana2.0
2. Hana database installation
3. Hana cockpit installation
4. Hana database Fast restart option
5. Hana log Full situation resolution steps
6. Hana database Backup Configuration
7. Hana database issue troubleshooting Part 1