【正文】 CATION OF DDL TRACE FILEC:\ORACLE\PRODUCT\\ADMIN\TEST\UDUMP/Analyzing installation status...STATUS OF DDL REPLICATIONSUCCESSFUL installation of DDL Replication software ponentsScript plete.SQL @GGS Role setup scriptThis script will drop and recreate the role GGS_GGSUSER_ROLETo use a different role name, quit this script and then edit the script to change the gg_role parameter to the preferred name. (Do not run the script.)You will be prompted for the name of a schema for the GoldenGate database objects.NOTE: The schema must be created prior to running this script.NOTE: Stop all DDL replication before starting this installation.Enter GoldenGate schema name:goldengate已寫(xiě)入 file PL/SQL 過(guò)程已成功完成。Role setup script pleteGrant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL mand:GRANT GGS_GGSUSER_ROLE TO loggedUserwhere loggedUser is the user assigned to the GoldenGate processes.SQL GRANT GGS_GGSUSER_ROLE TO goldengate。授權(quán)成功。SQL @觸發(fā)器已更改SQL exit安裝完成Note：Supported Oracle objects and operations for DDL replicationclustersfunctionsindexespackagesproceduretablestablespacesrolessequencessynonymstriggerstypesviewsmaterialized viewsusersNonsupported Oracle objects and operations for DDL replicationOraclereserved schemasOracle recycle binLimitation of GG DDL Support1) GoldenGate supports DDL replication for unidirectional configurations. Bidirectionalreplication of DDL is not supported.(只支持單向復(fù)制)2)GoldenGate supports DDL synchronization only in a liketolike DDL support requires the following:lSource and target object definitions must be identical.lThe ASSUMETARGETDEFS parameter must be used in the Replicat parameter file. Replicat will abend if objects are configured for DDL support and the SOURCEDEFS parameter is being used.(必須在Replicat參數(shù)文件中指定ASSUMETARGETDEFS參數(shù))5．玩玩GoldenGate前一段跟著Quest的朋友學(xué)習(xí)了一些SharePlex的東西，最近Oracle則在大力推廣另一個(gè)類(lèi)似的產(chǎn)品GoldenGate，手頭的資料不多，只有一份官方文檔和一份所謂的培訓(xùn)教材PPT，不過(guò)可操作性不強(qiáng)，上手有點(diǎn)難，后來(lái)看了這篇文章，才終于把基本的同步實(shí)現(xiàn)了。不過(guò)這位作者顯然已經(jīng)研究不少時(shí)間的GG，所以很多命令并沒(méi)有寫(xiě)明，這里我把它補(bǔ)充一下吧。1，數(shù)據(jù)庫(kù)準(zhǔn)備 檢查SUPPLEMENTAL_LOG和SharePlex一樣，GG要求打開(kāi)SUPPLEMENTAL_LOG，通過(guò)如下SQL可以查看：SQLselect SUPPLEMENTAL_LOG_DATA_MIN from v$database。如果沒(méi)有開(kāi)啟，則執(zhí)行如下語(yǔ)句打開(kāi)SUPPLEMENTAL_LOG：SQLalter database add supplemental log data。 建立測(cè)試用戶(hù)ggs和ggt分別為源數(shù)據(jù)用戶(hù)和目標(biāo)用戶(hù)。create user ggs identified by ggs default tablespace users。grant connect,resource to ggs。create user ggt identified by ggt default tablespace users。grant connect,resource to ggt。建立GG使用的用戶(hù)gg。create user gg identified by gg default tablespace users。grant dba to gg。2. 下載安裝GoldenGate需要到，我不太明白的是為什么這個(gè)GG的Product Pack是Oracle Fusion Middleware，另外，所以Platform我選擇了Linux x86，下載文件大約27M。為了簡(jiǎn)單，我直接使用操作系統(tǒng)的oracle用戶(hù)安裝GG。建立目錄/home/oracle/ggs，把下載的文件unzip，然后存放到這個(gè)目錄后執(zhí)行：tar xvof 這樣，/home/oracle/ggs就是我們的GG的目錄了。這時(shí)候我們進(jìn)入ggs目錄，執(zhí)行g(shù)gsci可能會(huì)報(bào)找不到庫(kù)的錯(cuò)誤，那是我們還沒(méi)有配置LIB，對(duì)于我這個(gè)系統(tǒng)，：LD_LIBRARY_PATH=/home/oracle/ggs:/u01/app/oracle/product/:$LD_LIBRARY_PATH。 export LD_LIBRARY_PATHPATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:/home/oracle/ggs。 export PATH運(yùn)行’. .bash_profile’，或者重新登入oracle，再執(zhí)行g(shù)gsci，就可以進(jìn)入ggsci的管理界面，可以運(yùn)行GG的命令了。這時(shí)，首先要做的就是建立GG的工作目錄，我們運(yùn)行：CREATE SUBDIRS（這一步最好在cd到/home/oracle/ggs，然后運(yùn)行g(shù)gsci后執(zhí)行，別的地方建立的環(huán)境有問(wèn)題，我還是初學(xué)，應(yīng)該有配置的方法，暫時(shí)不懂)運(yùn)行完畢，就生成了許多目錄，這是GG配置文件，日志等文件的存放目錄。3. 配置最簡(jiǎn)單的實(shí)驗(yàn)本次測(cè)試模擬的情況是：為了把ggs模式下的表中的數(shù)據(jù)變化同步到ggt模式的相關(guān)表中。本次配置不在源端緩存數(shù)據(jù)，直接把extract進(jìn)程抓取的數(shù)據(jù)存儲(chǔ)在目標(biāo)端數(shù)據(jù)庫(kù)服務(wù)器上，然后目標(biāo)端數(shù)據(jù)庫(kù)服務(wù)器的Replicat進(jìn)程把隊(duì)列中的數(shù)據(jù)投遞到目標(biāo)數(shù)據(jù)庫(kù)中。相關(guān)配置命令和參數(shù)如下:添加相關(guān)進(jìn)程：ADD EXTRACT ext1 TRANLOG, BEGIN NOWADD rmttrail /home/oracle/ggs/dirdat/r1 extract ext1ADD replicat rep1 EXTTRAIL /home/oracle/ggs/dirdat/r1, nodbcheckpoint運(yùn)行edit param mgr，然后保存文件內(nèi)容如下：port 7809運(yùn)行edit param ext1 ，然后保存文件內(nèi)容如下：extract ext1userid gg,password ggrmthost , mgrport 7809rmttrail /home/oracle/ggs/dirdat/r1dynamicresolutiontable ggs.*。運(yùn)行edit param rep1，然后保存文件內(nèi)容如下：replicat rep1userid gg,password ggassumetargetdefsmap ggs.*, target ggt.*。然后啟動(dòng)必要的進(jìn)程：start mgrstart ext1start rep1這時(shí)可以運(yùn)行info all來(lái)查看是否所有的進(jìn)程都是正常運(yùn)行：GGSCI info allProgram Status Group Lag Time Since ChkptMANAGER RUNNINGEXTRACT RUNNING EXT1 00:00:00 00:00:07REPLICAT RUNNING REP1 00:00:00 00:00:084. 測(cè)試同步使用sqlplus執(zhí)行SQL語(yǔ)句：create table (a number, CONSTRAINT pk1 PRIMARY KEY (a)) 。create table (a number, CONSTRAINT pk1 PRIMARY KEY (a)) 。然后運(yùn)行:insert into values (1)。mit。？26