GoldenGate實現oracle和sqlserver雙向資料同步
本文記錄了配置oracle和sqlserver資料同步的關鍵步驟,只為備忘!
測試環境:
oracle10.2.0.1
sqlserver2005(SQLServer2005SP3-KB955706-x86-CHS.exe)
oracle10.2.0.1
sqlserver2005(SQLServer2005SP3-KB955706-x86-CHS.exe)
oracle->sqlserver同步:
oracle和sqlserver中分別建一張測試表(表必須有主鍵)
oracle:create table n (id number(10) primary key)
sqlserver:create table n (id int primary key)
oracle:create table n (id number(10) primary key)
sqlserver:create table n (id int primary key)
oracle:
ggsci>edit param mgr
port 7809
ggsci>edit param mgr
port 7809
ggsci>dblogin userid ggs,password ggs
ggsci>add trandata test.n
ggsci>edit param eiexaa
extract eiexaa
userid ggs,password ggs
exttrail ./dirdat/dd
table test.n;
ggsci>add trandata test.n
ggsci>edit param eiexaa
extract eiexaa
userid ggs,password ggs
exttrail ./dirdat/dd
table test.n;
ggsci>edit param epmpaa
extract epmpaa
passthru
rmthost 192.168.126.131,mgrport 7809
rmttrail ./dirdat/dd
table test.n;
extract epmpaa
passthru
rmthost 192.168.126.131,mgrport 7809
rmttrail ./dirdat/dd
table test.n;
ggsci>add extract eiexaa,tranlog,begin now
ggsci>add exttrail ./dirdat/dd,extract eiexaa,megabytes 5
ggsci>add extract epmpaa,exttrailsource ./dirdat/dd
ggsci>add rmttrail ./dirdat/dd,extract epmpaa,megabytes 5
ggsci>add exttrail ./dirdat/dd,extract eiexaa,megabytes 5
ggsci>add extract epmpaa,exttrailsource ./dirdat/dd
ggsci>add rmttrail ./dirdat/dd,extract epmpaa,megabytes 5
sqlserver:
ggsci>edit param mgr
port 7809
ggsci>edit param mgr
port 7809
ggsci>sourcedb ggsdb dblogin userid ggs,password ggs
(ggsdb為系統DSN名)
ggsci>edit param rorabb
replicat rorabb
sourcedb ggsdb userid ggs,password ggs
handlecollisions
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/rorabb.dsc,PURGE
map test.n, target n;
(ggsdb為系統DSN名)
ggsci>edit param rorabb
replicat rorabb
sourcedb ggsdb userid ggs,password ggs
handlecollisions
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/rorabb.dsc,PURGE
map test.n, target n;
ggsdb資料庫建立ggs_checkpoint表
ggsci>add replicat rorabb,checkpointtable ggs_checkpoint,exttrail ./dirdat/dd
ggsci>add replicat rorabb,checkpointtable ggs_checkpoint,exttrail ./dirdat/dd
sqlserver->oracle同步:
oracle和sqlserver中分別建一張測試表(表必須有主鍵)
oracle:create table m (id number(10) primary key)
sqlserver:create table m (id int primary key)
oracle:create table m (id number(10) primary key)
sqlserver:create table m (id int primary key)
sqlserver:
ggsci>sourcedb ggsdb dblogin userid ggs,password ggs
ggsci>add trandata m
ggsci>edit param eiexbb
extract eiexbb
sourcedb ggsdb userid ggs,password ggs
exttrail ./dirdat/bb
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
table m;
ggsci>sourcedb ggsdb dblogin userid ggs,password ggs
ggsci>add trandata m
ggsci>edit param eiexbb
extract eiexbb
sourcedb ggsdb userid ggs,password ggs
exttrail ./dirdat/bb
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
table m;
ggsci>edit param epmpbb
extract epmpbb
passthru
rmthost 192.168.126.1,mgrport 7809
rmttrail ./dirdat/bb
table m;
extract epmpbb
passthru
rmthost 192.168.126.1,mgrport 7809
rmttrail ./dirdat/bb
table m;
ggsci>add extract eiexbb,tranlog,begin now
ggsci>add exttrail ./dirdat/bb,extract eiexbb,megabytes 5
ggsci>add extract epmpbb,exttrailsource ./dirdat/bb
ggsci>add rmttrail ./dirdat/bb,extract epmpbb,megabytes 5
ggsci>add exttrail ./dirdat/bb,extract eiexbb,megabytes 5
ggsci>add extract epmpbb,exttrailsource ./dirdat/bb
ggsci>add rmttrail ./dirdat/bb,extract epmpbb,megabytes 5
oracle:
ggsci>dblogin userid ggs,password ggs
ggsci>edit param roradd
replicat roradd
userid ggs,password ggs
handlecollisions
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/roradd.dsc,PURGE
MAP dbo.m, TARGET test.m;
ggsci>dblogin userid ggs,password ggs
ggsci>edit param roradd
replicat roradd
userid ggs,password ggs
handlecollisions
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/roradd.dsc,PURGE
MAP dbo.m, TARGET test.m;
ggs使用者下建立ggs_checkpoint表
ggsci>add replicat roradd,checkpointtable ggs.ggs_checkpoint,exttrail ./dirdat/bb
ggsci>add replicat roradd,checkpointtable ggs.ggs_checkpoint,exttrail ./dirdat/bb
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29119536/viewspace-1346855/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle GoldenGate系統之----雙向同步資料表OracleGo
- 使用GoldenGate 實現Oracle for Oracle 單向資料同步(實現表的DML操作同步)GoOracle
- 【GoldenGate】Oracle GoldenGate(二) 雙向同步配置GoOracle
- GoldenGate雙向同步配置Go
- unison+inotify實現web資料雙向同步Web
- 利用python實現mysql資料庫向sqlserver的同步PythonMySql資料庫Server
- Oracle GoldenGate系統之----單向同步資料表OracleGo
- Oracle GoldenGate系統之----單向同步資料表(續)OracleGo
- Oracle Dataguard + Goldengate資料同步OracleGo
- Linux下GoldenGate單機雙向同步LinuxGo
- goldengate不使用資料泵完成Oracle-Oracle的雙向複製GoOracle
- oracle goldengate 雙向複製配置OracleGo
- Oracle使用goldengate分別向Oracle和mysql雙路的單向複製OracleGoMySql
- oracle資料庫配置goldengate同步Oracle資料庫Go
- 雙向資料繫結實現原理
- javascript實現雙向資料繫結JavaScript
- 配置Oracle GoldenGate for DB2(雙向)OracleGoDB2
- 【GoldenGate】Oracle GoldenGate(一) 安裝與DML單向同步配置GoOracle
- js 實現vue的雙向資料繫結JSVue
- vue資料雙向繫結的實現原理Vue
- Oracle GoldenGate 資料同步初始化最佳實戰(Data Pump)OracleGo
- 【GoldenGate】Oracle GoldenGate(四) 壓力測試同步百萬行資料GoOracle
- ogg在異構資料庫實時雙向同步中如何防止資料死迴圈同步資料庫
- Oracle GoldenGate資料同步備份軟體概述OracleGo
- JavaScript實現簡單的雙向資料繫結JavaScript
- 基於vue實現的雙向資料繫結Vue
- 在winform中如何實現雙向資料繫結?ORM
- 資料結構(雙向連結串列的實現)資料結構
- GoldenGate單向表DML同步Go
- goldengate 12.3 實現mysql資料及DDL實時同步GoMySql
- 資料結構-雙向連結串列(Python實現)資料結構Python
- 手動簡單實現Vue雙向資料繫結Vue
- 通過原生js實現資料的雙向繫結JS
- oracle 資料透過goldengate 實時同步到kafka訊息佇列中OracleGoKafka佇列
- 使用goldengate從mysql同步資料到oracleGoMySqlOracle
- 手動實現vue元件間的雙向資料繫結Vue元件
- javascript實現資料的雙向繫結(手動繫結)JavaScript
- 【GoldenGate】Oracle GoldenGate(三) DDL同步配置GoOracle