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------------------------------- |
Thứ Ba, 20 tháng 5, 2014
Oracle GoldenGate using datapump.
Đăng ký:
Đăng Nhận xét (Atom)




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