oracle ogg checkpoint,OGG目的端的checkpoint table被drop的修复方法

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

***********************************************************************

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, 2014, Oracle and/or its affiliates. All rights reserved.

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.Z