- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 65 Insurance
- 536.7K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
I have following Oracle goldengate query
Oracle goldengate was installed after oracle 12c database was upgraded to Oracle 19c but the database compatible parameter was untouched/unchanged, still compatible parameter points to 12c.
during the installation of Oracle goldengate 19c, chosen database version as 19c
It is an active - passive setup with bi -directional replication. Since DB in production, performed expdp scn based backup and started extract on active site using the same scn. after the start, extract took many hours to come out of recovery phase and now status is shown as processing data but processing rate is very slow. when queried the status it still shows processing the same archivelog.
each passing day extract lag is increasing.
Note there was 1 hour gap b//w backup and starting the extract. Traffic is very low. in a day 10-15 archive log are generated.
Now the question here
- Does database compatible is playing any role here?
- how to come out of this situation and resolve the issue?
Appreciate your inputs.