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.
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.
No comments:
Post a Comment