OGG数据仓库以及单向复制（一）

Item	Source System	Target System
Platform	OEL5.4	OEL5.4
Hostname	gc1	oraclelinux54.cuug.net
Database	Oracle 10.2.0.5	Oracle 11.2.0.3
Character Set	Zhs16gbk	Zhs16gbk
ORACLE_SID	PROD	TDB112
Listener Name/Port	LISTENER/1521	LISTENER/1521
Goldengate User	ogg	ogg

确保两个数据库的字符集一致，防止传输出现乱码

1. Install Goldengate 11g on      Linux--------------------------------------------------------------------

1.1Create install directory and unzip downloaded file on both system

 

For source system(gc2):

[oracle@gc1:/home/oracle]$mkdir -p /u01/app/ogg

[oracle@gc1:/home/oracle]$cp V18156-01-linux.zip /u01/app/ogg

[oracle@gc1:/home/oracle]$cd /u01/app/ogg

[oracle@gc1:/u01/app/ogg]$unzip V18156-01-linux.zip

[oracle@gc1:/u01/app/ogg]$tar -xvf ggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar

 

For target system(oraclelinux54.cuug.net):

[oracle@oraclelinux54.cuug.net:/u01]$mkdir -p /u01/app/ogg

[oracle@oraclelinux54.cuug.net:/home/oracle]$cp V18156-01-linux.zip /u01/app/ogg

[oracle@oraclelinux54.cuug.net:/home/oracle]$cd /u01/app/ogg

[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$unzip V18156-01-linux.zip

[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$tar -xvf ggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar

1.2Create sub working directories for Goldengate

For both Source system and Target system:

[oracle@~]$ vi .bash_profile

 export  LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib

 export  LD_LIBRARY_PATH=$ORACLE_HOME/lib

[oracle@oraclelinux54.cuug.net:/home/oracle]$cd /u01/app/ogg

[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$./ggsci

./ggsci: error while loading shared libraries: libnnz10.so: cannot open shared object file: No such file or directory

[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$cd $ORACLE_HOME/lib

[oracle@oraclelinux54.cuug.net:/u01/app/oracle/product/11.2.0/dbhome_1/lib]$ ln -s  libnnz11.so  libnnz10.so   //建立一个链接，让 libnnz10.so指向libnnz11.so

[oracle@oraclelinux54.cuug.net:/u01/app/oracle/product/11.2.0/dbhome_1/lib]$cd /u01/app/ogg

[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$./ggsci

 

Oracle GoldenGate Command Interpreter for Oracle

Version 10.4.0.19 Build 002

Linux, x86, 32bit (optimized), Oracle 10 on Sep 17 2009 23:49:42

 

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

 

 

 

GGSCI (oraclelinux54.cuug.net) 1> create subdirs         //在当前路径下创建

 

Creating subdirectories under current directory /u01/app/ogg

 

Parameter files                /u01/app/ogg/dirprm: created       //参数文件

Report files                   /u01/app/ogg/dirrpt: created

Checkpoint files               /u01/app/ogg/dirchk: created      //检查点文件，支持断点续传，知道哪些文件被传输，哪些没有

Process status files           /u01/app/ogg/dirpcs: created

SQL script files               /u01/app/ogg/dirsql: created

Database definitions files     /u01/app/ogg/dirdef: created

Extract data files             /u01/app/ogg/dirdat: created

Temporary files                /u01/app/ogg/dirtmp: created

Veridata files                 /u01/app/ogg/dirver: created

Veridata Lock files            /u01/app/ogg/dirver/lock: created

Veridata Out-Of-Sync files     /u01/app/ogg/dirver/oos: created

Veridata Out-Of-Sync XML files /u01/app/ogg/dirver/oosxml: created

Veridata Parameter files       /u01/app/ogg/dirver/params: created

Veridata Report files          /u01/app/ogg/dirver/report: created

Veridata Status files          /u01/app/ogg/dirver/status: created

Veridata Trace files           /u01/app/ogg/dirver/trace: created

Stdout files                   /u01/app/ogg/dirout: created

Above directories are created for following purpose:

Name	Purpose
dirchk	Checkpoint files
dirdat	GoldenGate trails
dirdef	Data definition files
dirprm	Parameter files
dirpcs	Process status files
dirrpt	Report files
dirsql	SQL script files
dirtmp	Temporary files

1. Introduction to the Command      Interface---------------------------------------------------------

• View HELP summary for all      commands

GGSCI> HELP

GGSCI> HELP ALL

• View HELP summary for a      COMMAND/ENTITY

GGSCI> HELP ADD EXTRACT

GGSCI> HELP ADD EXTTRAIL