Showing posts with label goldengate. Show all posts
Showing posts with label goldengate. Show all posts

Monday, April 7, 2014

Oracle RDS GoldenGate support

Oracle GoldenGate can be used with Amazon RDS for Oracle for active-active database replication, zero-downtime migration and upgrades, disaster recovery and data protection, and cross region replication. 

Thursday, October 31, 2013

Replication of on premise Oracle to Oracle RDS

When Oracle databases are moved from on premise environments to AWS Oracle RDS, there may still be existing on premise Oracle (and non-Oracle) databases that need to replicate data to Oracle RDS. Options such as Oracle GoldenGate and Oracle Streams can be used.  There are also some other options: 

SymmetricDS is open source software : http://www.symmetricds.org
DBVisit : http://www.dbvisit.com/solutions/data_distribution/
Shareplex : http://www.quest.com/shareplex-for-oracle/
Pervasive : http://integration.pervasive.com/Integration-Scenarios/Data-Migration-ETL.aspx

Tuesday, April 23, 2013

AWS RDS cross region replication


RDS offers a simple way to replicate across AZs (Multi-AZ feature) for fault tolerance and high availability.  RDS cross region synchronization / replication provides additional fault tolerance.  This is an interesting situation because RDS is a 'black box'/PaaS/DaaS environment. Therefore, no access to the OS level is provided. This means this replication solutions like MySQL Replication or Oracle Goldengate can not be used.  Until RDS offers snapshots like the new EBS region snapshotting, you will have to use tools like BitTorrent or CloudBeam to move database dump files across regions.You could use DB links with materialized views as this article mentions: http://aws.amazon.com/articles/4173109646282306. DB Links are slow but if you don't have a low RTO and RPO you could use this...Or come up with your own creative solution.

Monday, December 17, 2012

Oracle on AWS - EBS mirroring


Question RAID and EBS Raid 1 - Does AWS EBS provide recovery from an EBS volume since the data is automatically mirrored by AWS?
Response:  It depends on whether  you want control over the recovery for mirroring.   Using the built in mirroring means you do not control the mirroring and therefore when recovery happens.  Other options include using Oracle Standby DB/DataGuard, GoldenGate or even EBS snapshots.