www.eygle.com

« Streams流复制的异常检测 | Blog首页 | 我家有儿初长成-恩墨三月记 »

streams流复制ORA-01403错误解决一则

作者：eygle |【转载时请以超链接形式标明文章出处和作者信息及本声明】
链接：http://www.eygle.com/archives/2007/11/streams_ora_01403.html

---

在Streams复制中，很多时候会遇到ORA-01403: no data found的错误（定义冲突解决方案很重要）：

SQL> select apply_name,LOCAL_TRANSACTION_ID,SOURCE_TRANSACTION_ID,ERROR_MESSAGE
  2  from dba_apply_error;

APPLY_NAME  LOCAL_TRANSACTION_ID  SOURCE_TRANSACTION_ID  ERROR_MESSAGE
----------- ---------------------- ---------------------- -------------------------
APP97_APPLY 5.27.1273              4.46.576              ORA-01403: no data found

通过print_transaction可以找到相关事务的出错原因：

SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL> EXEC print_transaction('5.27.1273')

----- Local Transaction ID: 5.27.1273
----- Source Database: TEST201.EYGLE.COM
----Error in Message: 1
----Error Number: 1403
----Message Text: ORA-01403: no data found

--message: 1
type name: SYS.LCR$_ROW_RECORD
source database: TEST201.EYGLE.COM
owner: SCOTT
object: DEPT
is tag null: Y
command_type: UPDATE
old(1): DEPTNO
50
old(2): LOC
CHINA
new(1): LOC
CHINA

如果能够定位错误数据，可以手工纠正一下：

SQL> connect scott/tiger
Connected.
SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        50 EYGLE          BEIJING
        10 ACCOUNTING    NEW YORK
        20 RESEARCH      DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS    BOSTON

SQL> update dept set loc='CHINA' where deptno=50;

1 row updated.

SQL> commit;

Commit complete.

然后再次执行原事务，该事务就可以被正常执行：

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

PL/SQL procedure successfully completed

SQL> select apply_name,LOCAL_TRANSACTION_ID,SOURCE_TRANSACTION_ID,ERROR_MESSAGE
  2  from dba_apply_error
  3  /

APPLY_NAME  LOCAL_TRANSACTION_ID  SOURCE_TRANSACTION_ID  ERROR_MESSAGE
----------- ---------------------- ---------------------- -------------------------

By eygle on 2007-11-08 15:41 | Comments (3) | Posted to Advanced | Edit |

相关文章	随机文章
streams流复制中如何初始化复制对象 Streams流复制的异常检测 Streams复制的ORA-01341错误解决 Global_name从何处来? Streams散记之一-如何清除流配置	百老汇的《42街》-Forty-Second Street 祝福大家新年好 2008梦想成真 Brother, My Cup Is Empty 一个命题:列举你认为最重要的9个动态性能视图 如何显示picasa照片 - 修改hosts文件

留言 (3)

Posted by: Peifei at July 4, 2008 9:15 AM

Posted by: Peifei at July 4, 2008 9:16 AM

Posted by: wangliang at August 22, 2008 3:12 PM

发表留言:

Name(*):
Email(*):

You Link: Remember Me? YesNo
验证码(*): (输入验证码后方可评论,谢谢支持)
Comments: