Goldengate [message #564634] |
Mon, 27 August 2012 04:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/00351886e0996b6743bd600473f56e11?s=64&d=mm&r=g) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/511f775d97da4358bd42e8a65613e950?s=64&d=mm&r=g) |
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
|
|
|