Home » Server Options » Replication » oracle golden gate (oracle)
oracle golden gate [message #646261] Wed, 23 December 2015 07:40 Go to next message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

hi,

I am trying to setup golden gate replication from MYSQL (source) to oracle database 11.2.0.1.0 (target) Both extract and replicat process running but data is not replicating. Remote trail file is also generating.
Below is my configuration.

[(code)]

REPLICAT r_smpp6
USERID ggs_owner, PASSWORD warsaw
ASSUMETARGETDEFS
HANDLECOLLISIONS
SOURCEDEFS /u01/app/oracle/oradata/GG/dirdef/source.def
DISCARDFILE /u01/app/oracle/oradata/GG/dirrpt/smpp6.dsc, PURGE
MAP "smpp6.test", TARGET SMPP6.test;

EXTRACT e_smpp6
DBOPTIONS HOST 10.168.20.104, CONNECTIONPORT 14420
SOURCEDB smpp6@10.168.20.104:14420, USERID "kannel", PASSWORD "****"
RMTHOST 10.168.20.31, MGRPORT 7809
RMTTRAIL /u01/app/oracle/oradata/GG/dirdat/Z6
TRANLOGOPTIONS ALTLOGDEST /root/sandboxes/multi_msb_5_5_19/node1/data/mysql-bin.index
TABLE smpp6.test;

Extract log
***********
2015-12-23 15:49:37 INFO OGG-01052 No recovery is required for target file
/u01/app/oracle/oradata/GG/dirdat/Z6000000, at RBA 0 (file not opened).

2015-12-23 15:49:37 INFO OGG-01478 Output file /u01/app/oracle/oradata/GG/d
irdat/Z6 is using format RELEASE 10.4/11.1.

2015-12-23 15:49:37 INFO OGG-00182 VAM API running in single-threaded mode.

2015-12-23 15:49:37 INFO OGG-01515 Positioning to begin time Dec 23, 2015 1
:17:59 PM.

***********************************************************************
** Run Time Messages **
***********************************************************************


2015-12-23 15:53:12 INFO OGG-01516 Positioned to Log Number: 9
Record Offset: 864, Dec 23, 2015 3:53:11 PM.

2015-12-23 15:53:12 INFO OGG-01517 Position of first record processed Log N
umber: 9
Record Offset: 864, Dec 23, 2015 3:53:11 PM.
TABLE resolved (entry smpp6.test):
TABLE smpp6.test;

Using the following key columns for source table smpp6.test: name.



[Code}
Re: oracle golden gate [message #646267 is a reply to message #646261] Wed, 23 December 2015 08:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
what assurance do you have that this can ever work?
Re: oracle golden gate [message #646286 is a reply to message #646267] Thu, 24 December 2015 01:09 Go to previous message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

My replicat process shows No active replication maps but extract process show below details which means issue in replicat process, any idea how to resolve it?

GGSCI (racnode1) 20> stats replicat r_smpp6

Sending STATS request to REPLICAT R_SMPP6 ...

No active replication maps.

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

GGSCI (ets-psql-db.etisalcom.private) 39> stats extract e_smpp6

Sending STATS request to EXTRACT E_SMPP6 ...

Start of Statistics at 2015-12-24 11:56:21.

Output to /u01/app/oracle/oradata/GG/dirdat/Z6:

Extracting from smpp6.test to smpp6.test:

*** Total statistics since 2015-12-24 11:39:52 ***
Total inserts 0.00
Total updates 1.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00

*** Daily statistics since 2015-12-24 11:39:52 ***
Total inserts 0.00
Total updates 1.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00

*** Hourly statistics since 2015-12-24 11:39:52 ***
Total inserts 0.00
Total updates 1.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00

*** Latest statistics since 2015-12-24 11:39:52 ***
Total inserts 0.00
Total updates 1.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00

End of Statistics.


[Updated on: Thu, 24 December 2015 02:59]

Report message to a moderator

Previous Topic: OGG chekpoint recovery
Next Topic: Teradata Replication
Goto Forum:
  


Current Time: Thu Mar 28 12:53:28 CDT 2024