| Goldengate [message #564634] |
Mon, 27 August 2012 04:13  |
 |
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  |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
