Steps for building OGG
AIX-- > HP-UX
1. Download the GGS installation
Tar-xvf ggs_AIX_ppc_ora102_64bit_v11_1_1_0_0_078.tar
2, create a directory
GGSCI (test4-1541) 1 > create subdirs
3. Add additional logs on the source side
Database level:
SQL > alter database add supplemental log data
Table level:
GGSCI (test4-154) > dblogin userid goldengate,password goldengate
GGSCI (test4-154) > add trandata goldengate.TCU*
4. Configure the source-side mgr process
GGSCI (test4-154) > edit params mgr
PORT 7809
Dynamicportlist 7810-7815
Autostart extract *
Autorestart extract *, retries 5 and Waitless 7
Purgeoldextracts. / dirdat/et,usecheckpoints,minkeepdays 1
Lagreporthours 1
Laginfominutes 10
Lagcriticalminutes 15
5. Configure the EXTRACT process
GGSCI (test4-154) > add extract ext1,tranlog,begin now
GGSCI (test4-154) > add exttrail / ogg/dirdat/et, extract ext1,megabytes 50
EXTTRAIL added.
GGSCI (test4-154) 19 > edit params ext1
Extract ext1
Dynamicresolution
Userid goldengate, password goldengate
Exttrail / ogg/dirdat/jb
Table goldengate.TCUSTMER
Table goldengate.TCUSTORD
6. Configure the PUMP process
GGSCI (test4-154) 21 > add extract pump1,exttrailsource / ogg/dirdat/jb
EXTRACT added.
GGSCI (test4-154) 22 > add rmttrail / oracle/test/dirdat/et,extract pump1,MEGABYTES 50
RMTTRAIL added.
GGSCI (test4-154) 23 > edit params pump1
EXTRACT pmpjb
PASSTHRU
UserId goldengate, Password goldengate
RMTHOST 10.118.88.22, MGRPORT 7809
RMTTRAIL / oracle/test/dirdat/jb
Numfiles 50
DYNAMICRESOLUTION
TABLE goldengate.TCUSTMER
TABLE goldengate.TCUSTORD
7. Start the source-side process
GGSCI (test4-154) > start mgr
GGSCI (test4-154) > start *
-
EXP | IMP synchronizes data
-
8. Configure the target side mgr process
PORT 7809
Dynamicportlist 7810-7815w params mgr
Autorestart extract *, waitminutes 1 leading retries 5
Lagreporthours 1
Laginfominutes 3
Lagcriticalminutes 5
Purgeoldextracts / oracle/test/dirdat/jb*,usecheckpoints,minkeepdays 1
9. Add chkpoint to the destination side
GGSCI (HP-test1) 5 > edit params. / GLOBAL
GGSCHEMA goldengate
CHECKPOINTTABLE goldengate.ggschkpt
GGSCI (HP-test1) 9 > dblogin userid goldengate,password goldengate
GGSCI (HP-test1) 10 > add checkpointtable goldengate.ggschkpt
10, add replicat process
ADD REPLICAT rep_jb01,EXTTRAIL / oracle/test/dirdat/jb CHECKPOINTTABLE goldengate.ggschkpoint
11, start the target side process
Start mgr
Start rep_jb01 aftercsn xxxxx