ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 【GoldenGate】GoldenGate安装与配置后的启动

【GoldenGate】GoldenGate安装与配置后的启动

原创 Linux操作系统 作者:landf 时间:2013-09-09 15:39:46 0 删除 编辑

系统环境

源端:

OS: RedHat Linux 6.3 64-bit

DB: Oracle Database 11gR2(11.2.0.1)

IP: 192.168.1.226

同步表名: scott.ggtest

 

目标端:

OS: RedHat Linux 6.3 64-bit

DB: Oracle Database 11gR2(11.2.0.1)

IP: 192.168.1.228

同步表: scott.gg_test
复制架构图


一、停止Gold Gate复制

①停止Capture(在源端)

②停止Data Pump(在源端)

③停止Replicat(在目标端)

1,源端:

GGSCI (zjtdbrac1) 4> stop mgr

Manager process is required by other GGS processes.

Are you sure you want to stop it (y/n)? y

 

Sending STOP request to MANAGER ...

Request processed.

Manager stopped.

 

 

GGSCI (zjtdbrac1) 5> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     STOPPED                                           

EXTRACT     RUNNING     EORA        00:00:00      00:00:10   

EXTRACT     RUNNING     PUMP_SO     00:00:00      00:00:09   

 

GGSCI (zjtdbrac1) 6> stop eora

Sending STOP request to EXTRACT EORA ...

Request processed.

 

 

GGSCI (zjtdbrac1) 7> stop pump_so

Sending STOP request to EXTRACT PUMP_SO ...

Request processed.

 

 

2,目标端:

GGSCI (zjtdbrac2) 11> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          

REPLICAT    RUNNING     PORA        00:00:00      00:00:00   

 

 

GGSCI (zjtdbrac2) 12> stop mgr

Manager process is required by other GGS processes.

Are you sure you want to stop it (y/n)? y

Sending STOP request to MANAGER ...

Request processed.

Manager stopped.

 

 

GGSCI (zjtdbrac2) 13> stop pora

Sending STOP request to REPLICAT PORA ...

Request processed.

 

 

二、启动Gold Gate复制

  启动Capture(在源端)

  启动Data Pump(在源端)

  启动Replicat(在目标端)

1,源端:

GGSCI (zjtdbrac1) 4> start mgr

Manager started.

 

GGSCI (zjtdbrac1) 11> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           

EXTRACT     STOPPED     EORA        00:00:00      00:02:55   

EXTRACT     STOPPED     PUMP_SO     00:00:00      00:02:52  

 

 

GGSCI (zjtdbrac1) 12> start eora

Sending START request to MANAGER ...

EXTRACT EORA starting

 

GGSCI (zjtdbrac1) 13> start pump_so

Sending START request to MANAGER ...

EXTRACT PUMP_SO starting

 

GGSCI (zjtdbrac1) 14> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          

EXTRACT     RUNNING     EORA        00:00:00      00:00:06   

EXTRACT     RUNNING     PUMP_SO     00:00:00      00:03:36   

 

 

2,目标端:

GGSCI (zjtdbrac2) 29> start mgr

Manager started.

 

GGSCI (zjtdbrac2) 30> start pora

Sending START request to MANAGER ...

REPLICAT PORA starting

 

GGSCI (zjtdbrac2) 31> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          

REPLICAT    RUNNING     PORA        00:00:00      00:00:01 

  

 

三、配置的查询

• 查询配置的主要命令

• 查询配置与状态:INFO命令

• 查询处理情况:VIEW REPORT命令

GGSCI> INFO > [detail]

GGSCI> VIEW REPORT >

GGSCI> STATS >

 

  

四、问题解决方案附录:

1,查询进程配置与状态

GGSCI (zjtdbrac1) 12> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          

EXTRACT     RUNNING     EORA        00:00:00      00:00:09   

EXTRACT     RUNNING     PUMP_SO     00:00:00      00:00:03   

EXTRACT进程EORA状态会变为stopped

 

2,查看日志ggserr.log

[oracle@zjtdbrac1 ogg]$ vi ggserr.log

……

2013-09-09 14:21:09  WARNING OGG-01423  Oracle GoldenGate Capture for Oracle, eora.prm:  No valid default archive log destination directory found for thread 1.

2013-09-09 14:21:09  INFO    OGG-01513  Oracle GoldenGate Capture for Oracle, eora.prm:  Positioning to Sequence 342, RBA 7293456, SCN 0.9316209.

2013-09-09 14:22:22  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, eora.prm:  Could not find archived log for sequence 342 thread 1 under default destinations SQL   name    FROM v$archived_log   WHERE sequence# = :ora_seq_no AND         thread# = :ora_thread AND         resetlogs_id = :ora_resetlog_id AND         archived = 'YES' AND         deleted = 'NO' AND         name not like '+%'         AND standby_dest = 'NO' >, error retrieving redo file name for sequence 342, archived = 1, use_alternate = 0Not able to establish initial position for sequence 342, rba 7293456.

2013-09-09 14:22:22  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, eora.prm:  PROCESS ABENDING.

……

 

3,重新删除、添加、启动extract进程

Consider the earliest Recovery checkpoint timestamp to begin the extract
ggsci> delete ext

ggsci> add extract ext TRANLOG, THREADS 3, BEGIN {Earliest Recovery Checkpiont timestamp taken in step2}

ggsci> add exttrail {path}, extract ext, megabytes XXX

ggsci> start ext

 

GGSCI (zjtdbrac1) 2> dblogin userid ggs,password ggs

Successfully logged into database.

 

GGSCI (zjtdbrac1) 7> delete extract eora

ERROR: EXTRACT EORA does not exist.

 

GGSCI (zjtdbrac1) 9> add extract eora,tranlog,begin now

EXTRACT added.

 

 

GGSCI (zjtdbrac1) 10> add exttrail ./dirdat/et,extract eora

EXTTRAIL added.

 

 

GGSCI (zjtdbrac1) 11> start eora

 

Sending START request to MANAGER ...

EXTRACT EORA starting

1.jpg

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14359/viewspace-772407/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-02-14

  • 博文量
    68
  • 访问量
    492470