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) 51> info rep_hr

REPLICAT   REP_HR    Last Started 2017-10-29 19:48   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:02 ago)
Process ID           12507
Log Read Checkpoint  File /u01/app/oracle/OGG/product/dirdat/et000000000
                     First Record  RBA 1409

GGSCI (ZB as goldengate@ora) 52>