PART 4 GOLDENGATE  SKIPPING TRANSACTION 

• Using logdump
• Skiptranaction
• Handle collisions
• Exceptional handling


METHOD 1

A• Using logdump

The below command will where extactly replicat trail file ABBEND

./ggsci

info replicat rep_trg detail
 


 we can see from the above image
1.what it got abbend
2. what is the checkpoint lag  -- here 40 sec
3. log read checkpoing -- which file it is reading , time , RBA position



To skip the transaction  we need information obtained by  "info replicat rep_trg detail "  in target location.

info 1: file /u01/aggt_target//dirdat/rt00004
info 2 : RBA 197210

"RBA - Relative Byte Address"

Note down the name of "Remote trail" file and "RBA Sequence"

and using logdump utility we can ignore the transaction


Use Logdump utility

./Logdump





logdump 1>open <trail file name>


ex : open  /u01/ggt_target/dirdat/rt000004

logdump 2>position <rba address>
ex : pos 197210

logdump 3>next (to skip to next record and note down the RBA)
Len 1261 RBA shows " this next available RBA available  -- -- from the above image

logdump 4 > next    ----- >>> since no new RBA value obtained we just saying  "next" to skip the transaction

logdump 5 > exit




./ggsci


alter replicat rep_trg extrba <rba address>

alter replicat  rep_trg extrba  197210






start replicat rep_trg


another example :



 Here you see multiple RBA's when you press "next , "next"  ...

you can shoose which operation and which RBA respectively.

OPETATIONS ::: DDLOP  , DELETE
RBA                 ::: 198567   ,  199919

using STAT command you can see how particular replicat behaving

ggsci>stats replicat rep_trg



SAMPLE LOGDUMP UTILITY UNDERSTANDING
 

ANOTHER SAMPLE LOGDUMP REPORT







End of first method







Method 2 : 

Using Skip transaction


Start replicat rep_trg skiptransaction



Method 3 :  
• Using Handlecollisions parameter

Send replicat rep_trg, HANDLECOLLISIONS

or    in replicat definition

HANDLECOLLISIONS MAP test.myobj, TARGET test.myobj;

Once the transaction is skipped or handled disable the handlecollisions

Send replicat rep_trg, NOHANDLECOLLISIONS


or

NOHANDLECOLLISIONS MAP test.myobj, TARGET test.myobj;



Methid 4: 

 Exceptional handling


http://www.vitalsofttech.com/troubleshoot-oracle-goldengate-using-exception-handler/