Shulou(Shulou.com)06/01 Report--

1: stop the replicate process first

2:

Make sure that the database scn,Scn on the source side is the scn number on the source side, that is, the current scn number of the current database formal database:

Select sysdate,dbms_flashback.get_system_change_number | |''from dual

3. Use expdp to export the table and see blog:

Https://blog.51cto.com/1937519/2177352

Or use dblink:

View INSERT INTO XX SELECT * FROM xx@dblink as of scn xxx

4:

After the import is completed

Use the Start replicat rep_pos,aftercsn scn number (executed above the pos read-only library)

Synchronize partial tables separately:

11g includes the previous goldengate:

Map wms.transport_service, target wms.transport_service, filter (@ GETENV ("transaction", "csn") > 96639040762)

Goldengate after 12C:

Map wms.transport_service, target wms.transport_service, filter (@ GETENV ('transaction',' csn') > 96639040762)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.