--
ÐÂÔöÒ»¸öÔ¶³Ì¶ÓÁУ¬Î»ÖÃΪÔÚTargetDBµÄd:\\ggs\\dirdat\\r1£¬ÊdzéÈ¡½ø³Ìext1³éÈ¡µÄÊý¾Ý¶ÓÁУ¬×¢ÒâºÍ³éÈ¡½ø³ÌÖÐÅäÖõÄrmttrail d:\\ggs\\dirdat\\r1Ò»Ö¡£ ¿ªÆôËùÓнø³Ì
GGSCI (PONY) 11> start mgr
Starting Manager as service ('GGSMGR')... Service started.
GGSCI (PONY) 14> start ext1
Sending START request to MANAGER ('GGSMGR') ... EXTRACT EXT1 starting
²é¿´½ø³ÌµÄÔËÐÐÇé¿ö
GGSCI (PONY) 185> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:06
OK£¬Mgr½ø³ÌºÍEXT½ø³Ì¶¼ÒѾÕý³£ÔËÐÐ SouceDB¶ËµÄÅäÖÃÍê³É¡£
3.2.2 ÅäÖÃTargetDBµÄGoldenGate
1.ÅäÖÃmgr²ÎÊý
GGSCI (PONY) 2> edit param mgr
´Ëʱϵͳ×Ô¶¯»áн¨Ò»¸ömgrµÄ²ÎÊýÎļþ£¬ÌîÈëÒÔÏÂÄÚÈݺ󱣴æ PORT 7809
DYNAMICPORTLIST 7840-7850 --mgr½ø³ÌʹÓõÄTCP/IP¶Ë¿ÚÕìÌýÇëÇó ½ÓÊÜÔ¶¶Ë¶ÓÁеĶ˿ÚÁÐ±í¡£
2.ÐÂÔöÒ»¸ö¸´Öƽø³Ì
GGSCI (PONY) 2>ADD replicat rep1 EXTTRAIL d:\\ggs\\dirdat\\r1, nodbcheckpoint
--ÐÂÔöÒ»¸ö¸´Öƽø³Ì£¬½«³éÈ¡µ½¶ÓÁÐÖеÄÎļþ½âÎöºóд½øTargetDB
3.ÅäÖø´Öƽø³Ì
9
GGSCI (PONY) 2> edit param rep1
´Ëʱϵͳ»á×Ô¶¯Ð½¨Ò»¸ö²ÎÊýÎļþ£¬ÌîÈëÒ»ÏÂÄÚÈݺ󱣴æ
replicat rep1
userid goldengate,password goldengate assumetargetdefs
reperror default,discard
discardfile D:\\oradata\\discard\\repsz.dsc,append,megabytes 100 gettruncate
map sajet.*, target sajet.*; map sj.*, target sj.*;
map lang.*, target lang.*; map smt.*, target smt.*;
--¸´Öƽø³ÌÃû
µÇÈëTargetDBµÄÕ˺źÍÃÜÂë
Á½Ì¨DBÊý¾Ý½á¹¹Ò»ÖÂÔòʹÓô˲ÎÊý
Èç¹û¸´ÖƳö´í£¬Ôò¼ÌÐø£¬²¢½«´íÎó·Å½ødiscardfileÖÐ ¸´ÖÆtruncate²Ù×÷
¸´ÖƵÄÔ´±íΪsajet£¬sj£¬lang£¬smtÓû§ÏµÄËùÓÐ±í£¬Ä¿±êΪTargetDBÖжÔÓÃÓû§ÏµÄËùÓбí
¿ªÆômgrºÍrep½ø³Ì
GGSCI (PONY) 20> start mgr
Starting Manager as service ('GGSMGR')... Service started.
GGSCI (PONY) 21> start rep1
Sending START request to MANAGER ('GGSMGR') ... REPLICAT REP1 starting
²é¿´½ø³ÌµÄÔËÐÐÇé¿ö
GGSCI (PONY) 22> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:07
10
OK,MGR½ø³ÌºÍREP½ø³ÌÔËÐÐÕý³£
ÖÁ´Ë£¬Á½Ì¨DBµÄGoldenGate¶¼ÒѾÅäÖÃÍê³É¡£
3.3 ²âÊÔDML²Ù×÷
Ê×ÏÈÍùSourceDBÖвåÈëÒ»ÐÐ
C:\\Documents and Settings\\Administrator>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 8 15:33:47 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: sajet/tech@hitron
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options
SQL> insert into sajet.sys_emp values (10000786,'TEST1','TEST1','','TEST','10000 27','','Y','',0,'',0,'','') 2 ;
1 row created. SQL> commit 2 ;
Commit complete.
¿´¿´TargetDBÖÐÊÇ·ñÓÐͬÑùµÄ¼Ç¼´æÔÚÄØ SQL> connect sajet/tech@goldenga Connected.
SQL> select count (*) from sajet.sys_emp 2 where emp_id=10000786;
COUNT(*) ---------- 1
ͬ²½¹ýÀ´ÁË¡£
ÎÒÃÇ¿ÉÒÔ¿´¿´EXT1½ø³ÌµÄÏà¹ØÍ³¼ÆÐÅÏ¢
11
GGSCI (sajet-project) 189> stats ext1
Sending STATS request to EXTRACT EXT1 ...
Start of Statistics at 2010-03-08 15:47:51.
DDL replication statistics (for all trails):
*** Total statistics since extract started ***
Operations 40.00 Mapped operations 28.00 Unmapped operations 0.00 Other operations 12.00 Excluded operations 0.00
Output to d:\\ggs\\dirdat\\r1:
Extracting from GOLDENGATE.GGS_MARKER to GOLDENGATE.GGS_MARKER:
*** Total statistics since 2010-03-05 09:51:51 ***
No database operations have been performed.
*** Daily statistics since 2010-03-08 00:00:00 ***
No database operations have been performed.
*** Hourly statistics since 2010-03-08 15:00:00 ***
No database operations have been performed.
*** Latest statistics since 2010-03-05 09:51:51 ***
No database operations have been performed.
Extracting from SAJET.GOLDEGATETEST to SAJET.GOLDEGATETEST:
*** Total statistics since 2010-03-05 09:51:51 ***
Total inserts 3.00 Total updates 0.00 Total deletes 0.00 Total truncates 2.00 Total discards 0.00
12