In our system we have a running advanced replication between two databases(11g release 2) and want to use pump import to import a backup on one site. However the imported data is not replicated to the other site. All following changes get replicated as usual.
Edit for calification: Replication is active and both sites have the same data. I then import something into the primary site. These imported changes are NOT replicated. The second site still has the "pre-import" data.
When something in the primary site changes after the import, these changes get still replicated. So the replication itself is still active.
The pump import seems not to trigger the replication of the imported data.
I could not find anything about this in the oracle documentation. Is it even supported or is there something missing from our import and export commands?
expdp <connection data> dumpfile='xyz.dmp' SCHEMAS=XYZ EXCLUDE=USER NOLOGFILE=Y REUSE_DUMPFILES=Y
impdp <connection data> DUMPFILE='xyz.dmp' NOLOGFILE=y IGNORE=y INCLUDE=table_data TABLE_EXISTS_ACTION=skip
Best Answer
Basically Advanced Replication works with materialized views, materialized view logs and triggers. To replicate data from one side to another, you need to have INSERT, UPDATE or DELETE statements to make the replication mechanism recognize that there is new/changed data. When you import data with direct path method you skip all this stuff. This means you need conventional path method to import data.
DataPump chooses the method by itself on a set of conditions. These conditions can be found here: http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#SUTIL804
I'm not 100% sure which method is being used in your case but i doubt that it is conventional path.
Oracle does not tell how to force conventional path method but you could try to import the data with the old imp utility. When the export is done with DIRECT=N the imp should be done in conventional method.
Maybe someone else has experiences with Advanced Replication and DataPump. My experiences are limited since Oracle pushes Golden Gate as the future replication technology.