OGG(oracle+GoldenGate)ѧϰ±Ê¼Ç ÏÂÔØ±¾ÎÄ

--

ÐÂÔöÒ»¸öÔ¶³Ì¶ÓÁУ¬Î»ÖÃΪÔÚ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