Dell RecoverPoint replication provides the continuous data protection to recover any application, on any supported storage array, in any location, to any point in time. Users can meet recovery point objectives (RPOs) and recovery time objectives (RTOs) with instant access to data, and use RecoverPoint to support disaster recovery, operational recovery, and testing.
N/A
Oracle GoldenGate
Score 8.7 out of 10
N/A
Oracle Cloud Infrastructure (OCI) GoldenGate is a managed service providing a real-time data mesh platform, which uses replication to keep data highly available, and enabling real-time analysis.
If you are a small business and you need a solution that is relatively easy to use and configure, then Dell EMC RecoverPoint is ok. The downside was that I found the cost to be high and was unable to negotiate a good licensing deal. Within a year I had to find a difference software vendor to meet my needs.
Oracle [GoldenGate] is well suited for data replication where real-time results are important, such as data reporting. There is potential to have the users query the replicated database, which can have separate resources set up to be compressed or using lower performing or cheaper resources. As mentioned, columns with LOBs can become a headache, as they will need to be synchronized in their own group many times. Tables containing data in CHAR, VARCHAR, NUMBER, DATE, or other non-LOB columns, however, are able to be replicated quite seamlessly. [Oracle GoldenGate] does provide a way to review errors that are encountered, so that is a positive if their is scrutiny around data integrity.
Once set up, it's very easy to use and keep running, it's getting to that point that can make it cumbersome to some. Also, depending on the data that you want to replicate, the configuration files can become quite cumbersome to maintain. Learning curve can be high for some who are not as experienced with databases and transactions.
Oracle Support for Oracle GoldenGate has been quite responsive and quite helpful in the few situations where we've needed it. Furthermore, the documentation on Oracle GoldenGate is so good that we often do not need to contact support with issues as the fix is already documented and able to be run by us without needing to open a ticket.
We've had Oracle consultants come as well for training days to talk about new features, parts of Oracle GoldenGate we may not be using and things of that nature. The consultants they send are great as they're very knowledgeable about all things Oracle GoldenGate and great resources for any questions or concerns you may have with the product.
We used Oracle University for our Oracle Golden Gate Training and it was top notch. We were able to turn our whole DBA team to Oracle GoldenGate newbies to Oracle GoldenGate troubleshooting experts in a matter of a few days, while this obviously did not come cheap, the company felt that it was worth the investment.
If Oracle GoldenGate is new to your organization, expose as many DBAs as possible to it. Having your whole team fluent in it will overcome early operational hurdles and allow it to more quickly become an accepted and supported part of your supported platform for your team that will enable the business to use it to its fullest.
Oracle is tightly integrated with Oracle Exadata and is a better fit for using Oracle databases.Both products support heterogeneous databases but using Exadata, it just seemed to make better sense to use the Oracle GoldenGate product. We also take advantage of the Oracle GoldenGate Veridata product to compare datasets and make sure they are still in sync.
Have never had any issues with scaling Oracle GoldenGate itself, however Oracle GoldenGate Monitor does have scaling issues, but with Oracle GoldenGate now able to be monitored by Oracle Enterprise Manager, this is no longer an issue, in my opinion.
Recoverpoint allowed the Business to have DR capabilities across a multitude of EMC arrays. It allowed the centralization of VM's to be protected across environments both locally as well as remotely.
Recoverpoint can bring RTO down to minutes and can keep RPOs down to quickly restorable levels as well.
Oracle GoldenGate guarantees our standing-by database in passive data center, is always in "pre-warmed" status, as the data is always in-sync with the master database in our active data center. At any time, the standing-by database can kick in in case the active DC encounters the serious issue. This significantly increases the IT application's high availability and promise to "business as usual".
