您好,登錄后才能下訂單哦!
添加主進(jìn)程
GGSCI (ggate1) 2> edit params mgr
PORT 7809
PURGEOLDEXTRACTS /oracle/ggate/dirdat/mytest_xiuj/ex*, USECHECKPOINTS, MINKEEPDAYS 7
登錄到數(shù)據(jù)庫
GGSCI (ggate1) 3> dblogin userid ggate,password ggate
Successfully logged into database.
GGSCI (ggate1) 4> start mgr
2、配置抽了進(jìn)程
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、配置傳輸進(jìn)程
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、配置復(fù)制進(jìn)程
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") --注意,本處不能少,因?yàn)槟繕?biāo)端與源端字符集不同
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時(shí),要確定源端與目標(biāo)端的字符集是否相同
通過:
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
而源端為:"SIMPLIFIED CHINESE_CHINA.UTF8",使目標(biāo)端與源端相同,否則在目標(biāo)端,會(huì)出現(xiàn)亂碼。所以在復(fù)制進(jìn)程中必須加一段設(shè)置環(huán)境的值:setenv ( NLS_LANG = "SIMPLIFIED CHINESE_CHINA.UTF8")
查詢導(dǎo)出字符集
select * from database_properties where property_name = 'NLS_CHARACTERSET'
相關(guān)視圖及表
nls_database_parameters props$ v$nls_parameters
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。