SAP Knowledge Base Article - Preview

2321898 - RAO Missing Archive Log Files after restoring to archive directory - RSO

Symptom

  • The main archive log directory filled up and caused several archive log files to not be copied to the secondary location which is used by SAP Replication Agent for Oracle (RAO). 
  • The archive logs were restored to the secondary location.
  • The log files are being treated as if they are missing. After doing a "ra_helparchive" command, these log files do not show up in the list (as either accessible or invalid).
  • How to get these missing archive log files to show up in the "ra_helparchive" list as being "Accessible".
  • RAO error log
    INFORMATION com.sybase.ds.oracle.logmnr.LogMinerStandbySc Standby LogMiner failed to start up due to ORA-01291: missing logfile
    INFORMATION com.sybase.ds.oracle.logmnr.LogMinerStandbySc ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    INFORMATION com.sybase.ds.oracle.logmnr.LogMinerStandbySc ORA-06512: at line 1
    INFORMATION com.sybase.ds.oracle.logmnr.LogMinerStandbySc after <3> retries.
    ERROR com.sybase.ra.lr.oracle.RAOTranReader Could not mine or match a * LogMiner record for record <LogMiner STARTSCN:  LogMiner ENDSCN: LogMiner options:[SYS.DBMS_LOGMNR.CONTINUOUS_MINE, SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG, SYS.DBMS_LOGMNR.NO_ROWID_IN_STMT] because: <ORA-01291: missing logfile
    ERROR com.sybase.ra.lr.oracle.RAOTranReader ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ERROR com.sybase.ra.lr.oracle.RAOTranReader ORA-06512: at line 1
    ERROR com.sybase.ra.lr.oracle.RAOTranReader >.
    ERROR com.sybase.ra.lr.oracle.RAOTranReader com.sybase.ds.oracle.OracleLogRecordProcessingException: Could not mine or match a * LogMiner record for record <LogMiner STARTSCN: LogMiner ENDSCN: LogMiner options:[SYS.DBMS_LOGMNR.CONTINUOUS_MINE, SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG, SYS.DBMS_LOGMNR.NO_ROWID_IN_STMT]. because: <ORA-01291: missing logfile
    ERROR com.sybase.ra.lr.oracle.RAOTranReader ORA-06512: at "SYS.DBMS_LOGMNR", line 58


Read more...

Environment

  • SAP Replication Server Options (RSO) for Oracle (All versions)
  • SAP Replication Server (SRS) (All versions)

Product

SAP Replication Server, option for Oracle all versions

Keywords

SRS, RS, RAO, missing archive log files, restore, ra_helparchive, archive directory, RMAN,crosscheck archivelog, ORA-01291, missing logfile, Replication Agent, ORA-16241: Waiting for gap log file, , KBA , BC-SYB-REP-RSO , Rep Server Options (RSO) , BC-SYB-REP , Sybase Replication Server (standalone) , HAN-DP-REP , SAP Sybase Replication Server , Problem

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.