What is you best strategy to recover From this?

You have discovered that an OGG checkpoint table has become corrupted. What is you best
strategy to recover From this?

You have discovered that an OGG checkpoint table has become corrupted. What is you best
strategy to recover From this?

A.
Use the CONVCHK utility on the target to restore the checkpoint table from checkpoint files.

B.
Restore the target DB from backup, reposition the Extract to a point prior to the corruption, Turn
to HANDLECOLLISIONS in the Replicat.

C.
Use NODECHECKPONT to cause Replicat to use the checkpoint files as backup and
regenerate the checkpoint table.

D.
Use the GENCHK utility on the source to restore the checkpoint table from checkpoint files.

Explanation:
Reference:
http://www.outofboundstechnology.com/files/oracle/oraclegg_part3_trouble.pdf

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

Stanly

Stanly

A
[oracle@vm-gg11 OGG_Target] $ convchk rep_5a CHECKPOINTTABLE
***********************************************************************
Oracle GoldenGate Checkpoint Conversion Utility
Version 11.1.1.1 OGGCORE_11.1.1_PLATFORMS_110421.2040
Linux, x86, 32bit (optimized) on Apr 21 2011 10:41:50 PM
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2011-10-19 0:45:15 PM
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri Apr 2 2:58:35 PM EDT 2010, Release 2.6.18-194.el5
Node: vm-gg11
Machine: i686
soft limit hard limit
Address Space Size: unlimited unlimited
Heap Size: unlimited unlimited
File Size: unlimited unlimited
CPU Time: unlimited unlimited
Process id: 6036
Opening existing checkpoint file /home/oracle/OGG_Target/dirchk/REP_5A.cpr for group REP_5A.
Checkpoint not converted… No conversion is required for replicat checkpoints.

Reply