goldengate基於表複製
1、在源端主程式配置
新增主程式
GGSCI (ggate1) 2> edit params mgr
PORT 7809
PURGEOLDEXTRACTS /oracle/ggate/dirdat/mytest_xiuj/ex*, USECHECKPOINTS, MINKEEPDAYS 7
登入到資料庫
GGSCI (ggate1) 3> dblogin userid ggate,password ggate
Successfully logged into database.
GGSCI (ggate1) 4> start mgr
2、配置抽了程式
GGSCI (ggate1) 13> add trandata mytest.mytest_xiuj
Logging of supplemental redo data enabled for table MYTEST.MYTEST_XIUJ.
GGSCI (ggate1) 14> add extract exiuj,tranlog,begin now
EXTRACT added.
GGSCI (ggate1) 15> add exttrail /oracle/ggate/dirdat/mytest_xiuj/ex,extract exiuj
EXTTRAIL added.
GGSCI (ggate1) 17> edit params exiuj
extract exiuj
userid ggate,password ggate
exttrail /oracle/ggate/dirdat/mytest_xiuj/ex
table mytest.mytest_xiuj;
3、配置傳輸程式
GGSCI (ggate1) 23> add extract pxiuj,exttrailsource /oracle/ggate/dirdat/mytest_xiuj/ex
EXTRACT added.
GGSCI (ggate1) 24> add rmttrail /u01/app/ggate/dirdat/mytest_xiuj/re,extract pxiuj
RMTTRAIL added.
GGSCI (ggate1) 25> edit params pxiuj
extract pxiuj
rmthost 192.168.92.191,mgrport 7809
passthru
rmttrail /u01/app/ggate/dirdat/mytest_xiuj/re
table mytest.mytest_xiuj;
4、配置複製程式
GGSCI (ggate2) 3> dblogin userid ggate,password ggate
Successfully logged into database.
GGSCI (ggate2) 4> add checkpointtable chkxiuj
Successfully created checkpoint table CHKxiuj.
GGSCI (ggate2) 5> add replicat rxiuj,exttrail /u01/app/ggate/dirdat/mytest_xiuj/re,checkpointtable chkxiuj
REPLICAT added.
GGSCI (ggate2) 6> edit params rxiuj
replicat rxiuj
setenv ( NLS_LANG = "SIMPLIFIED CHINESE_CHINA.UTF8") --注意,本處不能少,因為目標端與源端字符集不同
assumetargetdefs
HANDLECOLLISIONS
userid ggate,password ggate
discardfile /u01/app/ggate/dirdat/mytest_xiuj/rep1_discard.txt, append, megabytes 10
map mytest.mytest_xiuj, target receiver.mytest_xiuj;
--說明:
在配置goldengate時,要確定源端與目標端的字符集是否相同
透過:
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
而源端為:"SIMPLIFIED CHINESE_CHINA.UTF8",使目標端與源端相同,否則在目標端,會出現亂碼。所以在複製程式中必須加一段設定環境的值:setenv ( NLS_LANG = "SIMPLIFIED CHINESE_CHINA.UTF8")
查詢匯出字符集
select * from database_properties where property_name = 'NLS_CHARACTERSET'
相關檢視及表
nls_database_parameters props$ v$nls_parameters
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14710393/viewspace-2144721/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- GoldenGate DML複製增刪改表Go
- goldengate針對不同表名及列名的複製Go
- goldengate 過濾對某張表的複製操作Go
- goldengate配置DDL複製Go
- GoldenGate的複製原理Go
- 資料複製_GoldenGateGo
- GoldenGate單向複製配置(支援DDL複製)Go
- GoldenGate多對一複製Go
- goldengate 單向複製配置Go
- 主從複製、雙主複製及半同步複製、以及基於SSL的複製
- oracle goldengate 雙向複製配置OracleGo
- goldengate單向複製的配置Go
- oracle goldengate 雙活複製避免迴圈複製引數OracleGo
- 5-5配置Mysql複製 基於日誌點的複製MySql
- GoldenGate的簡介與複製原理Go
- goldengate 刪除複製程式步驟Go
- GoldenGate配置(三)之DDL複製配置Go
- EOFDELAYCSECS GOLDENGATE提升複製實時性Go
- Mysql基於GTID的複製模式MySql模式
- Mysql 基於GTID主從複製MySql
- MySQL表複製MySql
- GoldenGate簡單複製環境的搭建Go
- GoldenGate schema級複製 實施過程Go
- GoldenGate配置(二)之雙向複製配置Go
- GoldenGate配置(一)之單向複製配置Go
- mysql 基於日誌的主從複製MySql
- MySQL基於binlog主從複製配置MySql
- MySQL·引擎特性·基於InnoDB的物理複製MySql
- mysql:sql as 複製表MySql
- GoldenGate複製的幾個簡單測試Go
- GoldenGate在異構環境下的複製Go
- 【轉】GoldenGate資料庫複製實施案例Go資料庫
- MySQL 5.7 基於GTID搭建主從複製MySql
- MySQL 5.7基於GTID的主從複製MySql
- Mysql5.6主從複製-基於binlogMySql
- 基於Docker的GoldenGate部署DockerGo
- T-SQL——關於表資料的複製插入SQL
- 對於複製普通物件 深複製和淺複製是否一樣物件