Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Goldengate database migration

cptkirkshDec 4 2020 — edited Dec 4 2020

We are getting a new exadata and are looking to migrate our DBs from Oracle 18c to 19c. Some of the DBs on our 18c environment have just a few schemas while one in particular has 300. I have read about how after GG 12.2 I can utilize ADD SCHEMATRANDATA "Schema" on source and DBOPTIONS ENABLE_INSTANTIATION_FILTERING on the replicat to really integrate Oracle Data Pump in the whole migration process. This sounds like it would work great for those DBs that only have a small number of schemas. Is it best practice in a DB with a large number of schemas to skip the ADD SCHEMATRANDATA and the DBOPTIONS ENABLE_INSTANTIATION_FILTERING and just capture the SCN after export and start the replicat with that SCN? Thanks in advance.

This post has been answered by ORASCN on Dec 7 2020
Jump to Answer
Comments
Post Details
Added on Dec 4 2020
3 comments
198 views