Tuesday, 21 February 2017

Oracle Goldengate Tutorial - Beginner (Level 6)

Creating Process Groups

This Chapter contains instructions for creating Oracle GoldenGate process groups, collectively known as "change-synchronization" processes.
At Minimum, you will create one primary extract, One data pump and a replicat process group.

Add the Primary Extract

1. Set the RMAN archivelog deletion policy to the following value
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY
2. Add Extract Process Group

DBLOGIN USERIDALIAS myalias
ADD EXTRACT finance, INTEGRATED TRANLOG, BEGIN NOW

Add The Local Trail
ADD EXTTRAIL /ggs/dirdat/lt, EXTRACT finance
Add the Datapump Extract Group
ADD EXTRACT financep, EXTTRAILSOURCE c:\ggs\dirdat\lt
Add the Remote Trail
ADD RMTTRAIL /ggs/dirdat/rt, EXTRACT financep
Add The Replicat Group
DBLOGIN USERIDALIAS alias
ADD REPLICAT financer, EXTTRAIL c:\ggs\dirdat\rt

No comments:

Post a Comment