OGG Replicat Failed Due To Check_point Table beingTruncated [ID 1319832.1]

In this Document
  Goal
  Solution

---

Applies to:

Oracle GoldenGate - Version: 10.4.0.103 and later   [Release: 10.4.0 and later ]
Information in this document applies to any platform.

Goal

I  truncated the replicat checkpoint table on the target by mistake.  Now the replicat abends with error:
----------
ERROR OGG-00446 No data found selecting position from checkpoint table GGS_CHK for group R1, k
ey 2793758294 (0xa6855e56), SQL D group_key = 2793758294>.
----------

How can I restart the replicat?

Solution

As the replicat checkpoint file is still intact, its information may be used to reset the replicat.

1. make a backup of checkpoint file under ./dirchk directory

2. get current checkpoint information
e.g.,
GGSCI (tellurian) 6> info r1

REPLICAT R1 Initialized 2011-05-05 15:04 Status ABENDED
Checkpoint Lag 00:00:00 (updated 00:00:01 ago)
Log Read Checkpoint File ./dirdat/e1000012
First Record RBA 1879

3.reset the replicat rba based on above output (set it to the same values)
GGSCI (tellurian) 8> alter replicat r1, extseqno 12, extrba 1879
REPLICAT altered.

4. double-check with 'info '
e.g.
GGSCI (tellurian) 9> info r1

REPLICAT R1 Initialized 2011-05-05 15:05 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:01:04 ago)
Log Read Checkpoint File ./dirdat/e1000012
First Record RBA 1879

5. start replicat
e.g.,
ggsci> start replicat r1

6. check replicat is running fine with "info "

7. check the new row is inserted back to the checkpoint table.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/704514/viewspace-701868/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/704514/viewspace-701868/