installation of goldengate for unix
1 设置环境变量
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/product/OraHome
export ORACLE_SID=ggsource
export ORACLE_OWNER=oracle
export ORACLE_TERM=vt100
# export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
export PATH=$ORACLE_HOME/bin:$ORACLE_BASE/gg11:$PATH=$PATH:$HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_BASE/gg11

2 创建目录
[oracle@ggsource oracle]$ mkdir gg11

3 extract the files
[oracle@ggsource ~]$ unzip V26188-01.zip
[oracle@ggsource ~]$ mv fbo_ggs_Linux_x86_ora11g_32bit.tar /u01/oracle/gg11
[oracle@ggsource gg11]$tar -xvof fbo_ggs_Linux_x86_ora11g_32bit.tar

4 进入相关的目录
[oracle@ggsource gg11]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1 OGGCORE_11.1.1_PLATFORMS_110421.2040
Linux, x86, 32bit (optimized), Oracle 11g on Apr 21 2011 22:38:06

GGSCI (ggsource) 1>

5 创建目录
GGSCI (ggsource) 1> create subdirs

Creating subdirectories under current directory /u01/oracle/gg11

6 把数据库设置为归档模式
SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     5
Current log sequence           7
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 422670336 bytes
Fixed Size                  1336960 bytes
Variable Size             272632192 bytes
Database Buffers          142606336 bytes
Redo Buffers                6094848 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.
SQL> alter system set log_archive_dest_1='location=/u01/oracle/archive' scope=both;

System altered.

SQL> alter database open;

Database altered.

7 Oracle-specific installation steps (source)
SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;

SUPPLEME
--------
NO
SQL> alter database add supplemental log data;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;

SUPPLEME
--------
YES

8 创建用户
以上8步都是源端与目标端都要配置的步骤

9 Add supplemental logging(source)
GGSCI (ggsource) 1> dblogin userid gguser,password qilin
Successfully logged into database.

GGSCI (ggsource) 2> add trandata gguser.tcustmer

Logging of supplemental redo data enabled for table GGUSER.TCUSTMER.

GGSCI (ggsource) 3> add trandata scott.tcustord

Logging of supplemental redo data enabled for table GGUSER.TCUSTORD.

GGSCI (ggsource) 3> info trandata gguser.*

10 分别在源端与目标端配置MGR，且端口要相同
GGSCI (ggsource) 34> view params mgr

port 7809

GGSCI (ggtarget) 82> view params mgr

PORT 7809

第一部分在源端的配置（initial load）
1 Add the initial load capture batch task group
GGSCI (ggsource) 2> add extract einiyu,sourceistable
EXTRACT added.

2
GGSCI (ggsource) 23> info extract *, tasks

EXTRACT    EINIYU    Last Started 2012-05-11 14:10   Status STOPPED
Checkpoint Lag       Not Available
Log Read Checkpoint Table GGUSER.TCUSTORD
                     2012-05-11 14:10:52 Record 2
Task                 SOURCEISTABLE

EXTRACT    EINTQI    Initialized   2012-05-08 17:46   Status STOPPED
Checkpoint Lag       Not Available
Log Read Checkpoint Not Available
                     First Record         Record 0
Task                 SOURCEISTABLE

3
GGSCI (ggsource) 4> edit params einiyu
extract einiyu
userid gguser,password qilin
rmthost 192.168.189.49,mgrport 7809
rmttask replicat,group rinisu
table gguser.tcustmer;
table gguser.tcustord;

GGSCI (ggsource) 24> view params einiyu

extract einiyu
userid gguser,password qilin
rmthost 192.168.189.49,mgrport 7809
rmttask replicat,group rinisu
table gguser.tcustmer;
table gguser.tcustord;

GGSCI (ggsource) 26> start extract einiyu

Sending START request to MANAGER ...
EXTRACT EINIYU starting

第二部分在源端的配置（change capture）
1
ADD EXTRACT EORAkk, TRANLOG, BEGIN NOW, THREADS 1

2
GGSCI (ggsource) 27> info extract *

EXTRACT    EORAKK    Last Started 2012-05-11 14:48   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:00 ago)
Log Read Checkpoint Oracle Redo Logs
                     2012-05-11 15:13:08 Thread 1, Seqno 18, RBA 6165008

3
GGSCI (ggsource) 28> edit params eorakk

EXTRACT EORAkk
USERID gguser, PASSWORD qilin
RMTHOST 192.168.189.49, MGRPORT 7809
RMTTRAIL ./dirdat/kk
TABLE gguser.TCUSTMER;
TABLE gguser.TCUSTORD;

4
GGSCI> ADD RMTTRAIL ./dirdat/kk, EXTRACT EORAkk, MEGABYTES 5

5
GGSCI (ggsource) 29> info rmttrail *

       Extract Trail: ./dirdat/kk
             Extract: EORAKK
               Seqno: 0
                 RBA: 3027
           File Size: 5M

6
GGSCI (ggsource) 31> start extract eorakk

7
GGSCI (ggsource) 30> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EORAKK 00:00:00 00:00:01

8
GGSCI (ggsource) 31> info extract eorakk, detail

EXTRACT    EORAKK    Last Started 2012-05-11 14:48   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint Oracle Redo Logs
                     2012-05-11 15:16:14 Thread 1, Seqno 18, RBA 6203904

Target Extract Trails:

Remote Trail Name Seqno RBA Max MB

./dirdat/kk 0 3027 5

Extract Source Begin End

/u01/oracle/oradata/ggsource/redo03.log 2012-05-11 14:28 2012-05-11 15:16
Not Available * Initialized * 2012-05-11 14:28

Current directory /u01/oracle/gg11

Report file          /u01/oracle/gg11/dirrpt/EORAKK.rpt
Parameter file       /u01/oracle/gg11/dirprm/eorakk.prm
Checkpoint file      /u01/oracle/gg11/dirchk/EORAKK.cpe
Process file         /u01/oracle/gg11/dirpcs/EORAKK.pce
Stdout file          /u01/oracle/gg11/dirout/EORAKK.out
Error log            /u01/oracle/gg11/ggserr.log

9
GGSCI (ggsource) 32>view report eroakk

10
GGSCI (ggsource) 32> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EORAKK 00:00:00 00:00:09

11 在源数据库端的表中插入数据
SQL> conn gguser/qilin
Connected.
SQL> @demo_ora_misc.sql

12 查询
SQL> select * from TCUSTMER;

CUST NAME                           CITY                 ST
---- ------------------------------ -------------------- --
DAVE DAVE'S PLANES INC.             TALLAHASSEE          FL
BILL BILL'S USED CARS               DENVER               CO
ANN ANN'S BOATS                    NEW YORK             NY
WILL BG SOFTWARE CO.                SEATTLE              WA
JANE ROCKY FLYER INC.               DENVER               CO

第一部分在目标端的部署（initial load）
1
GGSCI (ggtarget) 2> add replicat einisu,specialrun

2
GGSCI (ggtarget) 70> info replicat *,task

REPLICAT   EINTQI    Initialized   2012-05-09 15:52   Status STOPPED
Checkpoint Lag       00:00:00 (updated 47:10:41 ago)
Log Read Checkpoint Not Available
Task                 SPECIALRUN

REPLICAT   RINISU    Initialized   2012-05-10 15:38   Status STOPPED
Checkpoint Lag       00:00:00 (updated 23:24:02 ago)
Log Read Checkpoint Not Available
Task                 SPECIALRUN

3
GGSCI (ggtarget) 73> edit params rinisu

replicat rinisu
assumetargetdefs
userid gguser, password qilin
discardfile ./dirrpt/rinisu.dsc,purge
map gguser.*, target gguser.*;
~
4
GGSCI (ggtarget) 76> view params rinisu

replicat rinisu
assumetargetdefs
userid gguser, password qilin
discardfile ./dirrpt/rinisu.dsc,purge
map gguser.*, target gguser.*;

5
GGSCI (ggtarget) 77> view report rinisu

6 验证结果
select * from tcustmer;

第二部分在目标端的配置（change capture）
1
GGSCI (ggtarget) 77> edit params ./globals

checkpointtable gguser.ckeckpoint

2
GGSCI (ggtarget) 78> dblogin userid gguser, password qilin
Successfully logged into database.

3
GGSCI> ADD CHECKPOINTTABLE gguser.checkpoint

4
SQL> select object_name from user_objects;

5
add replicat rorakk,exttrail ./dirdat/kk
add replicat rorakk,exttrail ./dirdat/kk checkpointtable gguser.checkpoint

6
GGSCI (ggtarget) 79> edit params rorakk

replicat rorakk
userid gguser, password qilin
handlecollisions
assumetargetdefs
discardfile ./dirrpt/rorakk.dsc purge
map gguser.tcustmer, target gguser.tcustmer;
map gguser.tcustord, target gguser.tcustord;

7
start replicat rorakk

8
GGSCI (ggtarget) 80> info replicat *

REPLICAT   RORAKK    Last Started 2012-05-11 14:05   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint File ./dirdat/kk000000
                     2012-05-11 14:50:15.020496 RBA 3027
9
GGSCI (ggtarget) 81> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING
REPLICAT RUNNING RORAKK 00:00:00 00:00:01

10 验证结果

SQL> select * from TCUSTMER;

CUST NAME                           CITY                 ST
---- ------------------------------ -------------------- --
DAVE DAVE'S PLANES INC.             TALLAHASSEE          FL
BILL BILL'S USED CARS               DENVER               CO
ANN ANN'S BOATS                    NEW YORK             NY
WILL BG SOFTWARE CO.                SEATTLE              WA
JANE ROCKY FLYER INC.               DENVER               CO

ITPub博客

gg_install_first

最新文章