Thursday 11 September 2014

how to resync table for oracle golden gate.

1. exclude table need to be resync
2. check if no lag on repicat side.
3. stop replicat and extract
4. export table using datapump

expdp system tables=DBAdmin.Table1,DBAdmin.Table2 directory=datapumpdir logfile=exp.log dumpfile=exp.dmp flashback_scn=10940399369
 
5. import table

impdp system/oracle tables=DBAdmin.Table1,DBAdmin.Table2 directory=datapumpdir logfile=imp.log dumpfile=exp.dmp TABLE_EXISTS_ACTION=replace

6. start both extract and replicat 

No comments:

Post a Comment