In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Active and standby operating system: rhel 6.6
Database version: oracle 11.2.0.4
Ogg version: 12.3.0.1.0
Today, a novice is taught to use oracle 11.2.0.4 ogg 12.3.0.1.0 for data synchronization. The deployment process is not standard, and the slave database does not make checkpoint tables for goldengate users. As a result, the reference process of the slave database cannot be started.
The parameters and status of the slave rep_hr process are as follows:
Parameters of 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
Status of 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 >
The error message for rep_hr startup is as follows:
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).
The error message of the solution occurred in the initialization of ERROR OGG-00446 has been mentioned, and the processing process is as follows:
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 >
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 >
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.