Symptom
Replication Agent for Oracle (RAO) goes into REPLICATION DOWN state with an invalid rollback ID error on a non-LOB table:
com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.OracleLog RecordProcessingException: Error during rollback processing for operation <LogMiner STARTSCN:10456580456287 LogMiner ENDSCN:10456580458655
LogMiner options:[SYS.DBMS_LOGMNR.CONTINUOUS_MINE, SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG, SYS.DBMS_LOGMNR.NO_ROWID_IN_STMT]
DDL Scanner:false OPID <0x0982.9cc38659.0000:0001.000244d8.000598d9.03b0>, Timestamp <2016-07-19 15:27:37.0>, XID <0x0018.001f.ffffffff>, Serial# <0>, Session# <0>, Session Info <UNKNOWN>, User Name <UNKNOWN>, Object ID <1762307>, REL_FILE# <213>, DATA_BLK# <633664>, DATA_OBJD#<1762307>, Operation <DELETE>, Op Code <2> Rollback <1> SSN <0> CSF <0> Seg_Owner <PCM> Seg_Name <TEST_T>
INFO <N/A> SQL Redo <delete from "DBO"."TEST_T" where ROWID = 'AAGuQDADVAACatAAAv';> >: invalid rollback ID. Record: <Current Record ID: [-1] First Record ID: [0]Stack top: [NULL] PendingRollbackLocator: [NULL] PendingRollback: [NULL]
Read more...
Environment
- Oracle Source DB version 11.2.0.3
- SAP Replication Server Heterogeneous Edition 15.7.1 SP208
- SAP Replication Server Option for Oracle 15.7.1 SP208
Product
Keywords
RAO abort invalid rollback Timestamp record PendingRollbackLocator PendingRollback CR# 792484 792484 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.