修复刚才发生错误的那个流!

最新推荐文章于 2025-12-05 12:37:18 发布

最新推荐文章于 2025-12-05 12:37:18 发布 · 90 阅读

文章标签：

#数据库

本文通过具体步骤展示了如何解决LCRS无法定位特定记录的问题，并演示了包括删除记录、提交更改及启动apply进程等一系列操作。

既然LCRS无法定位发生操作的记录，我们可以帮助它定位：

以下操作都在目标端发生：

SQL> select * from kpi_bak;

ID IS_HARD
---------- ----------
NAME
--------------------------------------------------------------------------------
VALUEOFKPI
--------------------------------------------------------------------------------
OBJ_VERSION LEVELOFSERVICE_ID EXTRA
----------- ----------------- ----------
2 0
standart_KPI
12345
0 1

SQL> delete from kpi_bak where rownum=1;

1 row deleted.

SQL> commit;

Commit complete.

SQL> BEGIN
2 DBMS_APPLY_ADM.EXECUTE_ERROR(
3 LOCAL_TRANSACTION_ID => '2.2.56416',
4 EXECUTE_AS_USER => FALSE);
5 END;
6 /

PL/SQL procedure successfully completed.

SQL> select * from dba_apply_error;

no rows selected
启动apply进程!

SQL> exec DBMS_APPLY_ADM.START_APPLY(apply_name => '"STREAMS_APPLY"');

PL/SQL procedure successfully completed.

流又正常工作!

$ sqlplus svc_contract/svc_contract@lab10g

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 2 04:42:03 2009

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create table test(name number);

Table created.

SQL> insert into test values(3);
commit;
1 row created.

SQL>

Commit complete.

SQL> conn svc_contract/svc_contract@rpt10g
Connected.
SQL> select * from test;

NAME
----------
3