- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.4K On-Premises Infrastructure
- 137.7K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
add second replicat golden gate
Oracle DB 22.214.171.124
RAC 2 nodes
I would like to add a second replicat process to my golden gate enviroment. We initially configured goldengate using commands below. Note that replication is downstream.
dblogin useridalias oggscb_dwh
miningdblogin useridalias oraggext
add extract extdwh integrated tranlog begin now
ADD EXTTRAIL /ogg/ora12c/dirdat/aa, EXTRACT EXTDWH
add extract pxdwn exttrailsource /ogg/ora12c/dirdat/aa
ADD RMTTRAIL /ogg/ora12c/dirdat/cd, EXTRACT PXDWN
register extract EXTDWH database
add replicat REPLOGGT integrated exttrail /ogg/ora12c/dirdat/cd
We are currently experiencing lots of wait dependencies. I also noticed the memory is depleting very fast on the first node where GG is running.
Replicat is consuming almost all SGA
Kindly advise if I add a second replicat with RANGE function this will solve the issue.
Kindly guide me through the steps.