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

来源：互联网发布：mysql时间差编辑：程序博客网时间：2024/04/29 19:38

既然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