OGG目的端的checkpointtable被drop的修复方法 - 数据库编程

oint(time_elt_def*, time_elt_def*)+0x165) [0x520775]] : [/u02/ggs/replicat(replicat_main(int, char**)+0x59f) [0x550f5f]] : [/u02/ggs/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x5ef7ff]] : [/u02/ggs/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x5efa54]] : [/u02/ggs/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x5efb5b]] : [/u02/ggs/replicat(main+0x2c) [0x5502ac]] : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3a2a01d994]] : [/u02/ggs/replicat(__gxx_personality_v0+0x31a) [0x4c266a]] 2015-06-11 08:49:52 ERROR OGG-00446 Checkpoint table goldengate.ckptfull does not exist. Please create the table or recreate the REPFULL group using the correct t able. 2015-06-11 08:49:52 ERROR OGG-01668 PROCESS ABENDING.

2.于是，就建立上goldengate.ckptfull 这个表：

GGSCI (localhost.localdomain) 9>  dblogin  userid goldengate, password xxx
Successfully logged into database.

GGSCI (localhost.localdomain) 10> ADD CHECKPOINTTABLE goldengate.ckptfull

Successfully created checkpoint table goldengate.ckptfull.

3.此时，start repfull报错：

Source Context :
  SourceModule            : [er.common]
  SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150267/oggcore/OpenSys/src/app/er/common.cpp]
  SourceFunction          : [extract_start_point]
  SourceLine              : [2142]
  ThreadBacktrace         : [11] elements
                          : [/u02/ggs/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2b18e359d61e]]
                          : [/u02/ggs/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2ec) [0x2b18e359615c]]
                          : [/u02/ggs/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x2b18e358766b]
]
                          : [/u02/ggs/replicat(extract_start_point(time_elt_def*, time_elt_def*)+0x165) [0x520775]]
                          : [/u02/ggs/replicat(replicat_main(int, char**)+0x59f) [0x550f5f]]
                          : [/u02/ggs/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x5ef7ff]]
                          : [/u02/ggs/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x5efa54]]
                          : [/u02/ggs/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x5efb5b]]
                          : [/u02/ggs/replicat(main+0x2c) [0x5502ac]]
                          : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3a2a01d994]]
                          : [/u02/ggs/replicat(__gxx_personality_v0+0x31a) [0x4c266a]]

2015-06-11 09:03:03  ERROR   OGG-00446  No data selecting position from checkpoint table goldengate.ckptfull for group 'REPFULL', key 1036574807 (0x3dc8e057), SQL 
  
   .

2015-06-11 09:03:03  ERROR   OGG-01668  PROCESS ABENDING.

4.得到repfull的读检查点信息：

GGSCI (localhost.localdomain) 16> info repfull

REPLICAT   REPFULL   Last Started 2015-06-11 08:30   Status ABENDED
Checkpoint Lag       00:00:00 (updated 00:33:01 ago)
Log Read Checkpoint  File /u02/ggs/dirdat/td000001 ---->1
                     First Record  RBA 1192        ---->1192

5.修改检查点（其实不叫修改，就是重复一下而已）

GGSCI (localhost.localdomain) 17> alter replicat repfull, extseqno 1, extrba 1192
REPLICAT altered.


GGSCI (localhost.localdomain) 18> info repfull

REPLICAT   REPFULL   Initialized   2015-06-11 09:05   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:00:0

OGG目的端的checkpointtable被drop的修复方法(二)