Skip to Main Content

Database Software

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!

Refresh Goldengate Extract, Pump, Replicat without Stop & Start

GKrisAug 31 2016 — edited Sep 12 2016

Idea Details:

Every time we add new table or schema to Extract, Pump or Replicate we need to bounce Extract and replicate by halting current running transactions.
To Avoid, halting current running transactions and performing manual stopping and starting Extract and replicates, with this idea expecting a simple way to auto refresh currently running Extract and replicates parameters.

Reported release:
Currently Using Golden gate 12.1.0 (both Classic & Integrated , Capture and Delivery)

Business process:
Automatic refresh of Extract(s) and replicat(s) parameters.

Gap and benefits:
Manually Stopping and starting Extract(s) and  Replicate(s).
Do not need to stop current running transactions and auto refreshes existing Extract(s) and Replicate(s).

Refresh Goldengate Extract, Pump, Replicat without Stop & Start just like refresh Manager.

Eg:

GGSCI> REFRESH MGR

GGSCI> REFRESH EXTRACT <EXTRACT GROUP>

GGSCI> REFRESH REPLICAT <REPLICAT GROUP>

Thanks

Phani Krishna Gurrala

Comments
Post Details
Added on Aug 31 2016
8 comments
6,134 views