SAP Knowledge Base Article - Preview

2355885 - RAO down with RecordProcessingException: Error during rollback processing: invalid rollback ID : RAO 15.7.1 SP208

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

SAP Sybase Replication Server 15.7, heterogeneous edition

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.