GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Replicat didn't capture the changes while Instantiation(expdp/impdp) is in progress

edited Mar 11, 2014 11:58AM in GoldenGate, Streams and Distributed Database (MOSC) 19 commentsAnswered ✓
Hi,
Replicat didn't capture the changes while Instantiation(expdp/impdp) is in progress . As Target tables went out of sync, we have used expdp/impdp method to refresh the specific tables by using the following method. However It didn't capture the changes while refresh is in progress.
Steps:
1. Stop the goldengate and deleted the both extract and replicats.
2. Truncate tables on target
3. Created the extract on source and started the extract === as to capture the changes while refresh is in progress.
4. Backup tables on source by using the expdp with the option "flashback_scn"
5. Refresh target tables by using impdp. Made sure table counts are the same on both side.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center