OGG target checkpoint table drop Repair Method

OGG target checkpoint table drop Repair Method

OGG target checkpoint table drop Repair Method

Reference: OGG Replicat Failed Due To Check_point Table beingTruncated (Document ID 1319832.1)

1. First, start repfull reports the following error:

GGSCI (localhost. localdomain) 8> view report repfull

**************************************** *******************************
Oracle GoldenGate Delivery for Oracle
Version 11.2.1.0.20 18227972 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_140304.2209_FBO
Linux, x64, 64bit (optimized), Oracle 10g on Mar 5 2014 02:20:23
 
Copyright (C) 1995,201 4, Oracle and/or its affiliates. All rights reserved.

Starting at 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
Heap Size: unlimited
File Size: unlimited
CPU Time: unlimited

Process id: 7590

Description:

**************************************** *******************************
** Running with the following parameters **
**************************************** *******************************

08:49:51 INFO OGG-03035 Operating system character set identified as UTF-8. Locale: en_US, LC_ALL :.

08:49:51 INFO OGG-02696 NON-ANSI SQL parameter syntax is used for parameter parsing.
Replicat repfull
Setenv (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK ")

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 lc000%9. *, target lc000%9 .*;

08:49:51 INFO OGG-00506 Both GETTRUNCATES and DDL replication are enabled.

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): 8 M
Process vm avail from OS (min): 4G
CACHESIZEMAX (strict force to disk): 3.41 GB

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/aimetricadc4150267/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]
: [/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]

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.

08:49:52 ERROR OGG-01668 process abending.

2. Create the goldengate. ckptfull table:

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. At this time, start repfull reports the following error:

Source Context:
SourceModule: [er. common]
SourceID: [/scratch/aime1/adestore/views/aimetricadc4150267/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]

09:03:03 ERROR OGG-00446 No data selecting position from checkpoint table goldengate. ckptfull for group 'repfull ', key 1036574807 (0x3dc8e057), SQL <SEL
ECT. current_dir,. seqno,. rba,. audit_ts,. log_csn,. log_cmplt_csn,. log_cmplt_xids, B. log_cmplt_xids FROM goldengate. ckptfull a left join goldengate. ckptfull _
Ox B ON. group_name = B. group_name AND. group_key = B. group_key AND. log_cmplt_csn = B. log_cmplt_csn WHERE. group_name = 'repfull 'AND. group_key = 1036574807>.

09:03:03 ERROR OGG-01668 process abending.

4. Obtain the repfull read checkpoint information:

GGSCI (localhost. localdomain) 16> info repfull

Replicat repfull Last Started 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. Modify the checkpoint (in fact, it is not called modification, but just repeat it)

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

GGSCI (localhost. localdomain) 18> info repfull

Replicat repfull Initialized Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:04 ago)
Log Read Checkpoint File/u02/ggs/dirdat/td000001
The First Record RBA 1192

6. Start the repfull process,

GGSCI (localhost. localdomain) 19> start repfull

Sending START request to MANAGER...
Replicat repfull starting

Note that a record is inserted in the goldengate. ckptfull table.

7. Check status:

GGSCI (localhost. localdomain) 41> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
Replicat running repfull 00:00:00