EMC Data Domain Boost for SAP HANA - Lab Guide

VLAB - EMC DATA DOMAIN

BOOST OOST FOR FOR SAP HANA

vLab - EMC Data Domain Boost for SAP HANA

Table of Contents Introduction and Overview Overview........................ .................................................. .................................................... ..................................................... ................................................ ..................... 3 Business Challenge..........................................................................................................................................4 Solution ....................................................... .......................... ............................. ......................................................... ............................ ............................. ...........................................5 ............................ ...............5

vLab Enviro Environment nment Overv Overview iew ....... ............... ................ ................ ............... ............... ................ ................ ................ ............... ............... ................ ................ ................ ............... ............ ..... 8 vLab Backup Environment Overview ...................................................... .......................... ......................................................... ............................. .............................9 ............................ .9 vLab Components ..................................................... ........................ ............................. ......................................................... ............................ ............................. ........................... 10 vLab Environment and Layout.........................................................................................................................11 vLab Login Credentials ........................................................ ............................ ......................................................... ............................. ..............................................13 ............................ ..................13 Labs...............................................................................................................................................................14

vLab Backup Environment Environment Setup And Config Configuratio uration n ........ ................ ................ ............... ............... ................ ................ ............... ............... ................ ............ .... 15 Connect using Putty SSH ..................................................... ......................... ......................................................... ............................. ..............................................16 ............................ ..................16 Starting the SAP Hana Studio ........................................................ ........................... ............................. ......................................................... ............................ ............................. ........20

vLab Backup and Recovery Demo Scenarios ....................... ................................................. ..................................................... .............................................. ................... 23 Exercise Exercise #1 : Hana Studio Studio Exploratio Exploration. n. ............... ....................... ............... ............... ............... ............... ................ ............... ............... ............... ............... ................ ...............2 .......24 4 Exercise #2 : Explore Backup Configuration Options In Hana Studio. ..................................................... ........................ ............................. ........30 Exercise #3 : Perform Backups using Hana Studio ............................. ........................................................ ............................ ................................34 ....34 Exercise #4: Perform Restore using HANA Studio. ..................................................... ......................... ......................................................... ............................. ........42 Exercise #5: Perform Backups using HDBSQL ....................................................... .......................... ............................. .........................................55 ............................ .............55

Summary and Conclusions ....................... ................................................. .................................................... ..................................................... .............................................. ................... 64 Summary ..................................................... ........................ ............................. ......................................................... ............................ ............................. .........................................65 ............................ .............65

Introduction and Overview


Page 3

Business Challenge SAP HANA is an in-memory data platform that you can deploy as an on-premise appliance, or in the cloud. SAP HANA is a ground-breaking platform that is best suited to the performance of real-time analytics, and the development and deployment of real-time applications. At the core of this real-time data platform is the SAP HANA database that is fundamentally different than any other database engine in the market today. Many IT organizations perform SAP HANA database backups on a nightly basis to meet their th eir backup and recovery window requirements. Most businesses store these backups for thirty days or more. Unfortunately, this leads to rapid growth in backup storage, which has resulted in the continued contin ued use of legacy tape systems as the default solution for database backups. This reliance on tape for backup storage can limit the number of backups that a business can perform and negatively impact recovery point objectives (RPOs). Additionally, organizations constantly challenge SAP HANA administrators to improve recovery time objectives (RTOs). The process of recovering SAP HANA databases from a previous backup, then rolling a large number of archive/redo logs forward is time consuming and complex. However, recovering the database in the shortest possible time is essential to business operations.


Page 4

Solution Provide details of the solutions, it's key benefits, any problems it solves.


Page 5

Introducing EMC Data Domain Boost for SAP EMC Data Domain deduplication storage systems continue to revolutionize disk backup, archiving, and disaster recovery with high-speed, inline deduplication. EMC first offered DBAs the ability to use RMAN integration with DD Boost to backup and recover Oracle databases. EMC has now taken the next step in DBA empowerment by integrating SAP HANA BACKINT Interface with Data Domain systems. The result of this integration is the DD Boost for Databases and Applications product. SAP HANA only supports full database backups. When you use Data Domain deduplication systems as the backup device for SAP HANA data, the deduplication process stores only unique data on the backup device and streamlines the backup process. The efficiency of a Data Domain system combined with the benefits of DD Boost, dramatically reduces the amount of data transferred to and stored on the Data Domain system. DBAs and application owners can continue to seamlessly use existing, familiar workflows offered by SAP HANA Studio and Command Line Interface (CLI) scripts. This allows the backup process to store the backup in a format that a centralized backup application can understand and use for operations such as centralized cataloging, cloning, retention, and tape-out. This unique and powerful integration gives DBAs and application owners the ability to control their own backup and recovery procedures and write the data directly to Protection Storage. The results are simplicity, improved performance, lower capital expenditure, and lower operational expenditure for the line of business owners. DD Boost for SAP HANA integrates with the S AP HANA BACKINT interface to backup and recover SAP HANA databases and redo log files. The SAP HANA BACKINT agent enables DD Boost for SAP HANA to directly connect to the HANA database. When a backup starts, the following actions occur: • The SAP HANA database server invokes invokes the backint agent. The backint agent implements implements the BACKINT BACKINT API for SAP HANA through the hdbbackint process. • The database database server server creates creates named named pipes pipes to send data data to the backint backint agent. agent. • The backint backint agent reads reads the data from from named pipes pipes and transfe transfers rs the backup backup data to the Data Domain Domain systems. SAP fully certifies the integration of DD Boost for SAP HANA with BACKINT. The following figure provides a high level overview of the components in an SAP HANA environment that uses DD Boost for SAP HANA.


Page 6


Page 7

vLab Environment Overview


Page 8

vLab Backup Environment Overview This Lab contains a small SAP Hana server and two Data Domain servers. Certain configuration tasks may be required during the course of this exercise in order to access the resources involved. The goals for this lab are to demonstrate the use of the SAP Hana tools to t o perform backups and recoveries. These tools are as follows. • SAP SAP Hana Hana Stud Studio io • Hana Hana HDBSQL HDBSQL comm command and Line Line lang languag uage. e. The ddbda suite is already installed and pre-configured. You will perform most of the tasks using the Hana Studio.


Page 9

vLab Components Here is a lists of the virtual machines included in this lab and their intended purpose. Please review the diagram in the next section.


Page 10

vLab Environment and Layout This demo environment consists of one Hana server and two Data Domain Servers. You also have a Launchpad and Domain Controller. The relevant hostnames are saphana2, ddve-01, and ddve-02. The Hana Server contains a small database called demo. The Data Domain Boost for Database applications is already installed on saphana2. /opt/ddbda/


Page 11

SAP HANA Architecture.


Page 12

vLab Login Credentials Here are your login credentials for each host.

creds.png


Page 13

Labs You will walk through through the following scenarios scenarios in this Lab. Here is a Lab Summary List: • • • • • • • •

P Pre-Step: re-Ste Step: Configure Putty ssh for the Command Line Exercises LLab ab 1 1: Working with Hana Studio Shutdo tdown and restart the Database Explore th the SA SAP Ha Hana Co Components LLab ab 2 2: Explore the Backup and Recovery Recovery Configuration Configuration inside Hana Studio LLab ab 3 3: Perform Perform Backups Backups Using Using Hana Studio Studio LLab ab 4 4:: Perform Perform Restore Restoress Using Hana Hana Studio Studio LLab ab 5 5:: Perform Backups Backups using HDBSQL Command Command Line Language


Page 14

vLab Backup Environment Setup And Configuration


Page 15

Connect using Putty SSH You will use Putty SSH to run the Command Line exercises for this Lab. You can also explore the various components of the SAP Hana server using Putty SSH.

Open the Putty Application 1. Double Double Click the Putty SSH SSH Icon on your your Desktop Desktop


Page 16

Double Click the saphana2 configuration 1. Just double click the saphana2 under saved session


Page 17

Login as Root 1. Login by typing typing root

Type your Password 1. Type Password12 Passwo Password123! rd123! 3!


Page 18

You are now logged logged in You are now logged logged in. Please Please minimize minimize this window. window.


Page 19

Starting the SAP Hana Studio We have loaded the SAP Hana Studio client on your Launchpad for this vLab. You can easily open the HANA studio by double clicking the Icon on the desktop.

Startup the Hana Studio 1. Double click the SAP Hana Studio S tudio Icon on your Desktop.


Page 20

Hana Studio will Load up. 1. It may take a minute to load up.


Page 21

Hana Studio is now Running 1. You should see a window like the one pictured below. (Please Be Patient.)


Page 22

vLab Backup and Recovery Demo Scenarios


Page 23

Exercise Exerci Exe rcise se #1 : Han Hana a Studio Studio Explor Ex Exploration. plorati ation. on. Most of this demo will be run from the Hana Studio. You already have it running at this time. This section is intended to get you familiar with the Hana Studio application.

Restarting the Hana Database You will need to restart restart the Hana Database from time to time. Here are the steps. steps. 1. Left Left Click Clic Click k to Highlight Highlight the HDB(SYSTEM HDB( HDB(S SYSTEM) YSTEM)) ICON then Right Click 2. Click Configuration and Monitoring Monitoring 3. Click Restart Restart System System


Page 24

Restarting the Hana DB Continued. 1. Choose Choose Soft 2. Click Click Ok


Page 25

Restarting the Hana DB Continued. This System is restarting you can observe all the Hana Processes involved. **Please note the system restart may take a couple of minutes. Please be patient.


Page 26

Exploring the Hana Studio 1. Maximize Maximize the HDB(SYSTEM) HDB(SYSTEM HDB(SYSTEM)) Hierarchy Hierarchy by clicking clicking the Plus Sign. Sign. 2. Left Click the HDB (SYSTEM) Icon to highlight. 2. Click on the Administration Icon


Page 27

Exploring the Hana Studio Continued 1. Click on the Overview Overview Tab 2. Click on the Landscape Landscape Tab 3. Click on the Configuration Tab Feel free to Click on the Others.


Page 28

Exploring the Hana Studio Continued 1. Click on the System Monitor Monitor Icon

System Monitor Review the Information in System Monitor Feel free to explore the rest of the Sap Hana Interface.


Page 29

Exercise Exercise #2 : Explor Explore e Backup Backup Configurati Confi Configuration guration on Options Options In Hana Hana Studio. Studio. Backups Using Hana Studio We will explore the backup configuration and options available within the Hana S tudio. **You may go ahead and restart the HANA database before you start this exercise as demonstrated in Exercise #1. If you find that this exercise runs slower than desired the HANA restart will help. 1. Left Left Cli C Click lick ck to to High Hi Highlight ghli ligh ghtt the Backup Configuration Icon then Right Righ Rightt Click in the Hana Studio 2. Choo Choose se Open Open Backup Back Backup up Console Con Conso sole le NOTE: if the Backup Console Console does does not appear. Please right-click right-click right-click and open open the Backup Backup Console Console again. again.


Page 30

Backup Overview Review 1. Review Review the Backup Backup Overview Overview Includ Including ing the the Last Successf Successful ul Backup Backup


Page 31

Backint Configuration - DD Boost for Database Applications. 1. Click on the Configuration Tab 2. Click Click on the Arrow Arrow to the left of the Backint Settings (See Arrow) 3. Review Review the the Backin Bac Backint kintt Agent Agent Locati Location Location on 4. Review Review the Backint Backint Parameter Paramet Parameter er file file Location Location 5. Review Review the Log Backup Backup Settings Settings for for Backint Backint *DDBDA was pre-installed configured for this lab


Page 32

File Based Backup Options - Log Backup Options Review the Highlighted Sections Sections to view the File Based Backup Options. Options Options

Backup Catalog 1. Click on the Backup Backup Catalog Tab Tab (View the Details) We are now ready to perform Backups via Hana Studio.


Page 33

Exercise Exerci Exe rcise se #3 : Per Perfor Perform form m Backups Backups using using Hana Hana Studio Studio Review the Previous Section Starting the SAP Hana Studio if you need to and start up the Studio.

Hana Studio Backup 1. Left Click to Highlight the Backup Backup Icon then Right Right Click . 2. Click Open Backup Backup Console. Console. (Please be Patient) Patient)


Page 34

Start Backup Wizard 1. Right Click Click the Backup Backup Icon 2. Click Backup Backup System NOTE: you may see the Warning "Not "Not valid input", please ignore it by clicking "Ok" and and do a Right Right Right Click Click Click on the Backup Backup Icon one more more time and and click Backup Backup System System


Page 35

Backint DDBDA Hana Configuration Wizard 1. Complete Backup will be the default and that is fine. You will not be able to change this in the studio 2. Choose Choose Backint Backint


Page 36

Backint DDBDA Hana Configuration Wizard Continued Observe the Backup Destination after Choosing Backint. *It calls the DDboost hdbbackint from the DD Boost for Database Applications


Page 37

Add a Date Stamp to the Backup Prefix 1. Type in a date after the Complete_Data_Backup_ Complete_Data_Backup_ *We will use the prefix during the restore.


Page 38

Continue On 1. Click Click Next Next


Page 39

Click Finish 1. Click Finish to Start

Observe the Backup The Backup will Show Percentage Complete It will then show Complete. **Please be patient as it make take a couple of minutes to complete your backup.


Page 40

Backup Complete 1. Click Close Close


Page 41

Exercise Exerci Exe rcise se #4: Per Perfor Perform form m Restore Restore using HANA HANA Studio. Studio. We will show a sample restore scenario in Hana Studio. *The Hana Database must be completely shut down to perform the restore.

Open Hana Studio and Stop the Hana Database Reference the SAP Hana Studio chapter if you need to review how to sta rt the studio 1. Right Right Click Click on HDB (SYSTEM) (SYSTE (SYSTEM) M) 2. Choose Configura Conf Configuration iguration tion and Monitoring Monitoring 3. Choo Choose se Stop Stop System Syste System m


Page 42

Soft Shutdown 1. Choose Choose Soft this is the Default Default 2. Click Click OK


Page 43

System is going Down 1. Observe the System Components going down


Page 44

System is Shutdown 1. Verify the System is completely Down Down * We are now ready to perform our Restore.


Page 45

Restore the Hana Database Using the Hana Wizard Perform the Restore 1. Right Click Click HDB (SYSTEM) (SYSTEM) 2. Click Backup Backup and Recovery Recovery 3. Click Recover Recover System System


Page 46

Wizard Reads the Backup Catalog 1. Observe the Data Collection.


Page 47

Recover Database to a Specific Backup 1. Click Recover to a Specific Backup Backup 2. Click Click Next Next


Page 48

Choose Backint 1. Choose Choose Backint Backint as the Destination Type Type


Page 49

Change the Backup Prefix 1. Just Click in the Backup Prefix Pref Prefix ix Window and Type a character ch aracter ("__" _" character for fo r example) 2. Click on your specific specific backup backup you created. (Today's (Today's Date) 3. Click Click Next Next


Page 50

Other Settings 1. Just keep the defaul d default efaultt log log and license Options Options 2. Click Click Next Next


Page 51

Start the Restore 1. Click Finish Finish, the Restore will Start


Page 52

Verify the Restore is Running 1. Observe the Restore and Recovery **Please note that the Restore and Recovery could take several minutes to complete.


Page 53

The system will Show Restored at the end of the job. 1. Observe Observe the Summary Summary 2. Click Click Close Close to exit exit

Verify All Services Are Running 1. Observe the Hana Studio and make sure all Hana Services are back up and running *Congratulations you just perform an entire Hana System Restore.


Page 54

Exercise Exerci Exe rcise se #5: Per Perfor Perform form m Backups Backups using using HDBSQL HDBSQL This Exercise is intended to get you comfortable using HDBSQL for Hana Backups. We will do this in the Hana Studio and also with the Putty SSH Client.

Open Hana Studio Review the Previous Section Starting the SAP Hana Studio if you need to and start up the Studio. 1. Click Click on the SQL Icon. Icon Icon (See Arrow)

HDB SQL in Hana Studio 1. Type Type this command into the SQL Window. BACKUP DATA USING BACKINT ('/usr/sap/HDB/SYS/global/hdb/backint/hdbb ('/usr/sap/HDB/SYS/global/hdb/backint/hdbbackint') ('/usr/sap/HDB/SYS/global/hdb/backint/hdbbackint' ackint')) 2. Click the Green Execute Execute Arrow Arrow (See Arrow) Arrow)


Page 55

Open the Backup Console to Observe the HDBSQL Run. 1. Right Right Click Backup Backup 2. Click Open Backup Backup Console Console NOTE: if the Backup Console Console does does not appear. Please right-click right-click right-click and open open the Backup Backup Console Console again. again. *You will Now be able to switch between the SQL tab and the Backup HDB (System) Tab. Just Click the SQL to execute the Backup and click Backup Console Tab to watch the backup run (See Arrows)


Page 56

Observe the Backup in the Backup Configuration Console 1. This is what you will see after clicking on the Backup HDB (System) (System) Tab (See Arrow) It shows the current backup that is running. NOTE: you may need to "Refresh" this window window if the "progress" bar will not appear automatically. Click the "Refresh "Refre Refresh" sh button in the upper right corner.

Command Line Backups outside of Hana Studio Before you can use Hana hdbsql outside of the Hana Studio, you must run a command that generates a "User Store Key" on the SAP Hana System. This key functions like a security token to allow the OS user to take backups. I will show a sample run next. This command is called hdbuserstore. 1. Open Open the Putty SSH session on the Launchpad (the SSH window should be opened opened from the previous step)


Page 57

NOTE NOTE: If you closed this window, please login to the Hana Database as user 'root root' root' and Password1 Passw Password12 Passwo ord123! rd123! 23! 3! (See Connecting Using Putty SSH for Review) 2. Run Run this comman command d to switch switch to the hdbadm hdbadm user (OS user) user):: su - hdbadm hdbadm

Change to the Home Directory 1. Run this command cd /home/hdbadm (If not already There) There)


Page 58

View the Command Line Samples 1. Run this command cat hanacommandlinebackup.txt hanacommandlinebacku hanacommandlinebackup.txt p.txt (From /home/hdbadm) *This shows us working samples of all the Hana Commands that are needed to run for command line backups. You can always come back to this location for working command line samples. From here we can copy and past the command within Putty (Highlight the command and Right Click on your Mouse)


Page 59

Change into the Hana Directory that has the Hana Client Binaries. 1. Change Directories Directories to the Hana client Software cd /hana/shared/HDB/hdbclient You will have to be in this directory to run the Hana commands.

Run hdbuserstore to create User Store Key 1. Copy and Paste the hdbuserstore sample from the hanacommandlinebackup.txt (Highlight the Line then Right Click) 2. Hit Return Return


Page 60

List the backup2 token with the Sample Command 1. Copy and and Paste the hdbuserstore list backup2 b backu ackup2 p2 Command (Highlight and left Click in Putty) 2. Verify the output ENV and USER.

Test the Token 1. Copy and Paste the hdbsql -U backup2 "select "select * from dummy" command (Highlight the Command in Putty Right Click) 2. Hit Return Return 3 Verify the Query is Run 4. Control Control + C to exit the Query

Now we can run the hdbsql command outside of the Hana Studio 1. Cat the /home/hdbadm/hanacommandlinebackup.txt /home/hdbadm/hanacommandlinebackup.txt file again. Run Run cat /home/hdbadm/ hanacommandlinebackup.txt


Page 61

2. Copy and Paste the hdbsql -U backup2 'BACKUP DATA DATA USING BACKINT" BACKINT"...... using Putty (Highlight and Right Click) 3. Hit Return Return

Observe the Backup running from the Backup Console 1. Open Hana Studio Studio and Open the Backup Console (Review Previous Steps) Steps)


Page 62

Verify Success 1. View the Last Successful Data Backup from the Backup Console *Congratulations you are now completed with all the demo scenarios.


Page 63

Summary and Conclusions


Page 64

Summary Sap Hana and DDBoost for Database Applications Here is a list of demo scenarios that we have learned during the course of these exercises. • • • •

Hana Hana Stud Studio io Spe Speci cifi fics. cs. Performing Performing Backups Backups and and Restores Restores with Hana Hana Studio. Studio. Perfor Performin ming g Backu Backups ps with with HDBS HDBSQL QL Command Command Line Utilities Utilities in Hana to allow allow the use of HDBSQL HDBSQL by the OS user. user. (hdbusersto (hdbuserstore) re)


Page 65

EMC Data Domain Boost for SAP HANA - Lab Guide

Recommend Documents