ogg

oracle gOLDENgATE安装测试


一、    在源数据库操作系统上新增goldengate的用户，需要和ORACLE数据库用户在一个组：
[root@rhdb-1 ~]# useradd -g oinstall -g dba -s /bin/bash -d /home/ogg ogg
[root@rhdb-1 ~]# cp /home/oracle/.bash_profile /home/ogg/
cp: overwrite '/home/ogg/.bash_profile'? y
[root@rhdb-1 ~]# 
[root@rhdb-1 ~]# 
[root@rhdb-1 ~]# chmod 750 /home/oracle 


二、    在源数据库的操作系统上安装goldengate软件
[root@rhdb-1 ~]# su ?c ogg
[ogg@rhdb-1 ~]$ ls
ogg112101_fbo_ggs_linux_x64_ora10g_64bit.zip
[ogg@rhdb-1 ~]$ unzip ogg112101_fbo_ggs_linux_x64_ora10g_64bit.zip 
archive:  ogg112101_fbo_ggs_linux_x64_ora10g_64bit.zip
  inflating: fbo_ggs_linux_x64_ora10g_64bit.tar  
  inflating: ogg_winunix_rel_notes_11.2.1.0.1.pdf  
  inflating: oracle goldengate 11.2.1.0.1 readme.txt  
  inflating: oracle goldengate 11.2.1.0.1 readme.doc  
[ogg@rhdb-1 ~]$
[ogg@rhdb-1 ~]$ tar xf fbo_ggs_linux_x64_ora10g_64bit.tar
[ogg@rhdb-1 ~]$ mkdir fbo_ggs_linux_x64_ora10g_64bit     
[ogg@rhdb-1 ~]$ mv fbo_ggs_linux_x64_ora10g_64bit.tar fbo_ggs_linux_x64_ora10g_64bit/
[ogg@rhdb-1 ~]$ cd fbo_ggs_linux_x64_ora10g_64bit/
[ogg@rhdb-1 fbo_ggs_linux_x64_ora10g_64bit]$ ls
fbo_ggs_linux_x64_ora10g_64bit.tar
[ogg@rhdb-1 fbo_ggs_linux_x64_ora10g_64bit]$ tar xf fbo_ggs_linux_x64_ora10g_64bit.tar
[ogg@rhdb-1 fbo_ggs_linux_x64_ora10g_64bit]$ ./ggsci 


oracle goldengate command interpreter for oracle
version 11.2.1.0.1 oggcore_11.2.1.0.1_platforms_120423.0230_fbo
linux, x64, 64bit (optimized), oracle 10g on apr 23 2012 07:30:46
copyright (c) 1995, 2012, oracle and/or its affiliates. all rights reserved.
ggsci (rhdb-1) 1> create subdirs
creating subdirectories under current directory /home/ogg/fbo_ggs_linux_x64_ora10g_64bit
parameter files                /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirprm: already exists
report files                   /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirrpt: created
checkpoint files               /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirchk: created
process status files           /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirpcs: created
sql script files               /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirsql: created
database definitions files     /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirdef: created
extract data files             /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirdat: created
temporary files                /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirtmp: created
stdout files                   /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirout: created
ggsci (rhdb-1) 2> exit
[ogg@rhdb-1 fbo_ggs_linux_x64_ora10g_64bit]$


三、    设置源数据库为归档模式，回收站为OFF（设置ddl复制需要），并设置为最细LOG模式
idle> startup mount;
idle> alter database archivelog;
database altered.
idle> select log_mode from v$database;
log_mode
------------
archivelog
idle> alter database open;
sys@rhdb> alter system  set recyclebin=off scope=both;
sys@rhdb> select supplemental_log_data_min from v$database;
suppleme
--------
no
sys@rhdb> alter database add supplemental log data;
database altered.
sys@rhdb>  select supplemental_log_data_min from v$database;
suppleme
--------
yes


四、    在源数据库上创建gOLDENgATE的账号，并赋权限


[ogg@rhdb-1 fbo_ggs_linux_x64_ora10g_64bit]$ sqlplus '/as sysdba'
sql*plus: release 10.2.0.5.0 - production on wed may 30 15:02:05 2012
copyright (c) 1982, 2010, oracle.  all rights reserved.
connected to an idle instance.
idle> startup
oracle instance started.
total system global area  608174080 bytes
fixed size                  2098176 bytes
variable size             192941056 bytes
database buffers          406847488 bytes
redo buffers                6287360 bytes
database mounted.
database opened.
idle> exit
sys@rhdb> create tablespace ts_ogg datafile '/data/rhdb/rhdb/ogg01.dbf' size 50m autoextend on next 50m maxsize 2000m;
tablespace created.
sys@rhdb> create user gate01 identified by gate01 default tablespace ts_ogg  temporary tablespace temp quota unlimited on ts_ogg;
user created.
sys@rhdb> grant connect,resource,dba  to gate01;
grant succeeded.
sys@rhdb> @marker_setup.sql;
sys@rhdb> @ddl_setup.sql;
sys@rhdb> @role_setup.sql;
sys@rhdb> grant ggs_ggsuser_role to gate01;
sys@rhdb> @ddl_enable.sql;
sys@rhdb> conn gate01/gate01


五、    在目的主机db2上新增gOLDENgATE的用户，需要和ORACLE数据库用户在一个组：
[root@rhdb-2 ~]# useradd -g oinstall -g dba -s /bin/bash -d /home/ogg ogg
[root@ rhdb-2 ~]# cp /home/oracle/.bash_profile /home/ogg/
cp: overwrite '/home/ogg/.bash_profile'? y
[root@rhdb-2 ~]# 
[root@rhdb-2 ~]# 
[root@rhdb-2~]# chmod 750 /home/oracle


六、    在目的主机db2上安装gOLDENgATE软件
[root@rhdb-2~]# su ?c ogg
[ogg@rhdb-2~]$ ls
ogg112101_fbo_ggs_linux_x64_ora10g_64bit.zip
[ogg@rhdb-2 ~]$ unzip ogg112101_fbo_ggs_linux_x64_ora10g_64bit.zip 
archive:  ogg112101_fbo_ggs_linux_x64_ora10g_64bit.zip
  inflating: fbo_ggs_linux_x64_ora10g_64bit.tar  
  inflating: ogg_winunix_rel_notes_11.2.1.0.1.pdf  
  inflating: oracle goldengate 11.2.1.0.1 readme.txt  
  inflating: oracle goldengate 11.2.1.0.1 readme.doc  
[ogg@rhdb-2 ~]$
[ogg@rhdb-2 ~]$ tar xf fbo_ggs_linux_x64_ora10g_64bit.tar
[ogg@rhdb-2 ~]$ mkdir fbo_ggs_linux_x64_ora10g_64bit     
[ogg@rhdb-2 ~]$ mv fbo_ggs_linux_x64_ora10g_64bit.tar fbo_ggs_linux_x64_ora10g_64bit/
[ogg@rhdb-2 ~]$ cd fbo_ggs_linux_x64_ora10g_64bit/
[ogg@rhdb-2 fbo_ggs_linux_x64_ora10g_64bit]$ ls
fbo_ggs_linux_x64_ora10g_64bit.tar
[ogg@rhdb-2 fbo_ggs_linux_x64_ora10g_64bit]$ tar xf fbo_ggs_linux_x64_ora10g_64bit.tar
[ogg@rhdb-2 fbo_ggs_linux_x64_ora10g_64bit]$ ./ggsci 


oracle goldengate command interpreter for oracle
version 11.2.1.0.1 oggcore_11.2.1.0.1_platforms_120423.0230_fbo
linux, x64, 64bit (optimized), oracle 10g on apr 23 2012 07:30:46
copyright (c) 1995, 2012, oracle and/or its affiliates. all rights reserved.
ggsci (rhdb-2) 1> create subdirs
creating subdirectories under current directory /home/ogg/fbo_ggs_linux_x64_ora10g_64bit
parameter files                /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirprm: already exists
report files                   /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirrpt: created
checkpoint files               /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirchk: created
process status files           /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirpcs: created
sql script files               /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirsql: created
database definitions files     /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirdef: created
extract data files             /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirdat: created
temporary files                /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirtmp: created
stdout files                   /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirout: created
ggsci (rhdb-2) 2> exit
[ogg@rhdb-2 fbo_ggs_linux_x64_ora10g_64bit]$


七、    设置目的数据库为归档模式，回收站为OFF（设置ddl复制需要），并设置为最细LOG模式
IDLE> STARTUP MOUNT;
IDLE> ALTER DATABASE ARCHIVELOG;
dATABASE ALTERED.
IDLE>  SELECT LOG_MODE FROM V$DATABASE;
log_mode
------------
archivelog
IDLE> ALTER DATABASE OPEN;
SYS@rhdb2> ALTER SYSTEM  SET recyclebin=OFF SCOPE=BOTH;
SYS@rhdb2> SELECT supplemental_log_data_min FROM V$DATABASE;
suppleme
--------
no
SYS@rhdb2> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
dATABASE ALTERED.
SYS@rhdb2>  SELECT supplemental_log_data_min FROM V$DATABASE;
suppleme
--------
yes
    
八、    在目的数据库上创建gOLDENgATE的账号，并赋权限
sys@rhdb2> create tablespace ts_ogg datafile '/data/rhdb/rhdb/ogg01.dbf' size 50m autoextend on next 50m maxsize 2000m;
tablespace created.
sys@rhdb2> create user gate01 identified by gate01 default tablespace ts_ogg  temporary tablespace temp quota unlimited on ts_ogg;
user created.
sys@rhdb2> grant connect,resource,dba  to gate01;
grant succeeded.
sys@rhdb2> alter system  set recyclebin=off scope=both;
sys@rhdb2> @marker_setup.sql;
sys@rhdb2> @ddl_setup.sql;
sys@rhdb2> @role_setup.sql;
sys@rhdb2> grant ggs_ggsuser_role to gate01;
sys@rhdb2> @ddl_enable.sql;
sys@rhdb2> conn gate01/gate01


九、    在源数据库上创建测试账号
sys@rhdb> create user sender identified by oracle default tablespace users;
user created.
sys@rhdb> grant connect,resource,unlimited tablespace to sender;
grant succeeded.
sys@rhdb>


十、    在目的数据库上创建测试账号
sys@rhdb2> create user receiver identified by oracle default tablespace users;
user created.
sys@rhdb2> grant connect,resource,unlimited tablespace to receiver;
grant succeeded.






























十一、    配置ggs的MANAGER
1、    创建MANAGER，需要在源端和目标端分别执行如下步骤
[ogg@rhdb-2 fbo_ggs_linux_x64_ora10g_64bit]$ ./ggsci
oracle goldengate command interpreter for oracle
version 11.2.1.0.1 oggcore_11.2.1.0.1_platforms_120423.0230_fbo
linux, x64, 64bit (optimized), oracle 10g on apr 23 2012 07:30:46
copyright (c) 1995, 2012, oracle and/or its affiliates. all rights reserved.
ggsci (rhdb-2) 1> info all
program     status      group       lag at chkpt  time since chkpt
manager     stopped                                           
ggsci (rhdb-2) 2> edit params mgr
port 7809
"dirprm/mgr.prm" [new] 1l, 10c written
ggsci (rhdb-2) 3> start manager
manager started.
ggsci (rhdb-2) 4> exit


2、    配置源端复制队列
ggsci (rhdb-1) 1> add extract ext1,tranlog,begin now
extract added.
ggsci (rhdb-1) 2> add exttrail /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirdat/lt, extract ext1
exttrail added.
ggsci (rhdb-1) 3> edit params ext1
extract ext1
userid gate01@rhdb1, password gate01
rmthost 192.168.1.78, mgrport 7809
rmttrail /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirdat/lt
ddl include mapped objname sender.*;
table sender.*;
"dirprm/ext1.prm" [new] 6l, 198c written--------------------------------
ggsci (rhdb-1) 4> info all
program     status      group       lag at chkpt  time since chkpt
manager     running                                           
extract     stopped     ext1        00:00:00      00:03:58   


3、    配置目标端同步队列
1、    在目标端添加CHECKPOINT表
ggsci (rhdb-2) 1> edit params global
ggschema gate01
checkpointtable gate01.checkpoint
"dirprm/global.prm" [new] 2l, 50c written
ggsci (rhdb-2) 8> dblogin userid gate01@rhdb2,password gate01
successfully logged into database.
ggsci (rhdb-2) 9> add checkpointtable gate01.checkpoint
successfully created checkpoint table gate01.checkpoint.


2、    创建同步队列
ggsci (rhdb-2) 10> add replicat rep1, exttrail /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirdat/lt, checkpointtable gate01.checkpoint
replicat added.
ggsci (rhdb-2) 11> edit params rep1
replicat rep1
assumetargetdefs
userid gate01@rhdb2, password gate01
discardfile /home/ogg/fbo_ggs_linux_x64_ora10g_64bit/dirdat/rep1_discard.txt,append,megabytes 10
ddl
map sender.*, target receiver.*;
"dirprm/rep1.prm" [new] 6l, 204c written


4、    分别在源端和目标端上开启同步
ggsci (rhdb-1) 1> start extract ext1
sending start request to manager ...
extract ext1 starting
ggsci (rhdb-1) 2> info all
program     status      group       lag at chkpt  time since chkpt
manager     running                                           
extract     stopped     ext1        00:00:00      02:03:24    
ggsci (rhdb-2) 14> start manager
manager started.
ggsci (rhdb-2) 15> start replicat rep1
sending start request to manager ...
replicat rep1 starting


十二、    验证结果


：总结-------------------------------
1  ogg 是区别与Oracle的数据库数据服务软件
2  数据库准备，特定的用户，特定需求（归档，强制日记）
3  mgr  ext  rep,生成日志！ 

4  常用命令!info all.start manager,start extrace ext1,start replicat rep1