Get Data Moving 1
Results 1 to 8 of 8

Thread: ORACDC514E:Failed to add redo log with sequence

  1. #1
    Attinuityuser2012 is offline Junior Member
    Join Date
    Nov 2012
    Posts
    2
    Rep Power
    0

    ORACDC514E:Failed to add redo log with sequence

    Hi when we start the CDC instance we get below error, Is this a permission issue?

    timestamp,type,node,status,sub_status,status_messa ge,source, text_data,binary_data
    "11/27/2012 4:44:28 PM","INFO","DOV-DC4-V019","RUNNING","INIT","ORACDC300I:The Oracle CDC instance for service OracleCDCService1 and database CDCTEST1 started.","service","",""

    "11/27/2012 4:44:28 PM","ERROR","DOV-DC4-V019","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 193.","source","",""

    "11/27/2012 4:44:29 PM","ERROR","DOV-DC4-V019","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 193.","source","",""
    "11/27/2012 4:44:29 PM","ERROR","DOV-DC4-V019","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/27/2012 4:44:39 PM","ERROR","DOV-DC4-V019","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 193.","source","",""
    "11/27/2012 4:44:39 PM","ERROR","DOV-DC4-V019","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    9
    This usually happens when the source database is running in NOARCHIVELOG mode and not in ARCHIVELOG mode and therefore, the change capture is not able to read the changes.

    To check that, you can run the following query agains your source Oracle database:

    SELECT LOG_MODE FROM V$DATABASE;


    If that is the case, then you need to change the database to run in ARCHIVELOG mode. You can do that by running the following:

    ALTER DATABASE ARCHIVELOG;


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    Attinuityuser2012 is offline Junior Member
    Join Date
    Nov 2012
    Posts
    2
    Rep Power
    0
    Thankas Gadi,

    I did check that, Database is running on ARCHIVELOG mode. Can there be any permissions issues for creating redo log?

  4. #4
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    9
    Hi,

    It doesn't look related to privileges isuues but anyway, verify you have EXECUTE privileges on DBMS_LOGMNR.

    You should make sure that the archive logs are available for enough time before they are deleted.


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  5. #5
    bobbywallace is offline Junior Member
    Join Date
    Jun 2015
    Posts
    2
    Rep Power
    0

    ORACDC514E:Failed to add redo log with sequence

    I believe we are experiencing the same (or closely related) issue:

    ORACDC000T:Reading next record
    ORACDC000T:Adding redo logs to log miner session.
    ORACDC000T:Redo log: /oralogssd1/oraprod/redo21_1.log, Sequence: 10
    ORACDC000T:Redo log: /oralogssd2/oraprod/redo22_1.log, Sequence: 10
    ORACDC514E:Failed to add redo log with sequence 10.
    ORACDC000T:Error encountered at set position - EOF simulated
    ORACDC511E:The Oracle CDC failed to position.
    ORACDC000T:Retrieving current SCN
    ORACDC000T:Reading next record

    CDC Service Configuration - version: 2.0.0.0
    CDC Designer - version: 2.0.0.0
    SQL Server 2012 - version:
    Microsoft SQL Server 2012 - 11.0.5343.0 (X64)
    May 4 2015 19:11:32
    Copyright (c) Microsoft Corporation
    Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
    Oracle - version: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

    The service immediately goes into LOGGER mode.

    Any help would be greatly appreciated.

    -Bobby

  6. #6
    bobbywallace is offline Junior Member
    Join Date
    Jun 2015
    Posts
    2
    Rep Power
    0

    ORACDC514E:Failed to add redo log with sequence

    I should add:


    • Database is running in ARCHIVELOG mode
    • User has EXECUTE privileges on DBMS_LOGMNR


    Thanks in advance,
    -Bobby
    Attached Files Attached Files

  7. #7
    SrinivasK is offline Junior Member
    Join Date
    Apr 2017
    Posts
    1
    Rep Power
    0

    ORACDC514E:Failed to add redo log with sequence 1058.

    timestamp,type,node,status,sub_status,status_messa ge,source, text_data,binary_data
    "4/25/2017 7:06:30 AM","INFO","","RUNNING","INIT","ORACDC300I:The Oracle CDC instance for service OracleCDCService and database CDC04252017 started.","service","",""
    "4/25/2017 7:06:31 AM","ERROR",","SUSPENDED","LOGGER","ORACDC514E:Fai led to add redo log with sequence 1058.","source","",""
    "4/25/2017 7:06:31 AM","ERROR","","SUSPENDED","LOGGER","ORACDC514E:Fa iled to add redo log with sequence 1058.","source","",""
    "4/25/2017 7:06:31 AM","ERROR","","SUSPENDED","LOGGER","ORACDC511E:Th e Oracle CDC failed to position.","source","",""
    "4/25/2017 7:06:42 AM","ERROR","","SUSPENDED","LOGGER","ORACDC514E:Fa iled to add redo log with sequence 1058.","source","",""
    "4/25/2017 7:06:42 AM","ERROR","","SUSPENDED","LOGGER","ORACDC511E:Th e Oracle CDC failed to position.","source","",""
    "4/25/2017 7:07:30 AM","INFO","","RUNNING","IDLE","ORACDC303I:The Oracle CDC instance for service OracleCDCService and database CDC04252017 received a reconfigure signal.","service","",""
    "4/25/2017 7:07:30 AM","INFO","","RUNNING","IDLE","ORACDC305I:The value of the option 'source_env_report' was changed to 1.","infrastructure","",""
    "4/25/2017 7:07:31 AM","REPORT","","SUSPENDED","LOGGER","ORACDC000R:O racle Diagnostics","infrastructure","
    CDC Service version is: 4.0.0.15


    Character set information:
    NLS_CHARACTERSET: 178
    LS_NCHAR_CHARACTERSET: 2000


    Reader Information:
    Thread: 1
    Last Transaction SCN: 0
    Last SCN: 59600555
    Greatest Sequence: 1058
    Start SCN: 59600555
    Transaction Sequencer: 0
    Context Sequencer: 0
    Max SCN: 0
    Last RBASQN: 0
    Last RBABLK: 0
    Last RBABYTE: 0
    State: 0


    Redo logs:
    C:\APP\ORADATA\ORCL\REDO02.LOG (Sequence=1058)


    Captured Tables:
    81544
    ",""

    I am getting the above message and CDC service status is 'LOGGING'. Could you please help me?

    Thanks,
    Srinivas

  8. #8
    ciska@sun.ac.za is offline Junior Member
    Join Date
    May 2017
    Posts
    1
    Rep Power
    0

    Solution for ORACDC514E

    Quote Originally Posted by bobbywallace View Post
    I should add:


    • Database is running in ARCHIVELOG mode
    • User has EXECUTE privileges on DBMS_LOGMNR


    Thanks in advance,
    -Bobby
    What is the solution for this problem?
    I am unable to find anything on this - other than recreating the whole instance, which is not an option.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •