Skip to Content
0

How to Setup Replication Server ASE

Nov 30, 2017 at 05:54 PM

58

avatar image
Former Member

Hi Experts,

I want to replicated ASE DB to stand by server

Os WIndows

DB Sybase

I created the Standby instance from the Production Server Instance with same SID I need to replicate the DB to the Stand BY Instance Please any provide me a solution how to replicate the DB to Stnadby.

Regards

Sunil

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member
Dec 05, 2017 at 11:59 AM
0

Hi Sunil,

Check this KBA, it has all the offerings of HA

1650511 - SYB: High Availability Offerings with SAP Adaptive Server Enterprise

Regards

Kiran K Adharapuram

Share
10 |10000 characters needed characters left characters exceeded
Ben Slade Dec 12, 2017 at 05:46 PM
0

The "1650511 - SYB: High Availability Offerings with SAP Adaptive Server Enterprise" link didn't work for me.

The typical thing to do is setup warm standby replication in a Sybase replication server. Unfortunately, the replication server isn't a simple turn key operation. You'll probably have to take classes to get up to speed. Also, the repserver requires extra licenses (although a warm standby repserver license is included for free with the new Edge Edition of Sybase ASE, replaces Small Business Edition. See https://www.sap.com/documents/2016/06/0cb0ed17-767c-0010-82c7-eda71af511fa.html#)

A partial solution is to use ASE clustering to tolerate CPU/memory type failures. But it doesn't help with disk failures. And requires special licenses.

If data update rates are low, you could use transaction log dumps or new differential (also called incremental) dumps (dumps all changes since the last full backup. Don't have to worry about transaction logs filling up)

Share
10 |10000 characters needed characters left characters exceeded