This is my third blog to introduce new capabilities in our most recent release of SAP Sybase Replication Server, 15.7.1 SP100.  I am going to talk about achieving near-zero downtime for SAP Business Suite on ASE using SAP Sybase Replication Server (SRS).  In addition to real time replication into HANA and real time change data capture support for SAP Data Services, SAP Sybase Replication Server is also certified for SAP Business Suite on SAP ASE to provide a near-zero downtime disaster recovery solution.  In this integrated disaster recovery solution, SAP Sybase Replication Server Enterprise Edition comes with SAP Sybase ASE runtime license for SAP Business Suite.

Legacy techniques such as log shipping and disk-based replication have been used in the past for database disaster recovery.  Log-shipping – the process of copying database log files from a primary server and then restoring them on a remote server – is a cumbersome, error prone, resource intensive task in terms of manpower and infrastructure.  And disk-based replication has distance limitation and can propagate corruption from your primary site—rendering your secondary site unusable in an emergency.  Both of these techniques can’t produce a warm-standby database, which is necessary to reduce system downtime in a disaster recovery configuration.

SAP Sybase Replication Server overcomes these limitations to deliver a warm-standby database that is synchronized with primary database, in near real-time. This market-leading transactional database replication tool can reduce downtime for both unplanned events such as hardware failures, power outages, natural disasters or human errors and planned activities such as software upgrade and database migration 

In this release, to support near zero downtime for SAP Business Suite on ASE,  SRS has implemented Disaster Recovery (DR) Agent, a new component, which is a SAP Control Center (SCC) plug-in that runs inside the SCC server framework.   The DR Agent supports automated setup and configuration, monitoring, and administration for an SAP Business suite for ASE DR.  Traditionally, setting up and configuring for disaster recovery environment requires multiple setups that must be performed in the correct order across multiple servers.  If any of steps failed, you may have to tear down and restart process again.  The DR Agent consolidates many complex steps into few abstracted actions that reduce manual effort or set of commands required to establish a basic replication setup for disaster recovery. 

The DR Agent is already integrated with SAP tooling to provide an integrated solution.  SAP tooling, utilizing the DR Agent, sets up a disaster recovery environment which includes a primary and a standby site.   There is distance constraint between two sites.  The setup is a default topology in this release.  More topologies, such as multiple standby sites, are planned for future releases.  Both sites have identical components and configurations.  Each site includes an instance of ASE, SRS and DR Agent.  Both ASE instances in each site support the same single SAP Business Suite installation.  Database materialization, a process of initial copy of data from one site to the other, will be performed as well as part of setup.

SRS is set up to support replication in both directions between the primary and standby sites, with one direction active at any time.  At steady state, active replication is from primary to standby site.  Two-replication-server setup is used for draining the transaction log quickly from primary site and for ease of failback.  Three databases are replicated between the primary and standby sites: the SAP ERP database, the saptools database and ASE master database.  

A disaster recovery environment will be set up by SAP Installer as shown in figure 1.  Primary server will process all transactions by SAP applications.  Standby server is a warm standby for primary server. Only privileged users can access the standby ASE.

DR1.png

Figure 1 Disaster Recovery Environment Architecture

Failover is a process to switch from the primary to the standby when there is a planned or unplanned event.  A planned event could be system upgrade, database migration, which happens on a schedule.  An unplanned failure is unscheduled due to disaster, power outage, and human errors without any warning.  Similar sequence of events takes place for both planned and unplanned failover.  DR Agent, which interfaces with SAP tooling, stops replication from primary, enables replication on standby site.  Once the original primary site comes back, database replication will be started from new source site as shown in figure 2.  To failback to the original primary server, same process as failover will be performed to return to original processing state.

DR2.png

Figure 2 Disaster Recovery Failover

With DR Agent, disaster recovery environment can be monitored dynamically by checking the health and latency of the replication paths in the disaster recovery system.  Tracing latency is implemented by leveraging existing rs_ticket command.  Resource usage monitoring includes SRS device usage and queue backlog, as well as ASE transaction log size and backlog.  Backlog identifies data yet to be process by either ASE or SRS.  Based on monitoring status, in case of high volume, or system outages, one may need to increase the space used by replication.

SRS provides unique value to SAP Business Suite on ASE, by providing near-zero downtime for planned and unplanned events in high performance transactional replication environments.  SRS is fully integrated into SAP Business Suite to seamless support disaster recovery environment.  It provides a greater return on your existing investment on SAP technology.  With your SAP Sybase ASE runtime license for SAP Business Suite ASE, SRS is available for DR usage without additional cost.

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Juan H. Stagg

    Dear Bill:

                    very interesting piece. We have SRS enterprise an have used it for many years. I allways asked my Sybase contacs when was it going to be available to use on my SAP ERP over Sybase instalation. For what I understand, I should asquire a second Rep Server, Install the DR agents and should be covered for Near Zero Downtime Replication between two ERP ECC 6.0 EHP 6 installations??

    (0) 
    1. Bill Zhang Post author

      Hi Juan,

      With ASE runtime license you acquired with your Business Suite, you are entitled to use SRS for DR use case described in this blog.  You should be able to download it from your account on SMP.  If you have any problem locating the binary download, please feel free to email me at bill.zhang01@sap.com.

      Regards,

      Bill Zhang

      (0) 
  2. Juan H. Stagg

    This is very important information for operations like ours who use Rep Server as a mainstay of daily data synchronization, between the diferent legacy applications. The information is presented n a very orderly way and goes a long way into providing information needed for initial licensing sorting, specially with the changes illustrated.

    DR is a very important consideration in any landscape. Having this capability is worth exploring deeper.

    For us it has provided valuable data for our discussions with our SAP Partners in different pathways to take on our next upgrade. .

    (0) 
    1. Bill Zhang Post author

      Hi Juan,

      With SRS’s support for Business Suite on ASE, we are going to introduce more innovative features.  Please stay tuned.  If you are interested in learning more, please feel free to contact me bill.zhang01@sap.com

      Regards,

      Bill Zhang

      (0) 
      1. Juan H. Stagg

        Bill:

               thank you for your replies. We are exploring with our local SAP partners the options. I will certainly take you up on your offer for advice.

        (0) 

Leave a Reply