[Oracle 11g r2(11.2.0.4.0)]Oracle Golden Gate Training-workshop1

####learn by doing,less theory,more results.
####install configure:

###sourece 源端：
extract：负责读取数据库redolog,archivelog…
trail:本地磁盘文件，主要存储extract 传输过来的数据
data pump：负责从trail 读取数据，传输到远端

###target 目标端：
clinct ：负责接收源端发送的数据
trail:目标端的本地磁盘文件，负责存储cliect 接收的数据
replicat:目标端进程，读取trail数据，写到目标端数据库。

###env:
####source :
ip：10.37.2.133
db:oracle 11g r2(11.2.0.4.0)
db_name:source
ogg:fbo_ggs_Linux_x64_ora11g_64bit.tar

####target:
ip:10.37.2.254
db:oracle 11g r2(11.2.0.4.0)
db_name:target
ogg:fbo_ggs_Linux_x64_ora11g_64bit.tar

OGG单向DML 同步：

###ogg安装：（source,target都需要执行）

####1 、 vi ~/.bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_SID=jhdb
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export OGG_HOME=/u01/gg
export ORACLE_UNQNAME=devdb
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH:$OGG_HOME
export PATH=$ORACLE_HOME/bin:$PATH:$OGG_HOME
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export EDITOR=vi
export LANG=en_US
export NLS_LANG=american_america.AL32UTF8
export NLS_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss'
umask 022

####2 、创建相关目录

[oracle@localhost gg]$ 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 11g on Apr 23 2012 08:32:14

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.



GGSCI (localhost.localdomain) 1> create subdirs

Creating subdirectories under current directory /u01/gg

Parameter files                /u01/gg/dirprm: already exists
Report files                   /u01/gg/dirrpt: created
Checkpoint files