oracle 11.2.0.4 ogg 12.3.0.1.0备库rep进程启动报错OGG-00446

主备操作系统：rhel 6.6

数据库版本：oracle 11.2.0.4

ogg版本：12.3.0.1.0

今天教一新手使用oracle 11.2.0.4 ogg 12.3.0.1.0做数据同步，其部署过程不规范，备库未对goldengate用户做checkpoint表，导致备库的引用进程启动不了。

备库rep_hr进程的参数及状态如下：

rep_hr的参数：

GGSCI (ZB as goldengate@ora) 50> view param rep_hr
--eplicat group --
replicat rep_hr
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
--source and target definitions
ASSUMETARGETDEFS
HANDLECOLLISIONS
--target database login --
userid GOLDENGATE, password oracle
--file for dicarded transaction --
discardfile /u01/app/oracle/OGG/product/dirdat/rep_hr_discard.txt, append, megabytes 10
--ddl support DDL--
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE RETRYOP
--Specify table mapping ---
MAP hr.*,TARGET hr.t;

rep_hr的状态

GGSCI (ZB as goldengate@ora) 43> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
REPLICAT STOPPED REP_HR 00:00:00 00:11:10

GGSCI (ZB as goldengate@ora) 26> info rep_hr

REPLICAT REP_HR Initialized 2017-10-29 19:18 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:09:29 ago)
Log Read Checkpoint File /u01/app/oracle/OGG/product/dirdat/et000000000
First Record RBA 0

GGSCI (ZB as goldengate@ora) 27>

rep_hr启动报错信息如下：

2017-10-29T19:40:39.927+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start rep_hr.
2017-10-29T19:40:39.931+0800 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.21.129]:27254 (START REPLICAT REP_HR ).
2017-10-29T19:40:39.933+0800 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REP_HR starting.
2017-10-29T19:40:40.275+0800 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: REPLICAT REP_HR starting.
2017-10-29T19:40:40.280+0800 WARNING OGG-02904 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Replication of PARTIAL XML containing NCHAR/NVARCHAR/NCLOB data may cause divergence.
2017-10-29T19:40:40.280+0800 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Operating system character set identified as US-ASCII.
2017-10-29T19:40:40.282+0800 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: ANSI SQL parameter syntax is used for parameter parsing.
2017-10-29T19:40:40.284+0800 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.ZHS16GBK.
2017-10-29T19:40:41.443+0800 INFO OGG-06451 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Triggers will be suppressed by default.
2017-10-29T19:40:41.466+0800 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/app/oracle/OGG/product/dirtmp.
2017-10-29T19:40:41.490+0800 INFO OGG-06604 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Database ORA CPU info: CPU Count 4, CPU Core Count 4, CPU Socket Count 2.
2017-10-29T19:40:41.511+0800 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Checkpoint table GOLDENGATE.checkpoint does not exist. Create this table with the ADD CHECKPOINTTABLE command.
2017-10-29T19:40:41.511+0800 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: PROCESS ABENDING.
2017-10-29T19:41:23.633+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ADD CHECKPOINTTABLE.
2017-10-29T19:48:16.623+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ADD CHECKPOINTTABLE goldengate.checkpoint.
2017-10-29T19:48:33.225+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start rep_hr.
2017-10-29T19:48:33.239+0800 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.21.129]:27445 (START REPLICAT REP_HR ).

ERROR OGG-00446在初始化中出现的解决方法报错信息已经提到，处理过程如下：

GGSCI (ZB as goldengate@ora) 45> start rep_hr
Sending START request to MANAGER ...
REPLICAT REP_HR starting
GGSCI (ZB as goldengate@ora) 46> ADD CHECKPOINTTABLE
ERROR: Missing checkpoint table specification.

GGSCI (ZB as goldengate@ora) 47> ADD CHECKPOINTTABLE goldengate.checkpoint

Successfully created checkpoint table goldengate.checkpoint.

GGSCI (ZB as goldengate@ora) 48> start rep_hr

Sending START request to MANAGER ...
REPLICAT REP_HR starting

GGSCI (ZB as goldengate@ora) 49> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
REPLICAT RUNNING REP_HR 00:00:00 00:00:00

GGSCI (ZB as goldengate@ora) 50>

GGSCI (ZB as goldengate@ora) 45> start rep_hr


Sending START request to MANAGER ...
REPLICAT REP_HR starting




GGSCI (ZB as goldengate@ora) 46> ADD CHECKPOINTTABLE
ERROR: Missing checkpoint table specification.


GGSCI (ZB as goldengate@ora) 47> ADD CHECKPOINTTABLE goldengate.checkpoint


Successfully created checkpoint table goldengate.checkpoint.


GGSCI (ZB as goldengate@ora) 48> start rep_hr


Sending START request to MANAGER ...
REPLICAT REP_HR starting




GGSCI (ZB as goldengate@ora) 49> info all


Program Status Group Lag at Chkpt Time Since Chkpt


MANAGER RUNNING
REPLICAT RUNNING REP_HR 00:00:00 00:00:00

GGSCI (ZB as goldengate@ora) 50>

GGSCI (ZB as goldengate@ora) 45> start rep_hr


Sending START request to MANAGER ...
REPLICAT REP_HR starting




GGSCI (ZB as goldengate@ora) 46> ADD CHECKPOINTTABLE
ERROR: Missing checkpoint table specification.


GGSCI (ZB as goldengate@ora) 47> ADD CHECKPOINTTABLE goldengate.checkpoint


Successfully created checkpoint table goldengate.checkpoint.


GGSCI (ZB as goldengate@ora) 48> start rep_hr


Sending START request to MANAGER ...
REPLICAT REP_HR starting




GGSCI (ZB as goldengate@ora) 49> info all


Program Status Group Lag at Chkpt Time Since Chkpt


MANAGER RUNNING
REPLICAT RUNNING REP_HR 00:00:00 00:00:00




GGSCI (ZB as goldengate@ora) 50>