linux下搭建oracle ogg的過(guò)程

145次閱讀

共計(jì) 9128 個(gè)字符，預(yù)計(jì)需要花費(fèi) 23 分鐘才能閱讀完成。

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

原庫(kù)：
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)庫(kù)：
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;

原庫(kù)和目標(biāo)庫(kù):
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;

原庫(kù)和目標(biāo)庫(kù):
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：
補(bǔ)丁程序與更新程序 –》產(chǎn)品【Oracle GoldenGate】–》發(fā)行版【GGATE 11.1.1.1.0~20】–》平臺(tái)【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)閉

啟動(dòng) 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ù)庫(kù)類型可能需要用到。
–[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 #確保為空

編輯源庫(kù)抽取進(jìn)程參數(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;

# 編輯源庫(kù)投遞進(jìn)程參數(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)庫(kù)：
[oracle@host03 ogg]$ cat /dev/null ./dirrpt/repecom.dsc
[oracle@host03 ogg]$ cat /dev/null ./dirrpt/rinecom.dsc

# 創(chuàng)建目標(biāo)庫(kù)初始化裝載進(jìn)程參數(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;

添加進(jìn)程
[oracle@host03 ogg]$ pwd
/u01/app/ogg
[oracle@host03 ogg]$ mkdir dirchk
抽取進(jìn)程：
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

投遞進(jìn)程：
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ù)制進(jìn)程：
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 ## 因?yàn)槟夸洸煌容^好
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

啟動(dòng)進(jìn)程：
[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

測(cè)試咯
原庫(kù)：
sqlplus usera/usera
select * from test1; #無(wú)記錄
insert into test1 select * from dba_objects where rownum
commit;
select * from test1; #一條記錄

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

查看 ogg 進(jìn)程：
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 的過(guò)程”的學(xué)習(xí)就結(jié)束了，希望能夠解決大家的疑惑。理論與實(shí)踐的搭配能更好的幫助大家學(xué)習(xí)，快去試試吧！若想繼續(xù)學(xué)習(xí)更多相關(guān)知識(shí)，請(qǐng)繼續(xù)關(guān)注丸趣 TV 網(wǎng)站，丸趣 TV 小編會(huì)繼續(xù)努力為大家?guī)?lái)更多實(shí)用的文章！

正文完