When using Oracle GoldenGate in mission-critical systems, you need to have the following high availability (HA/#HighAvailability) considerations:
- (GoldenGate Instance Failure) When both the source and the target databases run as usual, you need to configure HA for the Oracle GoldenGate instance if running from a single instance. This is normally caused by data issue or network outage.
- (GoldenGate Instance Server Failure) When both the source and the target databases run as usual, you need to configure HA for the Oracle GoldenGate instance. While considering this, if the GoldenGate instance has to change from one server to the other, you need to make sure the replication can resume without data loss.
- (Source Database Failure) When the source database fails over to its standby database, you then need to configure the Oracle GoldenGate capture to fail-over with the source database and start capturing from the new primary database without data loss.
- (Target Database Failure) When the target database fails over to its standby database, you then need to configure the Oracle GoldenGate Delivery to fail-over with the target database and start delivering to the new primary database without data loss.
Tag: Oracle GoldenGate, High Availability