CONFIGURING GOLDEN GATE ENVIRONEMENT

How to prepare enviroment for golden gate to be working

=======================================

1) we have install golden gate software on source and target 

2) Enable supplemental logging on database as well as table side

SQL>alter database add supplemental logdata

GGSCI>DBLOGIN USERID PASSWORD

GGSCI>ADD TRANDATA OWNER TABLE

1) all tables required for replication should have table level supplemental logging enabled

   from ggsci add use command add trandata on table

2)if the source and target is hetrogenous then we have to use defgen utilty

3)create golden gate user should have certain previaleges on sourc and target 

4) Database must be in archivelog mode

PREAPARING MANAGER

==============

Manager parameter file (Sample)

-- Manager port number

PORT <port number>

-- As a Manager parameter, PURGEOLDEXTRACTS allows to manage trail

-- files in a centralized fashion and take into account multiple

-- processes.

PURGEOLDEXTRACTS <path to the trail file>, USECHECKPOINTS, MINKEEPHOURS

<”x” hours> MINKEEPFILES <”y” number of files>

-- Start one or more Extract and Replicat processes automatically after

-- they fail. AUTORESTART provides fault tolerance when something

-- temporary interferes with a process, such as intermittent network

-- outages or programs that interrupt access to transaction logs.

AUTORESTART EXTRACT *, RETRIES <x>, WAITMINUTES <y>, RESETMINUTES <z>

--This is to specify a lag threshold that is considered critical,

--and to force a warning message to the error log. Lagreport parameter

--specifies the interval at which manager checks for extract / replicat

--lag.

LAGREPORTMINUTES <x>