This post is more than 5 years old
2 Posts
0
1531
Sybase Database and RecoverPoint
Anyone ever set up RecoverPoint to replicate a Sybase database over a WAN connection? We spoke with EMC pre-sales support and they claim it can be done, but SAP is telling us Sybase does not support RecoverPoint and it can't be done. Anybody have any real life experience in this effort?
Daniel Earp
Cenveo Corporation
kegrabowski
1 Message
0
March 30th, 2012 05:00
Sybase makes heavy use of the shared memory segment. Much of what is going on in the database is in memory and not on disk. Products like RecoverPoint will keep the data written to disk in sync, but the database as a whole will be inconsistent when you restart it. Sybase has it's own IP based replication products that will provide DR protection. They did have an SRDF version of that product a few years ago, but it was expensive, and had very little customer demand. They withdrew the product after only a couple of years on the market.
DA
117 Posts
0
March 15th, 2012 17:00
P.S.: RecoverPoint is actually better than a power loss scenario. When you have power loss, you get one snapshot and one shot at bringing up your application. If that snapshot is unusable for any reason, you have to restore from your last backup, which could be hours before the disaster. In contrast, RecoverPoint provides you with unlimited snapshots, often microseconds apart. Even if one is not usable, you can pick another one and another one and so on, until you find a snapshot your application can use.
DA
117 Posts
0
March 15th, 2012 17:00
I have not specifically done Sybase, but it should not be different from any other application.
RecoverPoint generates crash-consistent point-in-time snapshot. If your application can recover from a power loss, it can recover from crash-consistent point-in-time snapshots. If your application cannot recover from a power loss, you have a bigger issue than RecoverPoint replication.
In addition, if your application supports application-consistent backups, you could script them in conjunction with RecoverPoint bookmarks. For example, you can put Oracle in hot backup mode, create a RecoverPoint bookmark and end hot backup mode. The bookmarked snapshot would be an equivalent of a recoverable Oracle backups, except it takes seconds to create.
I hope somebody will respond specifically with Sybase examples as well.
DanielEarp
2 Posts
0
April 2nd, 2012 07:00
We had a meeting with Sybase support a few days ago, and that is exactly what we discovered. Thanks!