Home » Server Options » Replication » Data not getting replicated on target during online synchronization (Linux x86_64,Windows 7, Oracle 11.2.0.3)
Data not getting replicated on target during online synchronization [message #606572] Mon, 27 January 2014 02:37 Go to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member

Hi,

I am testing for online data synchronization using Golden Gate between oracle databases in Linux (x86_64) and Windows 7. I tested initial load extract method and it was working fine. But when I try to test for online data synchronization, its ending up with below error message in replicat process side on target database.


Quote:
2014-01-27 11:51:19 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, REP1.prm: REPLICAT REP1 started.
2014-01-27 11:51:19 WARNING OGG-03504 Oracle GoldenGate Delivery for Oracle, REP1.prm: NLS_LANG character set WE8MSWIN1252 on the target is different from the source database character set AL32UTF8. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.
2014-01-27 11:51:19 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, REP1.prm: Aborted grouped transaction on 'TEST.CT1', Database error 1403 (OCI Error ORA-01403: no data found, SQL <UPDATE "TEST"."CT1" SET "OBJECT_NAME" = :a1 WHERE "RNO" = :b0>).
2014-01-27 11:51:19 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 1216 in seqno 2.
2014-01-27 11:51:19 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, REP1.prm: SQL error 1403 mapping CTEST.CT1 to TEST.CT1 OCI Error ORA-01403: no data found, SQL <UPDATE "TEST"."CT1" SET "OBJECT_NAME" = :a1 WHERE "RNO" = :b0>.
2014-01-27 11:51:19 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 1216 in seqno 2.
2014-01-27 11:51:19 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, REP1.prm: Error mapping from CTEST.CT1 to TEST.CT1.
2014-01-27 11:51:19 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, REP1.prm: PROCESS ABENDING.


2014-01-27 11:53:08 INFO OGG-01014 Oracle GoldenGate Delivery for Oracle, REP1.prm: Positioning with begin time: Jan 27, 2014 10:53:02 AM, starting record time: Jan 27, 2014 10:51:44 AM at extseqno 3, extrba 1219.
2014-01-27 11:53:08 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, REP1.prm: REPLICAT REP1 started.
2014-01-27 11:55:33 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, REP1.prm: Aborted grouped transaction on 'TEST.CT1', Database error 1403 (OCI Error ORA-01403: no data found, SQL <DELETE FROM "TEST"."CT1" WHERE "RNO" = :b0>).
2014-01-27 11:55:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 1219 in seqno 3.
2014-01-27 11:55:33 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, REP1.prm: SQL error 1403 mapping CTEST.CT1 to TEST.CT1 OCI Error ORA-01403: no data found, SQL <DELETE FROM "TEST"."CT1" WHERE "RNO" = :b0>.
2014-01-27 11:55:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 1219 in seqno 3.
2014-01-27 11:55:33 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, REP1.prm: Error mapping from CTEST.CT1 to TEST.CT1.
2014-01-27 11:55:33 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, REP1.prm: PROCESS ABENDING.


The data in both SOURCE and TARGET are same in the database and there is no mismatch. Even the definitions of the table are same.


Parameters of Extract and Replicat process are given below

Quote:


EXTRACT ext1
userid gg_admin,password gg_admin
TRANLOGOPTIONS asmuser sys@ASM asmpassword sysasm
rmthost 172.27.5.212,MGRPORT 7809
rmttrail E:\oracle\gg\dirdat\rt
table ctest.ct1;


REPLICAT rep1
assumetargetdefs
userid gg_admin,password gg_admin
MAP ctest.ct1,TARGET test.ct1;



I again went with below option thinking there may be some checkpoint lag as I am using checkpoint table for replicat process.

alter replicat process rep1, begin now


Kindly advise, what could be the problem.
Re: Data not getting replicated on target during online synchronization [message #606687 is a reply to message #606572] Tue, 28 January 2014 03:55 Go to previous messageGo to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
Hi,

It got solved after adding TRANDATA for the table for the keycols.
Re: Data not getting replicated on target during online synchronization [message #612237 is a reply to message #606687] Tue, 15 April 2014 02:40 Go to previous messageGo to next message
tary750
Messages: 1
Registered: April 2014
Junior Member
hi ,
solved this issue by :
gg>alter rep1 begin now
Re: Data not getting replicated on target during online synchronization [message #629190 is a reply to message #606572] Thu, 04 December 2014 04:22 Go to previous message
nawaz50
Messages: 1
Registered: December 2014
Location: Pakistan
Junior Member
Hello babu

Thanks for your reply

Thankfully I got the same version installed on the source database and everything went well

I have not tried the pump however


[EDITED by LF: removed spam link]

[Updated on: Fri, 05 December 2014 00:44] by Moderator

Report message to a moderator

Previous Topic: materialized view
Next Topic: Oracle Golden Gate - Initial Load - File Method
Goto Forum:
  


Current Time: Fri Mar 29 01:05:13 CDT 2024