一次大数据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博客 ” ，链接：https://blog.itpub.net/16719800/viewspace-663112/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
记一次shareplex特大故障处理
下一篇：
一个表字段类型不一致导致的性能问题
请登录后发表评论
登录
全部评论
最新文章
- Oracle打PSU(11.2.0.3.11->11.2.0.3.15)
- ORA-12161: TNS:ORA-12592: TNS: ORA-03114:
- 常见oracle SQL性能优化
- ORA-00481: LMON process terminated with error kjfcdrmrfg: SYNC TIMEOUT
- ORA-01122 ORA-01110 ORA-01207
- ORA-00119: invalid specification for system parameter REMOTE_LISTENER ORA-00132:
- yum 安装包报错
- WARNING: Subscription for node down event still pending
- shareplex post 队列大量堆积
- 初学jboss
