IBM Support

IBM InfoSphere CDC: Redo log file information not found for mirroring

Troubleshooting


Problem

Mirror fails with the below error message: 2014-07-22 16:54:58.918    SHAREDSCRAPE LOG READER:2{787}    com.datamirror.ts.util.oracle.OracleRedoNativeApi    logEventCallback()    Redo log file information not found for subscription SHAREDSCRAPE. The Oracle database does not contain valid redo log file information corresponding to the log position '13754300094643.0.0.0.0.0.0' for the current database incarnation. Error detected in file OracleRedoNativeApi.java at line 1178. This may be caused by any of the following: a) The SCN portion of the log position 13754300094643.0.0.0.0.0.0 is invalid. b) The SCN associated with log position 13754300094643.0.0.0.0.0.0 does not correspond to a current on-line redo log file and ARCHIVELOG mode is not enabled. c) The redo log file(s) corresponding to log position 13754300094643.0.0.0.0.0.0 does not currently exist, exists but is inaccessible or exists and is corrupt. d) The control file contains invalid information. e) The database was shut down abort. Re-start replication will resolve this issue. f) There was error archiving redo logs because of insufficient disk space. Try to resolve this issue by doing the following and re-start replication: a) Change the log position to specify a correct SCN value. b) Examine the views V$LOG and V$ARCHIVED_LOG to determine a valid SCN for which a corresponding online or archived redo log file exists. Change the log position to specify a valid SCN for the current database incarnation. c) Restore a valid copy of the required redo log file(s) from backup. d) Ensure the disk space for archived redo logs is not full. The following configuration is checked: 1. The according redo log exists properly. 2. The CDC user has appropriate privileges to access Oracle log files. 3. All the configuration in CDC looks correct. Why does the problem still happen?

[{"Product":{"code":"SSX3HK","label":"InfoSphere Change Data Capture"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"6.5.2;10.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
16 June 2018

UID

swg21681778