OGG目的端的checkpoint table被drop的修复方法
参考自：OGG Replicat Failed Due To Check_point Table beingTruncated (文档 ID 1319832.1)
1.首先，start repfull报错：
GGSCI (localhost.localdomain) 8> view report repfull
? ? ? ? ? ? ? ? ? ? Starting at 2015-06-11 08:49:51
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri Jan 27 17:17:51 EST 2012, Release 2.6.18-308.el5
Node: localhost.localdomain
Machine: x86_64
? ? ? ? ? ? ? ? ? ? ? ? soft limit? hard limit
Address Space Size? :? ? unlimited? ? unlimited
Heap Size? ? ? ? ? ? :? ? unlimited? ? unlimited
File Size? ? ? ? ? ? :? ? unlimited? ? unlimited
CPU Time? ? ? ? ? ? :? ? unlimited? ? unlimited
Process id: 7590
Description:
***********************************************************************
**? ? ? ? ? ? Running with the following parameters? ? ? ? ? ? ? ? ? **
***********************************************************************
2015-06-11 08:49:51? INFO? ? OGG-03035? Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2015-06-11 08:49:51? INFO? ? OGG-02696? NON-ANSI SQL parameter syntax is used for parameter parsing.
replicat repfull
setenv ( NLS_LANG =? "AMERICAN_AMERICA.ZHS16GBK" )
2015-06-11 08:49:51? INFO? ? OGG-02095? Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.ZHS16GBK.
assumetargetdefs
userid goldengate, password ************
DBOPTIONS DEFERREFCONST
gettruncates
ALLOWNOOPUPDATES
ddl include mapped
discardfile ./dirrpt/repfull.dsc, append, megabytes 5000
map scott.*, target scott.*;
map lc00019999.*, target lc00019999.*;
2015-06-11 08:49:51? INFO? ? OGG-00506? Both GETTRUNCATES and DDL replication are enabled.
2015-06-11 08:49:51? INFO? ? OGG-01815? Virtual Memory Facilities for: COM
? ? anon alloc: mmap(MAP_ANON)? anon free: munmap
? ? file alloc: mmap(MAP_SHARED)? file free: munmap
? ? target directories:
? ? /u02/ggs/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE:? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 2G
CACHEPAGEOUTSIZE (normal):? ? ? ? ? ? ? ? 8M
PROCESS VM AVAIL FROM OS (min):? ? ? ? ? 4G
CACHESIZEMAX (strict force to disk):? 3.41G
Database Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE? ? 10.2.0.5.0? ? ? Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
Database Language and Character Set:
NLS_LANG? ? ? ? = "AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE? ? = "AMERICAN"
NLS_TERRITORY? ? = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"
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) [0x2ad4a9a6561e]]
? ? ? ? ? ? ? ? ? ? ? ? ? : [/u02/ggs/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2ec) [0x2ad4a9a5e15c]]
? ? ? ? ? ? ? ? ? ? ? ? ? : [/u02/ggs/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x2ad4a9a4f66b]
]
? ? ? ? ? ? ? ? ? ? ? ? ? : [/u02/ggs/replicat(extract_start_point(time_elt_def*, time_elt_def*)+0x165) [0x520775]]
? ? ? ? ? ? ? ? ? ? ? ? ? : [/u02/ggs/replicat(replicat_main(int, char**)+0x59f) [0x550f5f]]
? ? ? ? ? ? ? ? ? ? ? ? ?