Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
upgrade of target database in ogg config
Hi Guys,
Need advise here as not really familiar with OGG.
== existing OGG config:
Source: 11gR2 (extract, pump)
Target: 11gR2 (replicat)
Source and target DB on different server
===
We are planning to upgrade the "target DB" from 11gr2 to 19c. It will be on a new server and DB.
We will be using export/import for migration as the target db size is not huge.
As the existing target DB is part of existing OGG config, need advise here.
We are looking into having a new set of "extract, pump in source and replicat in the new server" so that existing replication to existing target DB will not be impacted.
As there are additional data set in the target DB (not part of ogg replication), we are looking into exporting the data direct from the existing target db and import to the new DB and from there start the new set of extract/pump/replicat.
Question is.. how do we ensure data is in-sync if we are using the data direct from target db as baseline (initial load) prior to starting the new extrat/pump/replicat? we won't be able to stop the source DB application as no downtime.
Need some pointers here.
thanks!