OGG单表修复

1.源端查询SCN

 export ORACLE_SID=xxx
 sqlplus "/nolog" << EOF
 conn sys/123456 as sysdba
 col get_system_change_number for 9999999999999999
 select dbms_flashback.get_system_change_number from dual;
 exit
 EOF
 13415127855751

2.停入库进程R
 stop RSS_ZZ4
 
3.修改入库进程r的参数文件

 edit param RSS_ZZ4
 map HX_ZZ.ZS_HD_JG,target HX_ZZ.ZS_JG,filter (@GETENV ("transaction","csn") > 13415127855751);

4.源端导出DMP

 export ORACLE_SID=xxx
 expdp system/xxx tables=HX_ZZ.ZS_JG dumpfile=expdp_tab3_%U.dmp  logfile=expdp_tab2.log DIRECTORY=dp_dir  EXCLUDE=index,GRANT,TRIGGER COMPRESSION=ALL  PARALLEL=10 flashback_scn=13415127855751 cluster = no

5.将导出的DMP传至目标机器

 scp expdp_tab3_* ip:/director

6.目标端导入DMP

 export ORACLE_SID=xxx
 impdp system/xxx tables=HX_ZZ.ZS_JG dumpfile=expdp_tab3_%U.dmp  logfile=impdp_tab2.log DIRECTORY=dp_dir  table_exists_action=truncate  PARALLEL=10  cluster = no

7. 启动入库进程

 start RSS_ZZ4

8. 查看状态

 info all
 lag RSS_ZZ4
 走平，显示EOF

9.停入库进程R

 stop RSS_ZZ4

10. 注释MAP

 edit param RSS_ZZ4
 --MAP ...

11.启动进程

 start RSS_ZZ4