Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

start replicat aftercsn

User_U66YKMar 20 2017 — edited Apr 5 2017

Hi Guys,

I'm doing a test using expdp/impdb and aftercsn for initial load and changes. But doesn't work as expected.

Any issue with the test plan?

1. Add Extract, Add Exttrail, Add Pump, Add Rmttrail on source.

2. Start Extract, Start Pump on source.

3. Get SCN before schema export

select dbms_flashback.get_system_change_number() from dual;

1097818

4. Export in source

expdp directory=DATA_PUMP_DIR parallel=4 dumpfile=hr.dmp logfile=hr.log flashback_scn=1097818 schemas=hr

5. Import to target

6. In source, perform a delete:

delete from hr.employees where last_name='Fay';

7. Add and Start Replicat in target

start replicat rephr, aftercsn 1097818

However in the target, i notice that the delete change in step 6 is not applied. The record is still there in the target DB.

Can advise on this?

thanks

This post has been answered by aoflima44 on Mar 21 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2017
Added on Mar 20 2017
21 comments
14,666 views