In the Part1 of my doucment i have explain how to config my DNS, install Hana by using a script, install Netweaver 7.5 and configure Hana HSR by command line.

My Hana HSR competed i check the replication status, this can be done by:

SAP Hana Studio under replication

/wp-content/uploads/2016/06/49_974913.jpg

From the Hana Cockpit

/wp-content/uploads/2016/06/50_974914.jpg

By command line as SIDADM with the command “hdbnsutil –sr_state

/wp-content/uploads/2016/06/51_974915.jpg

And by using Python tool from the “python_support” directory

/wp-content/uploads/2016/06/52_974916.jpg

I’m all set for the Hana replication I can now configure my FreeNas for storage replication for the ABAP server portion.

Configure FreeNas 10 Storage replication

FreeNas is a nice opensource free storage appliance which can by virtual or physical, up to you.

It allows you to use the same functionality or feature (very close) like a professional NAS and certainly the same as Home NAS.

Using storage replication is a common feature/service deserve by any professional NAS/SAN appliance such as:

EMC

NetAPP

… and more

Earlier in my configuration I have assign disk and create dataset to my respective vm which host SAP application, this task is mandatory to allow storage replication.

/wp-content/uploads/2016/06/11_974917.jpg

The first step is to create a “periodic snapshot task” is order to schedule the frequency of the data shipping

/wp-content/uploads/2016/06/54_974918.jpg

/wp-content/uploads/2016/06/55_974919.jpg

Once frequency is define, I can configure the “replication task”

/wp-content/uploads/2016/06/56_974920.jpg

When active I can see now my storage from site1 replicated under site2

/wp-content/uploads/2016/06/57_974924.jpg

/wp-content/uploads/2016/06/57_1_974925.jpg

I need now to mount on my secondary site the filesystem /usr/sap and /sapmnt from the snapped volume

/wp-content/uploads/2016/06/58_974926.jpg

I can see now that I have the same content on both storage

/wp-content/uploads/2016/06/59_974933.jpg

Note: Do not forget to request the license for BOTH site, run saplicense –get on both site for the HW key and load the license

/wp-content/uploads/2016/06/59_1_974934.jpg /wp-content/uploads/2016/06/59_2_974935.jpg

/wp-content/uploads/2016/06/59_3_974936.jpg

Perform failed over to Site2

My Hana replication is working and my storage replication either for SAP application, I need to test now my solution to make sure I have no issue, I my case it is a controlled failed over process.

On the primary site, I begging to shutdown my SAP application

/wp-content/uploads/2016/06/60_974937.jpg

Then I suspend/stop the replication and periodic snapshot task on FreeNas

/wp-content/uploads/2016/06/61_974938.jpg

/wp-content/uploads/2016/06/62_974939.jpg

On my secondary site, I perform a takeover on Hana by using: hdbnsutil –sr_takeover

/wp-content/uploads/2016/06/63_974940.jpg

And shut it down the primary site

/wp-content/uploads/2016/06/64_974941.jpg

The failed over process completed I need to update my DNS in order to point the alias (vmapp/vmhana) to the correct site

/wp-content/uploads/2016/06/65_974942.jpg /wp-content/uploads/2016/06/66_974943.jpg

Before to start the application make sure to check the hdbuserstore on the secondary site and also copy the /etc/services file in the secondary too

My secondary site is now fully operational from Hana side, I can start my SAP application

/wp-content/uploads/2016/06/67_974944.jpg

My application is now up and running I will connect to it I check the system information retrieve from the system info, I’m connected to the secondary database as expected.

/wp-content/uploads/2016/06/68_974945.jpg

I can see that I’m running on the secondary site without changing anything from my saplogon information and hana studio

My connection successful, I can perform a failed back operation.

Perform Hana upgrade to SP11

My upgrade process consist of updating my Hana instance from SP10 to SP11 in a limited time frame windows, my scenario will reflect a situation where I can’t afford to have more than (time) of outage.

In order to realize this operation I will proceed as follow:

Step 1

  • Stop the replication and snapshot task of FreeNas (site1)
  • Configure the system user password in the local userstore under the key SRTAKEOVER (site2)

/wp-content/uploads/2016/06/3_974946.jpg

/wp-content/uploads/2016/06/61_974938.jpg

/wp-content/uploads/2016/06/62_974939.jpg

/wp-content/uploads/2016/06/69_974949.jpg

Step 2

  • Upgrade Hana to SP11 (site2)
  • Upgrade Hana client on application server (site2)

/wp-content/uploads/2016/06/4_974950.jpg

/wp-content/uploads/2016/06/70_974951.jpg

/wp-content/uploads/2016/06/70_1_974952.jpg

/wp-content/uploads/2016/06/71_974953.jpg

/wp-content/uploads/2016/06/72_974954.jpg

Step 3

  • Re-sych the secondary Hana database site with the primary site (site2)

/wp-content/uploads/2016/06/5_974955.jpg

During the update process

/wp-content/uploads/2016/06/73_974956.jpg

Once the update is done Hana will restart and re-sych

/wp-content/uploads/2016/06/74_974957.jpg

Step 4

  • Shutdown application (site1)
  • Perform takeover (site2)
  • Switch DNS pointer
  • Start application (site2)
  • Start the replication and snapshot task of FreeNas (site2)

/wp-content/uploads/2016/06/6_974958.jpg

Refer to the section “Perform failed over to Site2” except for the file system replication, since now I replicate from Site2 to Site1. By doing so the client on Site1 will be automatically updated to SP11.

/wp-content/uploads/2016/06/75_974959.jpg

/wp-content/uploads/2016/06/76_974960.jpg

/wp-content/uploads/2016/06/77_974961.jpg

Step 5

Upgrade Hana to SP11 (site1)

Register Hana as secondary site (site1)

/wp-content/uploads/2016/06/7_974963.jpg

By running the option “–hdbupd_server_nostart” when the primary will be updated it won’t restart, so I will be able to register it a secondary site and start it only once

/wp-content/uploads/2016/06/78_974964.jpg

/wp-content/uploads/2016/06/79_974965.jpg

/wp-content/uploads/2016/06/80_974966.jpg

Note: something you probably notice, but I still add it, when you are running on Hana SP10 and do register a site for replication vs SP11, the syntax change when you choose the mode of replication

  • SP10 = hdbnsutil -sr_register –remoteHost=<host> –remoteInstance=## –mode=< sync|syncmem|async> –name=<site name>
  • SP11 = hdbnsutil -sr_register –remoteHost=<host> –remoteInstance=## –ReplicationMode=<sync|syncmem|async> –operationMode=delta_datashipping|logreplay –name=<site name>

Once done I check from the former secondary site the replication process

/wp-content/uploads/2016/06/81_974967.jpg

My configuration is now completed for my DR scenario.

Williams

To report this post you need to login first.

1 Comment

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

Leave a Reply