Advanced Strategies Of High Availability And Disaster .

Transcription

Advanced Strategies of High Availability and DisasterRecovery for SAP HANARanjit Prithviraj, Managing Director, Fitch RatingsSanjay Mahajan, Director, Fitch RatingsSession ID # ASUG84183May 7 – 9, 2019

About the SpeakersRanjit PrithvirajSanjay Mahajan Managing Director, Fitch Ratings Responsible for global strategyand management of Enterpriseapplications for Fitch Group “Are we there yet” Director, Fitch Ratings Over 20 years of experience inSAP administration, security,databases including HANA, andvarious operating systems “Need to get a hobby otherthan Fitch and SAP”

Key Outcomes/Objectives1. There are several different implementationspossible for HA-DR depending on therequirements2. High Availability can be further enhanced byimplementing HA cluster for SAP application3. Backups are integral part of the businesscontinuity plan

Agenda Fitch OverviewAvailable options for HA and DR implementationHA-DR implementation for HANA at FitchHA-DR implementation for SAP Application usingcluster at Fitch Important OSS notes, documentation, and references

Fitch GroupFitch Group is a global leader in financial information services with operationsin over 30 countries. Fitch Group is majority-owned by Hearst Corporation.Fitch RatingsFitch Solutions One of the Big Three credit rating agencies Over 1 Billion in revenue Over 4000 employeesBMI ResearchFitch LearningDual headquarters in NewYork and London

Our SAP landscapeWe use SAP for Finance, SD, MM, T&E, Reporting, and HR. It interfaces withseveral non-SAP applicationsSuccessFactorsNon-SAPBW/BPC onHANAECC EhP8SoHSolutionManager onHANASalesforceSAPAnalyticsCloud

Agenda Fitch OverviewAvailable options for HA and DR implementationHA-DR implementation for HANA at FitchHA-DR implementation for SAP Application usingcluster at Fitch Important OSS notes, documentation, and references

Basic Business Continuity ConceptsRecovery Point Objective (RPO): Maximum tolerable period of time which operational data islost without the ability to recover. This is your business continuity plan’s maximum allowablethreshold for data loss. The RPO is expressed backwards in time (that is, into the past) from thepoint the failure occurs.Recovery Time Objective (RTO): Maximum permissible time it takes to recover the system aftera disaster (or disruption) for system operations to resume. This objective can include the timefor trying to fix the problem without recovery options, the recovery itself and testing ofservices before handing over to the business users.

Various HA-DR Solutions

Various HA-DR SolutionsWatch Dog – restart failed serviceHost Auto-failover – For HA and Scale outStorage Replication – Supported by Storage VendorsSystem Replication – HANA featureLinux Cluster – For HA and DR

HA DR Solutions

Host Auto-failover details

System Replication Details

Storage Replication Details

Active-Active

Back up Options

Back up Options

Agenda Fitch OverviewAvailable options for HA and DR implementationHA-DR implementation for HANA at FitchHA-DR implementation for SAP Application usingcluster at Fitch Important OSS notes, documentation, and references

HA-DR implementation at Fitch

HA-DR implementation at Fitch

Agenda Fitch OverviewAvailable options for HA and DR implementationHA-DR implementation for HANA at FitchHA-DR implementation for SAP Application usingcluster at Fitch Important OSS notes, documentation, and references

HA-DR Cluster at Fitch

HA-DR Cluster at Fitch

Backup set up at Fitch Create a backup admin user such as BACKUP ADMIN in SYSTEMDB Create a connection in DBACOCKPIT

Backup set up at Fitch Schedule backup in DB13 Repeat the steps for each Tenant database Verify the backups in HANA Studio

Recommendation on parametersglobal.ini/[system replication] section:enable log retention autologshipping max retention size 1048576keep old style alert falseglobal.ini/[inifile checker]enable trueinterval 3600exclusion global.ini/SYSTEM storage/*, persistence/*path*, *hostname resolution*,system replication/*exclusion nameserver.ini/SYSTEM landscape/*exclusion daemon.ini/HOST */instancesexclusion * traceprofile *

DR Exercise Simulate failure by taking network cards down ( via Linux commands)Both HANA DB and SAP clusters failover within 5 minutesHANA database and SAP application both come upUsers are back online after 5 minutes outage, and no data lossPerform DR to original primary sync ( via system replication) – Registersecondary system Failback both clusters Perform system checks Perform production to DR sync – register secondary

Agenda Fitch OverviewAvailable options for HA and DR implementationHA-DR implementation for HANA at FitchHA-DR implementation for SAP Application usingcluster at Fitch Important OSS notes and references

Important OSS notes1999880 - FAQ: SAP HANA System Replication2183363 - Configuration of SAP HANA internal network1755396 - Released DT solutions for SAP HANA with disk replication2211663 - The license changes in an SAP HANA database after the deregistration of thesecondary site from a system replication setting2369981 - Required configuration steps for authentication with HANA System Replication611361 - Hostnames of SAP ABAP Platform servers1945676 - Correct usage of hdbnsutil -sr unregister2036111 - Configuration parameters for the SAP HANA system2063657 - SAP HANA System Replication Takeover Decision Guideline2053504 - System replication: Hanging client processes after a takeover2391079 - Access restrictions in Active/Active (read enabled) system setup

Referenceshttp://help.sap.comOpen SAP course - High Availability and Disaster Recovery with the SAP HANA Platformhttps://open.sap.com/SAP Blogs https://blogs.sap.com/2017/01/18/

Take the Session Survey.We want to hear fromyou! Be sure to completethe session evaluation onthe SAPPHIRE NOW andASUG Annual Conferencemobile app.

Presentation MaterialsAccess the slides from 2019 ASUG Annual Conference here:http://info.asug.com/2019-ac-slides

Q&AFor questions after this session, contact us at ranjit.prithviraj@fitchratings.comand sanjay.mahajan@fitchratings.com.

Let’s Be Social.Stay connected. Share your SAP experiences anytime, anywhere.Join the ASUG conversation on social media: @ASUG365 #ASUG

Our SAP landscape We use SAP for Finance, SD, MM, T&E, Reporting, and HR. It interfaces with several non-SAP applications ECC EhP8 SoH BW/BPC on HANA Solution Manager on HANA Success Factors Salesforce SAP Analytics Cloud Non-SAP . Agenda Fitch Overview Available options for HA and DR implementation HA-DR implementation for HANA at Fitch HA-DR implementation for SAP