Load Ingest Data
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15
Like Tree1Likes

Thread: CDC Service failure - Trying to retrieve next change record from source database.

  1. #11
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi Mike,

    As an imidiade solution, i suggest you delete old archive logs that were created before the last resetlog run. There are 2 ways in RMAN:

    1. BACKUP...DELETE, eg: BACKUP ARCHIVELOG FROM SCN X UNTIL SCN Y DELETE INPUT;

    2. CROSSCHECK...DELETE, eg:
    CROSSCHECK ARCHIVELOG ALL;
    DELETE EXPIRED ARCHIVELOG ALL;

    That will change the column STATUS from "A" to "D" which means deleted.


    Regards,


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

  2. #12
    Vader is offline Junior Member
    Join Date
    Oct 2013
    Location
    Russia
    Posts
    9
    Rep Power
    0
    Hi, Gadi!

    First of all thank you for your help!
    Sorry to say that, but it didn't work.
    Despite of deletion of "bad" sequence entries and cleaning up expired archive logs using RMAN,
    the error in CDC log just points to a next sequence number:

    Log #1
    timestamp,type,node,status,sub_status,status_messa ge,source, text_data,binary_data
    "26.10.2013 21:34:07","INFO","olaptest","RUNNING","INIT","ORAC DC300I:The Oracle CDC instance for service OracleCDCService1 and database MirrorCDC started.","service","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    Component Type:
    Component Name:
    at: 'oracle_source_allocate(...)'","source","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    Prepare
    at: 'oracle_source_prepare(...)'","source","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    Component Type:
    Component Name:
    at: 'oracle_source_allocate(...)'","source","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    Prepare
    at: 'oracle_source_prepare(...)'","source","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    at: 'oracle_source_set_stream(...)'","source","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Oracle CDC Capture start","source","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Oracle CDC Merger was allocated","source","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Adding redo logs to log miner session.","source","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG, Sequence: 560","source","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "26.10.2013 21:34:07","ERROR","olaptest","RUNNING","IDLE","ORA CDC514E:Failed to add redo log with sequence 559.","source","",""
    "26.10.2013 21:34:07","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Reading next record","source","",""
    "26.10.2013 21:34:08","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Adding redo logs to log miner session.","source","",""
    "26.10.2013 21:34:08","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG, Sequence: 560","source","",""
    "26.10.2013 21:34:08","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "26.10.2013 21:34:08","ERROR","olaptest","RUNNING","IDLE","ORA CDC514E:Failed to add redo log with sequence 559.","source","",""
    "26.10.2013 21:34:08","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Error encountered at set position - EOF simulated","source","",""
    "26.10.2013 21:34:08","ERROR","olaptest","RUNNING","IDLE","ORA CDC511E:The Oracle CDC failed to position.","source","",""
    "26.10.2013 21:34:17","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "26.10.2013 21:34:18","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Reading next record","source","",""
    "26.10.2013 21:34:18","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Adding redo logs to log miner session.","source","",""
    "26.10.2013 21:34:18","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG, Sequence: 560","source","",""
    "26.10.2013 21:34:18","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "26.10.2013 21:34:18","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC514E:Failed to add redo log with sequence 559.","source","",""
    "26.10.2013 21:34:18","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "26.10.2013 21:34:18","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC511E:The Oracle CDC failed to position.","source","",""
    "26.10.2013 21:34:27","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "26.10.2013 21:34:28","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Reading next record","source","",""
    "26.10.2013 21:34:28","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Adding redo logs to log miner session.","source","",""
    "26.10.2013 21:34:28","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG, Sequence: 560","source","",""
    "26.10.2013 21:34:28","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "26.10.2013 21:34:28","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC514E:Failed to add redo log with sequence 559.","source","",""
    "26.10.2013 21:34:28","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "26.10.2013 21:34:28","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC511E:The Oracle CDC failed to position.","source","",""
    "26.10.2013 21:34:37","INFO","olaptest","RUNNING","IDLE","ORAC DC303I:The Oracle CDC instance for service OracleCDCService1 and database MirrorCDC received a reconfigure signal.","service","",""
    "26.10.2013 21:34:37","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:** Debug / Announce input parameters. **
    at: 'oracle_source_notify(...)'","source","",""
    "26.10.2013 21:34:37","INFO","olaptest","RUNNING","IDLE","ORAC DC305I:The value of the option 'source_env_report' was changed to 1.","infrastructure","",""
    "26.10.2013 21:34:37","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "26.10.2013 21:34:37","REPORT","olaptest","SUSPENDED","LOGGER" ,"ORACDC000R:Oracle Diagnostics","infrastructure","
    Character set information:
    NLS_CHARACTERSET: 171
    LS_NCHAR_CHARACTERSET: 2000


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


    Redo logs:
    E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG (Sequence=560)
    E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG (Sequence=3821)


    Captured Tables:
    330972
    ",""

    ...

    Log #4:
    "26.10.2013 21:53:37","INFO","olaptest","RUNNING","INIT","ORAC DC300I:The Oracle CDC instance for service OracleCDCService1 and database MirrorCDC started.","service","",""
    "26.10.2013 21:53:37","INFO","olaptest","RUNNING","INIT","ORAC DC305I:The value of the option 'source_env_report' was changed to 3.","infrastructure","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    Component Type:
    Component Name:
    at: 'oracle_source_allocate(...)'","source","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    Prepare
    at: 'oracle_source_prepare(...)'","source","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    Component Type:
    Component Name:
    at: 'oracle_source_allocate(...)'","source","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    Prepare
    at: 'oracle_source_prepare(...)'","source","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    at: 'oracle_source_set_stream(...)'","source","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Oracle CDC Capture start","source","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Oracle CDC Merger was allocated","source","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Adding redo logs to log miner session.","source","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO03.LOG, Sequence: 570","source","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "26.10.2013 21:53:37","ERROR","olaptest","RUNNING","IDLE","ORA CDC514E:Failed to add redo log with sequence 569.","source","",""
    "26.10.2013 21:53:37","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Reading next record","source","",""
    "26.10.2013 21:53:38","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Adding redo logs to log miner session.","source","",""
    "26.10.2013 21:53:38","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO03.LOG, Sequence: 570","source","",""
    "26.10.2013 21:53:38","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "26.10.2013 21:53:38","ERROR","olaptest","RUNNING","IDLE","ORA CDC514E:Failed to add redo log with sequence 569.","source","",""
    "26.10.2013 21:53:38","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Error encountered at set position - EOF simulated","source","",""
    "26.10.2013 21:53:38","ERROR","olaptest","RUNNING","IDLE","ORA CDC511E:The Oracle CDC failed to position.","source","",""
    "26.10.2013 21:53:47","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "26.10.2013 21:53:48","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Reading next record","source","",""
    "26.10.2013 21:53:48","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Adding redo logs to log miner session.","source","",""
    "26.10.2013 21:53:48","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO03.LOG, Sequence: 570","source","",""
    "26.10.2013 21:53:48","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "26.10.2013 21:53:48","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC514E:Failed to add redo log with sequence 569.","source","",""
    "26.10.2013 21:53:48","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "26.10.2013 21:53:48","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC511E:The Oracle CDC failed to position.","source","",""
    "26.10.2013 21:53:57","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "26.10.2013 21:53:58","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Reading next record","source","",""
    "26.10.2013 21:53:58","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Adding redo logs to log miner session.","source","",""
    "26.10.2013 21:53:58","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO03.LOG, Sequence: 570","source","",""
    "26.10.2013 21:53:58","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "26.10.2013 21:53:58","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC514E:Failed to add redo log with sequence 569.","source","",""
    "26.10.2013 21:53:58","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "26.10.2013 21:53:58","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC511E:The Oracle CDC failed to position.","source","",""
    "26.10.2013 21:53:58","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC511E:The Oracle CDC failed to position.","source","",""
    "26.10.2013 21:53:58","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC511E:The Oracle CDC failed to position.","source","",""
    "26.10.2013 21:54:07","INFO","olaptest","RUNNING","IDLE","ORAC DC303I:The Oracle CDC instance for service OracleCDCService1 and database MirrorCDC received a reconfigure signal.","service","",""
    "26.10.2013 21:54:07","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:** Debug / Announce input parameters. **
    at: 'oracle_source_notify(...)'","source","",""
    "26.10.2013 21:54:07","INFO","olaptest","RUNNING","IDLE","ORAC DC305I:The value of the option 'source_env_report' was changed to 4.","infrastructure","",""
    "26.10.2013 21:54:07","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "26.10.2013 21:54:07","REPORT","olaptest","SUSPENDED","LOGGER" ,"ORACDC000R:Oracle Diagnostics","infrastructure","
    Character set information:
    NLS_CHARACTERSET: 171
    LS_NCHAR_CHARACTERSET: 2000


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


    Redo logs:
    E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO03.LOG (Sequence=570)
    E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG (Sequence=3821)


    Captured Tables:
    330972
    ",""
    "26.10.2013 21:54:08","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Reading next record","source","",""
    "26.10.2013 21:54:09","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Adding redo logs to log miner session.","source","",""
    "26.10.2013 21:54:09","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO03.LOG, Sequence: 570","source","",""
    "26.10.2013 21:54:09","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "26.10.2013 21:54:09","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC514E:Failed to add redo log with sequence 569.","source","",""
    "26.10.2013 21:54:09","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "26.10.2013 21:54:09","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC511E:The Oracle CDC failed to position.","source","",""




    Here is some additional info:
    Select * from v$archived_log WHERE STATUS != 'D';
    RECID STAMP NAME DEST_ID THREAD# SEQUENCE# RESETLOGS_CHANGE# RESETLOGS_TIME RESETLOGS_ID FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME BLOCKS BLOCK_SIZE CREATOR REGISTRAR STANDBY_DEST ARCHIVED APPLIED DELETED STATUS COMPLETION_TIME DICTIONARY_BEGIN DICTIONARY_END END_OF_REDO BACKUP_COUNT ARCHIVAL_THREAD# ACTIVATION# IS_RECOVERY_DEST_FILE COMPRESSED FAL END_OF_REDO_TYPE
    1 547468 819124770 E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG 1 1 3821 11968345998 19.02.2013 16:19:26 807812366 12101147676 25.06.2013 0:00:04 281474976710655 138340 512 RMAN RMAN NO NO NO NO A 26.06.2013 14:39:30 NO NO NO 0 0 0 NO NO NO
    2 547469 819124771 E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG 1 1 3819 11968345998 19.02.2013 16:19:26 807812366 12101016920 23.06.2013 0:01:53 12101081631 24.06.2013 0:01:59 188524 512 RMAN RMAN NO NO NO NO A 26.06.2013 14:39:31 NO NO NO 0 0 0 NO NO NO
    3 547470 819124771 E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO03.LOG 1 1 3820 11968345998 19.02.2013 16:19:26 807812366 12101081631 24.06.2013 0:01:59 12101147676 25.06.2013 0:00:04 188579 512 RMAN RMAN NO NO NO NO A 26.06.2013 14:39:31 NO NO NO 0 0 0 NO NO NO
    4 548592 829877852 J:\ORACLE\ORADATA\TEST\ARCHIVEARC561_0819124823.00 1 2 1 561 14718313851 26.06.2013 14:40:23 819124823 14742375842 27.10.2013 1:37:18 14742375850 27.10.2013 1:37:32 3 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:37:32 NO NO NO 1 1 2117267718 NO NO NO
    5 548594 829877858 J:\ORACLE\ORADATA\TEST\ARCHIVEARC562_0819124823.00 1 2 1 562 14718313851 26.06.2013 14:40:23 819124823 14742375850 27.10.2013 1:37:32 14742375858 27.10.2013 1:37:37 14 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:37:38 NO NO NO 1 1 2117267718 NO NO NO
    6 548596 829877859 J:\ORACLE\ORADATA\TEST\ARCHIVEARC563_0819124823.00 1 2 1 563 14718313851 26.06.2013 14:40:23 819124823 14742375858 27.10.2013 1:37:37 14742375861 27.10.2013 1:37:39 1 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:37:39 NO NO NO 1 1 2117267718 NO NO NO
    7 548598 829877861 J:\ORACLE\ORADATA\TEST\ARCHIVEARC564_0819124823.00 1 2 1 564 14718313851 26.06.2013 14:40:23 819124823 14742375861 27.10.2013 1:37:39 14742375863 27.10.2013 1:37:41 1 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:37:41 NO NO NO 1 1 2117267718 NO NO NO
    8 548600 829878469 J:\ORACLE\ORADATA\TEST\ARCHIVEARC565_0819124823.00 1 2 1 565 14718313851 26.06.2013 14:40:23 819124823 14742375863 27.10.2013 1:37:41 14742376871 27.10.2013 1:47:49 944 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:47:49 NO NO NO 1 1 2117267718 NO NO NO
    9 548601 829878471 E:\ORACLE\ARCH\ARC566_0819124823.001 1 1 566 14718313851 26.06.2013 14:40:23 819124823 14742376871 27.10.2013 1:47:49 14742376874 27.10.2013 1:47:51 2 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:47:51 NO NO NO 0 1 2117267718 NO NO NO
    10 548602 829878471 J:\ORACLE\ORADATA\TEST\ARCHIVEARC566_0819124823.00 1 2 1 566 14718313851 26.06.2013 14:40:23 819124823 14742376871 27.10.2013 1:47:49 14742376874 27.10.2013 1:47:51 2 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:47:51 NO NO NO 0 1 2117267718 NO NO NO
    11 548603 829878476 E:\ORACLE\ARCH\ARC567_0819124823.001 1 1 567 14718313851 26.06.2013 14:40:23 819124823 14742376874 27.10.2013 1:47:51 14742376879 27.10.2013 1:47:56 12 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:47:56 NO NO NO 0 1 2117267718 NO NO NO
    12 548604 829878476 J:\ORACLE\ORADATA\TEST\ARCHIVEARC567_0819124823.00 1 2 1 567 14718313851 26.06.2013 14:40:23 819124823 14742376874 27.10.2013 1:47:51 14742376879 27.10.2013 1:47:56 12 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:47:56 NO NO NO 0 1 2117267718 NO NO NO
    13 548605 829878478 E:\ORACLE\ARCH\ARC568_0819124823.001 1 1 568 14718313851 26.06.2013 14:40:23 819124823 14742376879 27.10.2013 1:47:56 14742376882 27.10.2013 1:47:58 1 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:47:58 NO NO NO 0 1 2117267718 NO NO NO
    14 548606 829878478 J:\ORACLE\ORADATA\TEST\ARCHIVEARC568_0819124823.00 1 2 1 568 14718313851 26.06.2013 14:40:23 819124823 14742376879 27.10.2013 1:47:56 14742376882 27.10.2013 1:47:58 1 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:47:58 NO NO NO 0 1 2117267718 NO NO NO
    15 548607 829878478 E:\ORACLE\ARCH\ARC569_0819124823.001 1 1 569 14718313851 26.06.2013 14:40:23 819124823 14742376882 27.10.2013 1:47:58 14742376889 27.10.2013 1:47:58 6 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:47:58 NO NO NO 0 1 2117267718 NO NO NO
    16 548608 829878478 J:\ORACLE\ORADATA\TEST\ARCHIVEARC569_0819124823.00 1 2 1 569 14718313851 26.06.2013 14:40:23 819124823 14742376882 27.10.2013 1:47:58 14742376889 27.10.2013 1:47:58 6 512 ARCH ARCH NO YES NO NO A 27.10.2013 1:47:58 NO NO NO 0 1 2117267718 NO NO NO





    I did try everything several times (RMAN cleanup + switching log files) in different combinations with no success.
    Do you have any other ideas how to make it work?

    Thanks in advance,
    Mike

  3. #13
    Vader is offline Junior Member
    Join Date
    Oct 2013
    Location
    Russia
    Posts
    9
    Rep Power
    0
    Hello, Gadi!

    The problem disappeared after installing latest hotfixes from cumulative update package 7 for SQL Server 2012 SP1 (Cumulative update package 7 for SQL Server 2012 SP1)

    1465483 2883524 FIX: "SCN not found" error when you use Connector for Oracle by Attunity and CDC for Oracle by Attunity in SQL Server 2012

    For x64 platform - 470565_intl_x64_zip.exe and 470566_intl_x64_zip.exe

    I'm pretty sure that it is your work.
    Thank you!

  4. #14
    Vader is offline Junior Member
    Join Date
    Oct 2013
    Location
    Russia
    Posts
    9
    Rep Power
    0
    Hello again!

    Although CDC seems to work fine - green sign, processing->idle statuses, increasing transaction and RW counters,
    destination tables in SQL Server are still empty!
    I assume that something is missing in settings.
    Could you please give a hand?

    PS. Finally I made it work!
    This one helped: http://channel9.msdn.com/Events/Tech...ca/2012/DBI322
    Last edited by Vader; 12-11-2013 at 05:59 AM.

  5. #15
    JohnTM is offline Junior Member
    Join Date
    Jun 2019
    Posts
    6
    Rep Power
    0
    Hi Vader,

    Apologies - I know this relates to a post from about 7 years ago(!) but...

    I am facing exactly the same problem now except with SQL Server 2017 and Oracle 12. Do you have any idea how you resolved the problem referred to?

    Regards,

    JohnM

    Quote Originally Posted by Vader View Post
    Hello again!

    Although CDC seems to work fine - green sign, processing->idle statuses, increasing transaction and RW counters,
    destination tables in SQL Server are still empty!
    I assume that something is missing in settings.
    Could you please give a hand?

    PS. Finally I made it work!
    This one helped: http://channel9.msdn.com/Events/Tech...ca/2012/DBI322

Page 2 of 2 FirstFirst 12

Tags for this Thread

Posting Permissions

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