Skip to Content

In this document I’ll cover briefly the HANA replication set up.

I currently have a test node running HANA 1.00.93.

An ECC test system is using it.

The replication relies, among other things, on using hdb logs.So of course, the primary system needs to be in “archive log” mode ( <- log_mode normal / enable_auto_log_backup yes …  sorry … remains of my Oracle past… ) , and prior to the replication setup you need a full DB backup.

The replication set up in itslef is easy and straightforward provided you have respected the pre- requisites :

  • Primary and standby HDB are installed and online,
  • Software versions are the same. Or the standby runs an higher software version than the primary ( which is an interesting point when it comes to updating with minimal downtime )
  • SIDs of primary and standby are the same.
  • The network ports beetween the primary and standby sites are available and useable ( have a look at your Fwall settings if required ).

Then I went into the configuration steps :

On the primary node :

/wp-content/uploads/2015/08/replication1_779753.png

I had this popup because I tagged my test system as a production one.

/wp-content/uploads/2015/08/replication2_779754.png

You define your logical system names :

/wp-content/uploads/2015/08/replication3_779755.png

/wp-content/uploads/2015/08/replication4_779771.png

This first part of the configuration is O.K.

/wp-content/uploads/2015/08/replication5_779772.png

Et Voilà !  The first part of the configuration is done.

Second step on the stby system :

You now have to configure the replication on the stby system.

Using the HDB GUI :

/wp-content/uploads/2015/08/replication6_779773.png

You need to register this system as “secondary system” :

/wp-content/uploads/2015/08/replication7_779780.png

I gave here the stdby logical name and the desired sync mode. Depending on the SLAs needs, you’ll set the replication mode accordingly.

/wp-content/uploads/2015/08/replication9_779802.png

Validate this last popup and then the replication set up starts :

/wp-content/uploads/2015/08/replication10_779803.png

It can be followed here :

/wp-content/uploads/2015/08/replication11_779804.png

/wp-content/uploads/2015/08/replication12_779805.png

Once everything went fine, you can see these statuses :

/wp-content/uploads/2015/08/replication13_779806.png

Nice and easy !

Next step : takeover and failback !

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply