您好,登錄后才能下訂單哦!
主備操作系統(tǒng):rhel 6.6
數(shù)據(jù)庫版本:oracle 11.2.0.4
ogg版本:12.3.0.1.0
今天教一新手使用oracle 11.2.0.4 ogg 12.3.0.1.0做數(shù)據(jù)同步,其部署過程不規(guī)范,備庫未對goldengate用戶做checkpoint表,導致備庫的引用進程啟動不了。
備庫rep_hr進程的參數(shù)及狀態(tài)如下:
rep_hr的參數(shù):
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的狀態(tài)
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在初始化中出現(xiàn)的解決方法報錯信息已經(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) 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>
免責聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。