Oracle GoldenGate DDL setup

Cấu hình DDL:

$cd $GGS_HOME

$sqlplus / as sysdba

SQL> @marker_setup 

SQL> alter session set recyclebin=OFF;

SQL> @ddl_setup

SQL> @role_setup

SQL> grant ggs_ggsuser_role to ggs_owner;

SQL> @ddl_enable

SQL> @ddl_pin GGS_OWNER

SOURCE:

Edit params ./GLOBALS

CHECKPOINTTABLE GGS_OWNER.GGS_CHECKPOINT

GGSCHEMA GGS_OWNER

Edit params mgr

PORT 7809

PURGEOLDEXTRACTS ./dirdat/*, USECHECKPOINTS

PURGEMARKERHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5

PURGEDDLHISTORY MINKEEPDAYS 3, MAXKEEPDAYS 5

GGSCI> dblogin userid ggs_owner, password xxxx

GGSCI> info checkpointtable

GGSCI> add checkpointtable

GGSCI> edit param eddl

EXTRACT EDDL

EXTTRAIL ./dirdat/ed

USERID ggs_owner, PASSWORD xxxx

DDL INCLUDE MAPPED OBJNAME “FLEXLIVE.*”

DDLOPTIONS ADDTRANDATA, REPORT

TABLE FLEXLIVE.*;

GGSCI> add extract eddl, tranlog, begin now

GGSCI> add exttrail ./dirdat/ed, extract eddl, megabytes 100

GGSCI> edit param pddl

EXTRACT PDDL

RMTHOST <hostname>, MGRPORT 15001, COMPRESS

RMTTRAIL ./dirdat/pd

PASSTHRU

TABLE FLEXLIVE.*;

GGSCI> add extract pddl, exttrailsource ./dirdat/ed

GGSCI> add rmttrail ./dirdat/pd, extract pddl, megabytes 100

Target

GGSCI> dblogin userid ggs_owner, password xxxx

GGSCI> info checkpointtable

GGSCI> add checkpointtable

GGSCI> edit param rddl

REPLICAT RDDL    

DISCARDFILE ./dirrpt/rddl.dsc, PURGE

ASSUMETARGETDEFS

USERID ggs_owner, PASSWORD xxxx

DDL INCLUDE MAPPED

MAP FLEXLIVE.*, TARGET FLEXLIVE.*;

GGSCI> add replicat rddl, exttrail ./dirdat/pd

Check:

GGSCI> stats eddl, total

Delete Trace file

Crontab -> run $GGS_HOME/ddl_cleartrace