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/，如需轉載，請註明出處，否則將追究法律責任。