This discussion is archived
1 Reply Latest reply: Jan 15, 2013 10:38 PM by kgronau RSS

Oracle goldengate configureation

941319 Newbie
Currently Being Moderated
Souce:
----------
MGR PARAMETER
PORT 7809
DYNAMICPORTLIST 7810-7820
PURGEOLDEXTRACTS /exports/OGG10g_Home/dirdat

dblogin userid adm1, password adm1


SQLPLUS ORCL (SYS USER)
=========
@marker_setup.sql
@ddl_setup.sql
@role_setup.sql

grant GGS_GGSUSER_ROLE to adm1;

@ddl_enable.sql

dblogin userid adm1, password adm1

add trandata scott.*

exteimple parameter

EXTRACT extsimple
EXTTRAIL /exports/OGG10g_Home/dirdat/ut
DISCARDFILE /exports/OGG10g_Home/dirrpt/simple.dsc
SETENV (ORACLE_SID = "ORCL")
USERID adm1, PASSWORD adm1
DBOPTIONS ALLOWUNUSEDCOLUMN
TRANLOGOPTIONS EXCLUDEUSER adm1
DDL INCLUDE MAPPED OBJNAME scott.*
DDLOPTIONS ADDTRANDATA, REPORT
TABLE scott.*;

PMPSIMPLE PARAMETER

EXTRACT pmpuat
RMTHOST 183.82.143.49, MGRPORT 7809, COMPRESS
RMTTRAIL /exports/OGG10g_Home/dirdat/ut
SETENV (ORACLE_SID = "raja")
TRANLOGOPTIONS EXCLUDEUSER adm1
PASSTHRU
TABLE scott.*;



add extract extsimple, tranlog, begin now
add exttrail /exports/OGG10g_Home/dirdat/ut, extract extsimple, megabytes 50
add extract pmpsimple, exttrailsource /exports/OGG10g_Home/dirdat/ut
add rmttrail /exports/OGG10g_Home/dirdat/ut, extract pmpsimple, megabytes 50

start extract extsimple
start extract pmpsimple

add checkpointtable simple
add replicat repsimple, exttrail /exports/OGG10g_Home/dirdat/tu, CHECKPOINTTABLE simple

start replicat repsimple



Target:
-----------
MGR PARAMETER
PORT 7809
DYNAMICPORTLIST 7810-7820
PURGEOLDEXTRACTS /exports/OGG10g_Home/dirdat/*, USECHECKPOINTS


dblogin userid adm2, password adm2


RAJA AT SQLPLUS (SYS USER)
========
@marker_setup.sql
@ddl_setup.sql

@role_setup.sql

grant GGS_GGSUSER_ROLE to adm2;

@ddl_enable.sql



dblogin userid adm2, password adm2

add trandata scott.*

REPLICATION PARAMETER

REPLICAT repsimple
ASSUMETARGETDEFS
APPLYNOOPUPDATES
DISCARDFILE /exports/OGG10g_Home/dirrpt/repuat.dsc,
SETENV (ORACLE_SID = "raja")
USERID adm2 PASSWORD adm2
MAP scottt.*, TARGET scott.*;

add checkpointtable simple1
add replicat repsimple1, exttrail /exports/OGG10g_Home/dirdat/ut, CHECKPOINTTABLE simple

start replicat repuat

add extract extsimple1, tranlog, begin now
add exttrail /exports/OGG10g_Home/dirdat/tu, extract extsimple1, megabytes 50
add extract pmpsimple1, exttrailsource /exports/OGG10g_Home/dirdat/tu
add rmttrail /exports/OGG10g_Home/dirdat/tu, extract pmpsimple1, megabytes 50

start extract extsimple1
start extract pmpsimple1


Thanks
Rajasekhar

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points