linux下搭建oracleogg的過程

這篇文章主要介紹“l(fā)inux下搭建oracle ogg的過程”，在日常操作中，相信很多人在linux下搭建oracle ogg的過程問題上存在疑惑，小編查閱了各式資料，整理出簡單好用的操作方法，希望對大家解答”linux下搭建oracle ogg的過程”的疑惑有所幫助！接下來，請跟著小編一起來學(xué)習(xí)吧！

創(chuàng)新互聯(lián)公司是一家專注于成都網(wǎng)站建設(shè)、網(wǎng)站設(shè)計與策劃設(shè)計,察隅網(wǎng)站建設(shè)哪家好?創(chuàng)新互聯(lián)公司做網(wǎng)站,專注于網(wǎng)站建設(shè)十載,網(wǎng)設(shè)計領(lǐng)域的專業(yè)建站公司;建站業(yè)務(wù)涵蓋:察隅等地區(qū)。察隅做網(wǎng)站價格咨詢:13518219792

原庫：
create user usera identified by usera;
grant resource ,connect,dba to usera;
create table usera.test1 as select * from dba_objects where 1=2;
alter table usera.test1 add constraint pk_test_table primary key(object_id) enable;
目標(biāo)庫：
create user userb identified by userb;
grant resource ,connect,dba to userb;
create table USERB.TEST2 as select * from dba_objects where 1=2;
alter table uSERB.TEST2 add constraint pk_test_table2 primary key(object_id) enable;

原庫和目標(biāo)庫:
create tablespace GOLDENGATE_DATASPACE datafile '/u01/app/oracle/oradata/mydb/GOLDENGATE_DATASPACE.dbf' size 2g;
create user goldengate identified by ggs_1234 default tablespace GOLDENGATE_DATASPACE temporary tablespace temp;
grant resource,connect,dba to goldengate;
grant unlimited tablespace to goldengate;

原庫和目標(biāo)庫:
SELECT SUPPLEMENTAL_LOG_DATA_MIN,FORCE_LOGGING FROM V$DATABASE; ####必須都為YES
ALTER SYSTEM SWITCH LOGFILE;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER SYSTEM SWITCH LOGFILE;
alter database force logging;
SELECT SUPPLEMENTAL_LOG_DATA_MIN,FORCE_LOGGING FROM V$DATABASE;

archive log list ###必須為歸檔模式
shutdown immediate
startup mount;
alter database archivelog;
alter database open;
archive log list

下載軟件support.oracle.com：
補丁程序與更新程序--》產(chǎn)品【Oracle GoldenGate】--》發(fā)行版【GGATE 11.1.1.1.0~20】--》平臺【Linux x86】
本環(huán)境是rhel5 32位：p13072170_111112_LINUX.zip

將ogg安裝在/u01/app/ogg下
[oracle@host03 ~]$ echo $ORACLE_BASE
/u01/app/oracle
su - oracle
cd /u01/app/
mkdir ogg
cd ogg
將p13072170_111112_LINUX.zip上傳到/u01/app/ogg/目錄下
unzip p13072170_111112_LINUX.zip
tar -xvf fbo_ggs_Linux_x86_ora11g_32bit.tar
[oracle@host03 ~]$ PWD
/u01/app/oracle/ogg
mkdir dirdat
mkdir dirrpt
mkdir dirprm
mkdir dirpcs
service iptables status確認(rèn)防火墻關(guān)閉
getenforce 確認(rèn)selinux關(guān)閉

啟動mgr：
cd /u01/app/ogg
./ggsci
info all
edit params mgr
######## [oracle@host03 dirprm]$ cat mgr.prm
########PORT 7809
########DYNAMICPORTLIST 7800-7810
########PURGEOLDEXTRACTS ./dirdat/*/*, USECHECKPOINTS, MINKEEPDAYS 7
########AUTOSTART ER *
########AUTORESTART ER *,RETRIES 5, WAITMINUTES 3, RESETMINUTES 30
########[oracle@host03 dirprm]$ pwd
########/u01/app/ogg/dirprm
EDIT PARAMS ./GLOBALS
########[oracle@host03 ogg]$ cat GLOBALS
########CHECKPOINTTABLE goldengate.ggschkpt
########[oracle@host03 ogg]$ pwd
########/u01/app/ogg
GGSCI (host03.example.com) 1> info all
Program Status Group Lag Time Since Chkpt
MANAGER STOPPED

GGSCI (host03.example.com) 2> start mgr
Manager started.

GGSCI (host03.example.com) 4> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING

目標(biāo)端添加checkpoint表
GGSCI (host03.example.com) 7> dblogin userid goldengate
Password:
Successfully logged into database.

GGSCI (host03.example.com) 8> ADD CHECKPOINTTABLE ggschkpt
Successfully created checkpoint table GGSCHKPT.

GGSCI (host03.example.com) 10> info trandata usera.test1
Logging of supplemental redo log data is disabled for table USERA.TEST1.

GGSCI (host03.example.com) 11> DELETE TRANDATA usera.test1
Logging of supplemental redo log data is already disabled for table USERA.TEST1.

GGSCI (host03.example.com) 12> ADD TRANDATA usera.test1
Logging of supplemental redo data enabled for table USERA.TEST1.

GGSCI (host03.example.com) 13> INFO TRANDATA usera.test1
Logging of supplemental redo log data is enabled for table USERA.TEST1

目標(biāo)端定義文件，不同數(shù)據(jù)庫類型可能需要用到。
--[oracle@host03 ogg]$ vi ./dirprm/defgen20160908.prm
--[oracle@host03 ogg]$ cat ./dirprm/defgen20160908.prm
--DEFSFILE ./dirdef/ecom20110908.def
--USERID GOLDENGATE, PASSWORD ggs_1234
--TABLE usera.test1;
--[oracle@host03 ogg]$ ./defgen parameter ./dirprm/defgen20160908.prm
--2017-09-17 23:39:11 ERROR OGG-00012 Command line error:invalid startup syntax: parameter.
--2017-09-17 23:39:11 ERROR OGG-01668 PROCESS ABENDING.

[oracle@host03 ogg]$ cat /dev/null> ./dirrpt/extecom.dsc
[oracle@host03 ogg]$ cat /dev/null> ./dirrpt/dppecom.dsc
[oracle@host03 ogg]$ cat /dev/null> ./dirrpt/iniecom.dsc
[oracle@host03 ogg]$ mkdir ./dirdat/ecom
[oracle@host03 ogg]$ cd dirdat/ecom/
[oracle@host03 ecom]$ ls #確保為空

編輯源庫抽取進程參數(shù)文件
[oracle@host03 ogg]$ pwd
/u01/app/ogg
[oracle@host03 ogg]$ vi ./dirprm/extecom.prm
############EXTRACT extecom
############SETENV (ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1")
############SETENV (ORACLE_SID="mydb")
############USERID goldengate, password ggs_1234
############
############discardfile ./dirrpt/extecom.dsc, append, megabytes 1000
############discardrollover at 3:00
############
############warnlongtrans 2h, checkinterval 3m
############
############EXTTRAIL ./dirdat/ecom/ss, megabytes 100
############NUMFILES 3000
############DYNAMICRESOLUTION
############EOFDELAYCSECS 10
############
############TABLE usera.test1;

#編輯源庫投遞進程參數(shù)文件
vi ./dirprm/dppecom.prm
############EXTRACT dppecom
############RMTHOST 192.168.56.101, MGRPORT 7809
############RMTTRAIL ./dirdat/target/rs
############DISCARDFILE ./dirrpt/dppecom.dsc, PURGE
############PASSTHRU
############DYNAMICRESOLUTION
############EOFDELAYCSECS 10
############
############TABLE usera.test1;

目標(biāo)庫：
[oracle@host03 ogg]$ cat /dev/null>./dirrpt/repecom.dsc
[oracle@host03 ogg]$ cat /dev/null>./dirrpt/rinecom.dsc

#創(chuàng)建目標(biāo)庫初始化裝載進程參數(shù)文件
vi ./dirprm/rinecom.prm
#########REPLICAT repecom
#########
#########SETENV (NLS_LANG= "american_america.ZHS16GBK")
#########SETENV (ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1")
#########SETENV (ORACLE_SID="mydb")
#########USERID goldengate, password ggs_1234
#########--SOURCEDEFS ./dirdef/ecom20110908.def
#########
#########ASSUMETARGETDEFS
#########--HANDLECOLLISIONS
#########
#########reperror default,discard
#########DISCARDFILE ./dirrpt/repecom.dsc, PURGE, megabytes 1000
#########
#########--EXTTRAIL ./dirdat/target/rs
#########
#########NUMFILES 150
#########DYNAMICRESOLUTION
#########ALLOWNOOPUPDATES
#########GROUPTRANSOPS 1000
#########
#########MAP USERA.TEST1, TARGET USERB.TEST2;

添加進程
[oracle@host03 ogg]$ pwd
/u01/app/ogg
[oracle@host03 ogg]$ mkdir dirchk
抽取進程：
GGSCI (host03.example.com) 15> ADD EXTRACT extecom, tranlog, begin now
EXTRACT added.

GGSCI (host03.example.com) 16> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXTECOM 00:00:00 00:00:03

GGSCI (host03.example.com) 18> ADD EXTTRAIL ./dirdat/ecom/ss, EXTRACT extecom, megabytes 100
EXTTRAIL added.

GGSCI (host03.example.com) 19> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXTECOM 00:00:00 00:00:39

投遞進程：
GGSCI (host03.example.com) 20> ADD EXTRACT dppecom, exttrailsource ./dirdat/ecom/ss
EXTRACT added.

GGSCI (host03.example.com) 21> ADD RMTTRAIL ./dirdat/target/rs, EXTRACT dppecom, megabytes 100
RMTTRAIL added.

GGSCI (host03.example.com) 22> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED DPPECOM 00:00:00 00:00:22
EXTRACT STOPPED EXTECOM 00:00:00 00:02:47

復(fù)制進程：
GGSCI (host03.example.com) 23> add replicat repecom, exttrail ./dirdat/ecom/ss
REPLICAT added.

GGSCI (host03.example.com) 24> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED DPPECOM 00:00:00 00:01:06
EXTRACT STOPPED EXTECOM 00:00:00 00:03:31
REPLICAT STOPPED REPECOM 00:00:00 00:00:18

GGSCI (host03.example.com) 30> delete replicat repecom ##因為目錄不同比較好
Deleted REPLICAT REPECOM.

GGSCI (host03.example.com) 31> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED DPPECOM 00:00:00 00:02:53
EXTRACT STOPPED EXTECOM 00:00:00 00:05:18

[oracle@host03 ogg]$ pwd
/u01/app/ogg
[oracle@host03 ogg]$ mkdir ./dirdat/target/

GGSCI (host03.example.com) 32> add replicat repecom, exttrail ./dirdat/target/rs
REPLICAT added.
GGSCI (host03.example.com) 33> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED DPPECOM 00:00:00 00:03:42
EXTRACT STOPPED EXTECOM 00:00:00 00:06:07
REPLICAT STOPPED REPECOM 00:00:00 00:00:02

啟動進程：
[oracle@host03 ogg]$ pwd
/u01/app/ogg
[oracle@host03 ogg]$ mkdir dirtmp
[oracle@host03 dirprm]$ mv rinecom.prm repecom.prm

GGSCI (host03.example.com) 52> start EXTECOM
Sending START request to MANAGER ...
EXTRACT EXTECOM starting

GGSCI (host03.example.com) 56> start DPPECOM
Sending START request to MANAGER ...
EXTRACT DPPECOM starting

GGSCI (host03.example.com) 57> start REPECOM
Sending START request to MANAGER ...
REPLICAT REPECOM starting

測試咯
原庫：
sqlplus usera/usera
select * from test1; #無記錄
insert into test1 select * from dba_objects where rownum<2;
commit;
select * from test1; #一條記錄

目標(biāo)庫：
sqlplus userb/userb
select * from test2; #一條記錄，說明同步成功。

查看ogg進程：
GGSCI (host03.example.com) 62> stats DPPECOM
Sending STATS request to EXTRACT DPPECOM ...
Start of Statistics at 2017-09-18 00:25:20.
Output to ./dirdat/target/rs:
Extracting from USERA.TEST1 to USERA.TEST1:
*** Total statistics since 2017-09-18 00:22:18 ***
Total inserts    1.00
Total updates    0.00
Total deletes    0.00
Total discards 0.00
Total operations 1.00

*** Daily statistics since 2017-09-18 00:22:18 ***
Total inserts    1.00
Total updates    0.00
Total deletes    0.00
Total discards 0.00
Total operations 1.00

*** Hourly statistics since 2017-09-18 00:22:18 ***
Total inserts    1.00
Total updates    0.00
Total deletes    0.00
Total discards 0.00
Total operations 1.00

*** Latest statistics since 2017-09-18 00:22:18 ***
Total inserts    1.00
Total updates    0.00
Total deletes    0.00
Total discards 0.00
Total operations 1.00

End of Statistics.

到此，關(guān)于“l(fā)inux下搭建oracle ogg的過程”的學(xué)習(xí)就結(jié)束了，希望能夠解決大家的疑惑。理論與實踐的搭配能更好的幫助大家學(xué)習(xí)，快去試試吧！若想繼續(xù)學(xué)習(xí)更多相關(guān)知識，請繼續(xù)關(guān)注創(chuàng)新互聯(lián)網(wǎng)站，小編會繼續(xù)努力為大家?guī)砀鄬嵱玫奈恼拢?/p>

網(wǎng)站欄目：linux下搭建oracleogg的過程
當(dāng)前地址：http://bm7419.com/article12/gosodc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供、App開發(fā)、網(wǎng)站策劃、Google、手機網(wǎng)站建設(shè)、關(guān)鍵詞優(yōu)化

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容