GoldenGate “单连通” 实施日志

    以下是Golden Gate的单连通方式的配置信息，GG安装相对简单，这里不进行详述。
 
1、源端配置
ggsci> DBLOGIN USERID ggs, password oracle

ggsci>add trandata owner.object_name

ggsci>edit param mgr
     port 7809   ----连接端口
     dynamicportlist 7800-7820
     autorestart er *, retries 5, waitminutes 1
     purgeoldextracts *

 ggsci>edit param ext1
     EXTRACT ext1
    USERID ggs, PASSWORD "oracle"
    THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 30000
    FETCHOPTIONS NOUSESNAPSHOT
    exttrail /home/gg10gs/dirdat/ds, megabytes 100
    dynamicresolution
    nocompressdeletes
    nocompressupdates
    table owner.object_name;

 ggsci>edit param dpt1
     EXTRACT dpt1
     RMTHOST 130.130.0.1, MGRPORT 7810
     RMTTRAIL /home/gg10gt/dirdat/ds
     PASSTHRU
    dynamicresolution
    table owner.object_name;

2、目标端配置
ggsci>edit param mgr
      port 7810   ----连接端口
     dynamicportlist 7800-7820
     autorestart er *, retries 5, waitminutes 1
     purgeoldextracts *

ggsci>edit param rep1
     REPLICAT rep1
     ---解决中文乱码问题
     SETENV (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK")
     GETENV (NLS_LANG)
     USERID ggs, PASSWORD oracle
     --sqlexec "Alter session set constraints=deferred"
     reperror default,discard
     discardfile  /home/gg10gt/dirrpt/rep1.dsc,append, megabytes 100, purge
     discardrollover

     assumetargetdefs
     allownoopupdates
     dynamicresolution

     map xxxx.object_name, target xxxx.object_name;

3、数据的初始加载
源数据库： 
SQL>SELECT dbms_flashback.get_system_change_number FROM DUAL;
exp user/passwd wner=XXXXX file=./20110904.dmp flashback_scn=267116592

目标数据库
imp user/passwd file=./20110904.dmp full=y

如果是单表初始加载
exp user/passwd tables=test file=./test.dmp flashback_scn=267108525
impuser/passwd file=./test.dmp  tables=test

4、源端
ggsci>delete extract ext1
ggsci>delete exttrail  /home/gg10gs/dirdat/ds
ggsci>add ext ext1, tranlog, begin now
ggsci>add exttrail  /home/gg10gs/dirdat/ds, ext ext1, megabytes 100

ggsci>delete extract dpt1
ggsci>delete rmttrail  /home/gg10gt/dirdat/ds
ggsci>add extract dpt1, exttrailsource  /home/gg10gs/dirdat/ds
ggsci>add rmttrail /home/gg10gt/dirdat/ds, ext dpt1, megabytes 100

ggsci>start mgr
ggsci>start ext ext1
ggsci>start ext dpt1

5、目标端
ggsci>delete replicat rep1
ggsci>delete exttrail  /home/gg10gt/dirdat/ds
ggsci>add replicat rep1, exttrail  /home/gg10gt/dirdat/ds, nodbcheckpoint

ggsci>start mgr
ggsci>start rep rep1

6、测试略


  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/354732/viewspace-706642/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/354732/viewspace-706642/