Home » Server Options » Replication » Goldengate (Goldengate,11,linux)
Goldengate [message #564634] Mon, 27 August 2012 04:13 Go to next message
vetri2u
Messages: 1
Registered: August 2012
Location: chennai
Junior Member
How can i add exttrail to a replicat
Re: Goldengate [message #571454 is a reply to message #564634] Mon, 26 November 2012 02:35 Go to previous message
tony123
Messages: 9
Registered: August 2012
Junior Member

1. stop extract
2. stop datapump
3. stop replicat
4. check extract checkpoint
GGSCI> INFO extract_name, SHOWCH
5. modify old parameter file,remove some tables
6. add new extract,datapump,replicat
GGSCI (source123) 15> add ext exef, tranlog, begin now
GGSCI (source123) 16> add exttrail ./dirdat/ef, ext exef, megabytes 50
GGSCI (source123) 17> add ext dpef, exttrailsource ./dirdat/ef
GGSCI (source123) 18> add rmttrail ./dirdat/ef, ext dpef, megabytes 50
GGSCI (target123) 21> add rep rpef, exttrail ./dirdat/ef
7. modify extract checkpoint
GGSCI (source123) 30> alter exef extseqno 21, extrba 3218 [, thread n]
GGSCI (source123) 4> alter exef ioextseqno 21, ioextrba 3214 [, thread n]
8. start all process,include old and new add.

[Updated on: Mon, 26 November 2012 02:36]

Report message to a moderator

Previous Topic: replication between 4 databases
Next Topic: replication for dual schemas in same database
Goto Forum:
  


Current Time: Wed Oct 01 12:22:28 CDT 2014

Total time taken to generate the page: 0.09256 seconds