Thứ Ba, 20 tháng 5, 2014

Oracle GoldenGate using datapump.

SOURCES:

GGSCI (db01.hieupham) 1> edit params ./GLOBALS
GGSCHEMA GGS_OWNER
CHECKPOINTTABLE GGS_OWNER.CHKPTAB
      
GGSCI (db01.hieupham) 43> edit params mgr
PORT 7809
USERID ggs_owner, PASSWORD ggs_owner
PURGEOLDEXTRACTS /tmp/rt, USECHECKPOINTS
GGSCI (db01.hieupham) 43> start mgr
GGSCI (db01.hieupham) 43>info manager
GGSCI (db01.hieupham) 16>dblogin userid ggs_owner, password ggs_owner;
GGSCI (db01.hieupham) 16>ADD CHECKPOINTTABLE CHKPTAB

GGSCI (db01.hieupham) 42> edit params HIEUPV
EXTRACT HIEUPV
USERID ggs_owner, PASSWORD ggs_owner
EXTTRAIL /tmp/rt
TABLE hieupv.productskey;

GGSCI (db01.hieupham) 42>ADD EXTRACT HIEUPV, TRANLOG, BEGIN NOW
GGSCI (db01.hieupham) 42> ADD EXTTRAIL /tmp/rt, EXTRACT HIEUPV
GGSCI (db01.hieupham) 42>START EXTRACT HIEUPV
GGSCI (db01.hieupham) 42>EDIT PARAMS PUMP
EXTRACT PUMP
PASSTHRU
RMTHOST db02, MGRPORT 7809
RMTTRAIL /tmp/rt
TABLE hieupv.productskey;
GGSCI (db01.hieupham) 42>ADD EXTRACT PUMP, EXTTRAILSOURCE /tmp/rt
GGSCI (db01.hieupham) 42>ADD RMTTRAIL /tmp/rt, EXTRACT PUMP
GGSCI (db01.hieupham) 42>START EXTRACT PUMP

TARGET:
GGSCI (db02.hieupham) 1> edit params ./GLOBALS
GGSCHEMA GGS_OWNER
CHECKPOINTTABLE GGS_OWNER.CHKPTAB

GGSCI (db02.hieupham) 17> edit params mgr
PORT 7809
USERID ggs_owner, PASSWORD ggs_owner
GGSCI (db02.hieupham) 16>dblogin userid ggs_owner, password ggs_owner;
GGSCI (db02.hieupham) 16>ADD CHECKPOINTTABLE CHKPTAB
GGSCI (db02.hieupham) 16>EDIT PARAMS HIEUPV
REPLICAT HIEUPV
USERID ggs_owner, PASSWORD ggs_owner
ASSUMETARGETDEFS
DISCARDFILE /tmp/reportd.dsc, APPEND
MAP hieupv.productskey, TARGET hieupv.productskey;
GGSCI (db02.hieupham) 16>ADD REPLICAT HIEUPV, EXTTRAIL /tmp/rt
GGSCI (db02.hieupham) 16>START REPLICAT HIEUPV
GGSCI (db02.hieupham) 16>info all

-----------ohhhh Dear chạy ngon hhhho-------------------------------








Không có nhận xét nào: