Monday, October 31, 2011

Upgrade Oracle Database using Oracle GoldenGate

I have used many upgrade options in the past to Upgrade an Oracle database. Be it an inplace upgrade, out of place upgrade, upgrade on logical standby, using materialized view logs and views or using GOLDENGATE. Turns out Oracle GoldenGate is the best amongst all of them.

We get the most out of this replication in terms of reliability, speed, error-free, ease of use, utmost least downtime. Here are a few more advantages compared to others:

Advantages:
1. Least amount of work upfront.
2. Least amount of errors.
3. Low overhead of troubleshooting if something fails.
4. Least amount of programming effort.
5. Least amount of DOWNTIME.
6. On going progress can be maintained. You can test your upgraded version while sync'ing your production.You can also compare data between your old and new production all the time.

The only disadvantage is that there is a price TAG associated with OGG as with any other product. Contact us and we maybe we able to help you and help you succeed with your upgrade plans.

No comments:

Post a Comment