ogg重新初始化
一、在源端导出数据
SQL>select to_char(current_scn) from v$database; 查询当前scn
2719112586
导出数据
[oracle@yyghdb odc]$expdp odc/odc directory=odc_dir schemas=BOOKPLAT dumpfile=BOOKPLAT2.dmp flashback_scn=2719112586 logfile=BOOKPL[oracle@yyghdb odc]$ expdp odc/odc directory=odc_dir
二、目标端导入数据
drop user BOOKPLAT cascade
删除原有的同步用户
impdp odc/odc@zjhorcl1 directory=ODC_DIR dumpfile=bookplat2.dmp schemas=BOOKPLAT logfile=bookplat2.log
重新导入同步用户
Select trigger_name from dba_triggers where owner='BOOKPLAT' and status='ENABLED';
TRIG_DUP
查询同步用户触发器
alter trigger BOOKPLAT.TRIG_DUP disable;
禁用该触发器
移除JOB:
select job,log_user,schema_user from dba_jobs;
exec dbms_ijob.remove();
select * from dba_scheduler_jobs;
禁用:
DBMS_SCHEDULER.DISABLE('job1, job2, job3, sys.jobclass1, sys.jobclass2');
三、设置复制进程位置,并启动
查看dirdat下trail文件日期,找出数据导出时间前的trail文件
ls -rtl
total 3743578
-rw-rw-rw- 1 oracle oinstall 99999967 Apr 28 03:01 ws000686
-rw-rw-rw- 1 oracle oinstall 99999725 Apr 28 04:37 ws000687
-rw-rw-rw- 1 oracle oinstall 99999993 Apr 28 15:01 ws000688
设置复制进程位置,让复制进程从000687开始复制
alter ws_repc extseqno 000687 extrba 0
alter ws_rep4 extseqno 000687 extrba 0
用atcsn启动复制进程
start ws_rep4 atcsn 2719112586
start ws_repc atcsn 2719112586
查看进程状态,同步完成
GGSCI (ehrdb1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING WS_REP4 00:00:00 30:33:17
REPLICAT RUNNING WS_REPC 00:00:00 03:15:02
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25427762/viewspace-1152050/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25427762/viewspace-1152050/