oracle 11.2.0.4 ogg 12.3.0.1.0備庫rep進(jìn)程啟動報(bào)錯(cuò)OGG-00446

    數(shù)據(jù)庫版本：oracle 11.2.0.4

    今天教一新手使用oracle 11.2.0.4 ogg 12.3.0.1.0做數(shù)據(jù)同步，其部署過程不規(guī)范，備庫未對goldengate用戶做checkpoint表，導(dǎo)致備庫的引用進(jìn)程啟動不了。

rep_hr的參數(shù)：

rep_hr的狀態(tài)

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啟動報(bào)錯(cuò)信息如下：

ERROR OGG-00446在初始化中出現(xiàn)的解決方法報(bào)錯(cuò)信息已經(jīng)提到，處理過程如下：

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) 49> info all


Program     Status      Group       Lag at Chkpt  Time Since Chkpt


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