This content has been marked as final. Show 4 replies
Let's say you want to use a data pump in your replication. A data pump is a secondary extract process. The primary extract will get SQL out of the redo logs and put it into local files, called trails. From there, the data pump will send those files to the target server.
On the target server, the replicat process will read through the trails and create the SQL to be applied to the target database.
In your parameters, what you have so far, is one extract sending directly to the target, altogether bypassing a data pump. Then you have a data pump that does nothing (where is it sending the trails to?). And your replicat, which is okay by itself.
I would suggest going through the tutorial at Oracle Learning Library. There are several other steps you missed (or at least, did not mention in your post).
Here is the link to OLL:
Plus, look at the admin guide and the diagrams. Those will help explain the architecture.
Thanks for your reply.
I am facing a error now.
I tried the solution given in some post on this forum which says that rename the rt0001 file to some other name like rt0001_backup and then restart the extract dpump process and then it will work. I did this it started working but after sometime I get again the same error for some different file.
ERROR OGG-01031 There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "/oracle/G oldenGate/Setup/dirdat/rt000004" (error 11, Resource temporarily unavailable)).
Please guide me what to do in such situations?
Anyone any update ?
you can use logdump utility to find out the number of transactons in source trail file and target trail file. The count should match. in Golden Gate home directory you can execute "logdump" command and
(1) open "trail file location"
(2) detail data on