一次大数据log的丢失,处理方法
1 update actid
SQL> select actid,seqno,offset,instance_name from splex23.shareplex_actid;
1 update actid
SQL> select actid,seqno,offset,instance_name from splex23.shareplex_actid;
ACTID SEQNO OFFSET INSTANCE_NAME
---------- ---------- ---------- ----------------
23 29798 2509328 gdora10g1 1_30000_670161409.dbf
23 16325 1699780 gdora10g2 2_38000_670161409.dbf
23 18332 40400912 gdora10g3
update splex23.shareplex_actid
set seqno =
offset = 0,
log_start_offset=0
Where actid =
and instance_name='';
2 clean config
shutdown 有问题的端口 2300
source 端
sp_ctrl (gdsync:2300)> shutdown
[quest22@gddbserver1 splex]$ export SP_SYS_VARDIR=/data/shareplex/splex/vardir23
target 端
sp_ctrl (gdsync:2300)> shutdown
[quest22@gddbserver1 splex]$ export SP_SYS_VARDIR=/data/shareplex/splex/vardir23
---------- ---------- ---------- ----------------
23 29798 2509328 gdora10g1 1_30000_670161409.dbf
23 16325 1699780 gdora10g2 2_38000_670161409.dbf
23 18332 40400912 gdora10g3
update splex23.shareplex_actid
set seqno =
offset = 0,
log_start_offset=0
Where actid =
and instance_name='';
2 clean config
shutdown 有问题的端口 2300
source 端
sp_ctrl (gdsync:2300)> shutdown
[quest22@gddbserver1 splex]$ export SP_SYS_VARDIR=/data/shareplex/splex/vardir23
target 端
sp_ctrl (gdsync:2300)> shutdown
[quest22@gddbserver1 splex]$ export SP_SYS_VARDIR=/data/shareplex/splex/vardir23
source target 都ora_cleansp splex23/splex23(用对应的账号)
清空config
都处理完成以后
source target
sp_cop -u2300 &
activate config config100427
ok
差的数据通过compare 补回来
差的数据通过compare 补回来
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16719800/viewspace-663112/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16719800/viewspace-663112/