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

系统环境

源端:

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14359/viewspace-772407/