Data Replication 2
Page 1 of 2 12 LastLast
Results 1 to 10 of 15
Like Tree1Likes

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

  1. #1
    sqldev_9 is offline Junior Member
    Join Date
    Jun 2012
    Posts
    2
    Rep Power
    0

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

    Hi everybody,

    I set up ARCHIVELOG mode on my oracle box. The CDC service setup via the MMC went fine. Started the service and if fails upon trying to process the first change in the source.

    I have no idea what is happening.


    *SQL> Archive Log List;
    Database log mode Archive log Mode
    Automatic archival Enabled
    Archive destination USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence 6
    Next log sequence to archive 8
    Current log sequence 8



    SQL> Select LOG_MODE, SUPPLEMENTAL_LOG_DATA_MIN From V$database;
    LOG_MODE SUPPLEMENTAL_LOG_DATA_MIN
    ------------ -------------------------
    ARCHIVELOG YES



    SQL> select * FROM DBA_LOG_GROUPS;
    OWNER LOG_GROUP_NAME TABLE_NAME LOG_GROUP_TYPE ALWAYS GENERATED
    ------------------------------ ------------------------------ ------------------------------ ------------------- ----------- --------------
    SYS ENC$_LOG_GRP ENC$ USER LOG GROUP ALWAYS USER NAME
    SCOTT MS_EMP2dbdba8e_00 EMP USER LOG GROUP ALWAYS USER NAME
    SCOTT MS_BONUS3c87b198_00 BONUS USER LOG GROUP ALWAYS USER NAME




    Diagnostics File
    "29/06/2012 5:33:20 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC514E:Failed to add redo log with sequence 6.","source","",""
    "29/06/2012 5:33:20 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC514E:Failed to add redo log with sequence 6.","source","",""
    "29/06/2012 5:33:20 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC511E:The Oracle CDC failed to position.","source","",""

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

    It looks like you are working with a new database. The Oracle CDC service is not capturing changes from redo logs with sequence# less that 10 and, It looks like the redo log in your environment has sequence# 6.


    To resolve the problem, run the following statement 5 times and then reset the CDC instance:
    Alter system switch logfile;




    Regards,

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

  3. #3
    sqldev_9 is offline Junior Member
    Join Date
    Jun 2012
    Posts
    2
    Rep Power
    0

    CDC failure

    Quote Originally Posted by Gadi.Farhat View Post
    Hi,

    It looks like you are working with a new database. The Oracle CDC service is not capturing changes from redo logs with sequence# less that 10 and, It looks like the redo log in your environment has sequence# 6.


    To resolve the problem, run the following statement 5 times and then reset the CDC instance:
    Alter system switch logfile;




    Regards,

    Gadi

    Thanks Gadi. I tried was you mentionned but no success.

    Sebastien

    The log now shows:


    "05/07/2012 1:55:07 PM","INFO","CAYMXL0084","RUNNING","INIT","ORACDC30 0I:The Oracle CDC instance for service OracleCDCService1 and database CDCService1 started.","service","",""
    "05/07/2012 1:55:07 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC514E:Failed to add redo log with sequence 18.","source","",""
    "05/07/2012 1:55:07 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC514E:Failed to add redo log with sequence 18.","source","",""
    "05/07/2012 1:55:07 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC511E:The Oracle CDC failed to position.","source","",""
    "05/07/2012 1:55:17 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC514E:Failed to add redo log with sequence 18.","source","",""
    "05/07/2012 1:55:17 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC511E:The Oracle CDC failed to position.","source","",""
    "05/07/2012 1:55:17 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC514E:Failed to add redo log with sequence 18.","source","",""
    "05/07/2012 1:55:17 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC511E:The Oracle CDC failed to position.","source","",""
    "05/07/2012 1:55:17 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC514E:Failed to add redo log with sequence 18.","source","",""
    "05/07/2012 1:55:17 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC511E:The Oracle CDC failed to position.","source","",""
    "05/07/2012 1:55:17 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC514E:Failed to add redo log with sequence 18.","source","",""
    "05/07/2012 1:55:17 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC511E:The Oracle CDC failed to position.","source","",""
    "05/07/2012 1:55:17 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC514E:Failed to add redo log with sequence 18.","source","",""
    "05/07/2012 1:55:17 PM","ERROR","CAYMXL0084","SUSPENDED","LOGGER","ORA CDC511E:The Oracle CDC failed to position.","source","",""
    "05/07/2012 1:56:36 PM","INFO","CAYMXL0084","RUNNING","IDLE","ORACDC30 3I:The Oracle CDC instance for service OracleCDCService1 and database CDCService1 received a reconfigure signal.","service","",""
    "05/07/2012 1:56:36 PM","INFO","CAYMXL0084","RUNNING","IDLE","ORACDC30 5I:The value of the option 'source_env_report' was changed to 1.","infrastructure","",""
    "05/07/2012 1:56:37 PM","REPORT","CAYMXL0084","SUSPENDED","LOGGER","OR ACDC000R:Oracle Diagnostics","infrastructure","
    Character set information:
    NLS_CHARACTERSET: 178
    LS_NCHAR_CHARACTERSET: 2000
    Reader Information:
    Thread: 1
    Last Transaction SCN: 0
    Last SCN: 1071729
    Greatest Sequence: 18
    Start SCN: 1071729
    Transaction Sequencer: 0
    Context Sequencer: 0
    Max SCN: 0
    Last RBASQN: 0
    Last RBABLK: 0
    Last RBABYTE: 0
    State: 0
    Redo logs:
    C:\ORACLE\ORADATA\ORCL\REDO03.LOG (Sequence=18)
    C:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012 _07_05\O1_MF_1_17_7ZC734W4_.ARC (Sequence=17)
    C:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012 _07_05\O1_MF_1_16_7ZC7307G_.ARC (Sequence=16)
    C:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012 _07_05\O1_MF_1_15_7ZC72ZT8_.ARC (Sequence=15)
    C:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012 _07_05\O1_MF_1_14_7ZC72XW1_.ARC (Sequence=14)
    C:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2012 _07_05\O1_MF_1_13_7ZC72VL0_.ARC (Sequence=13)
    Captured Tables:
    73198
    ",""

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

    This sounds like a privileges issue but, to see the error message returned by Oracle, please turn on detailed trace before the error occurs and send us the logs after the error occurs. To do that, you need to add the 'trace' property in the advanced properties tab of the CDC instance and set it to ‘SOURCE’.

    Then please use the Collect Diagnostics link from the Designer status tab, to create a file with the trace table contents and some additional status information, and attach the log.

    Finally, delete the 'trace' property row, it cause writing lot of trace info.


    Regards,

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

  5. #5
    Vader is offline Junior Member
    Join Date
    Oct 2013
    Location
    Russia
    Posts
    9
    Rep Power
    0
    I have an exact same problem. Stucked with LOGGER status with the message "Trying to retrieve next change record from source database."
    Did anyone solve this?
    Any help would be appreciated!

    Here's my diagnostic log:

    "24.10.2013 18:27:12","INFO","olaptest","RUNNING","INIT","ORAC DC300I:The Oracle CDC instance for service OracleCDC and database OracleCDC started.","service","",""
    "24.10.2013 18:27:12","INFO","olaptest","RUNNING","INIT","ORAC DC305I:The value of the option 'source_env_report' was changed to 1.","infrastructure","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    Component Type:
    Component Name:
    at: 'oracle_source_allocate(...)'","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    Prepare
    at: 'oracle_source_prepare(...)'","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    Component Type:
    Component Name:
    at: 'oracle_source_allocate(...)'","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    Prepare
    at: 'oracle_source_prepare(...)'","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","INIT","ORA CDC000T:** Debug / Announce input parameters. **
    at: 'oracle_source_set_stream(...)'","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Oracle CDC Capture start","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Oracle CDC Merger was allocated","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Adding redo logs to log miner session.","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG, Sequence: 545","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "24.10.2013 18:27:12","ERROR","olaptest","RUNNING","IDLE","ORA CDC514E:Failed to add redo log with sequence 544.","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Reading next record","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Adding redo logs to log miner session.","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG, Sequence: 545","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "24.10.2013 18:27:12","ERROR","olaptest","RUNNING","IDLE","ORA CDC514E:Failed to add redo log with sequence 544.","source","",""
    "24.10.2013 18:27:12","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Error encountered at set position - EOF simulated","source","",""
    "24.10.2013 18:27:12","ERROR","olaptest","RUNNING","IDLE","ORA CDC511E:The Oracle CDC failed to position.","source","",""
    "24.10.2013 18:27:22","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "24.10.2013 18:27:22","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Reading next record","source","",""
    "24.10.2013 18:27:22","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Adding redo logs to log miner session.","source","",""
    "24.10.2013 18:27:22","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG, Sequence: 545","source","",""
    "24.10.2013 18:27:22","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "24.10.2013 18:27:22","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC514E:Failed to add redo log with sequence 544.","source","",""
    "24.10.2013 18:27:22","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "24.10.2013 18:27:22","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC511E:The Oracle CDC failed to position.","source","",""
    "24.10.2013 18:27:32","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "24.10.2013 18:27:32","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Reading next record","source","",""
    "24.10.2013 18:27:33","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Adding redo logs to log miner session.","source","",""
    "24.10.2013 18:27:33","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG, Sequence: 545","source","",""
    "24.10.2013 18:27:33","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "24.10.2013 18:27:33","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC514E:Failed to add redo log with sequence 544.","source","",""
    "24.10.2013 18:27:33","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "24.10.2013 18:27:33","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC511E:The Oracle CDC failed to position.","source","",""
    "24.10.2013 18:27:41","INFO","olaptest","RUNNING","IDLE","ORAC DC303I:The Oracle CDC instance for service OracleCDC and database OracleCDC received a reconfigure signal.","service","",""
    "24.10.2013 18:27:41","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:** Debug / Announce input parameters. **
    at: 'oracle_source_notify(...)'","source","",""
    "24.10.2013 18:27:41","INFO","olaptest","RUNNING","IDLE","ORAC DC305I:The value of the option 'source_env_report' was changed to 2.","infrastructure","",""
    "24.10.2013 18:27:41","TRACE","olaptest","RUNNING","IDLE","ORA CDC000T:Retrieving current SCN","source","",""
    "24.10.2013 18:27:42","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: 14742005391
    Greatest Sequence: 545
    Start SCN: 14742005391
    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=545)
    E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG (Sequence=3821)


    Captured Tables:
    339997
    ",""
    "24.10.2013 18:27:43","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Reading next record","source","",""
    "24.10.2013 18:27:43","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Adding redo logs to log miner session.","source","",""
    "24.10.2013 18:27:43","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG, Sequence: 545","source","",""
    "24.10.2013 18:27:43","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Redo log: E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG, Sequence: 3821","source","",""
    "24.10.2013 18:27:43","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC514E:Failed to add redo log with sequence 544.","source","",""
    "24.10.2013 18:27:43","TRACE","olaptest","SUSPENDED","LOGGER", "ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "24.10.2013 18:27:43","ERROR","olaptest","SUSPENDED","LOGGER", "ORACDC511E:The Oracle CDC failed to position.","source","",""

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

    The sequence numbers of the redo logs that the Change Data Capture is trying to add and failing are 3821 and 545.

    The numbers are not sequential, did you run reset log on the source database lately?

    Anyway, please attach a recent log file created by collect diagnostics and the result of running the following queries on the source Oracle database:

    Select * from v$log;

    Select * from v$logfile;

    Select * from v$archived_log;


    Regards,

    Gadi
    Vader likes this.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  7. #7
    Vader is offline Junior Member
    Join Date
    Oct 2013
    Location
    Russia
    Posts
    9
    Rep Power
    0
    Hello, Gadi! Thank you for your response!

    Yes, recently I did try to reset log according to your recommendation here:
    http://www.attunity.com/forums/attun....html#post3657
    I attached a zipped log file to this post (it's pretty big).

    The output to these queries:

    Select * from v$log;
    GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME

    1 1 1 547 104857600 1 NO CURRENT 14742019988 25.10.2013 0:03:03
    2 2 1 545 104857600 1 YES INACTIVE 14742005040 24.10.2013 22:25:39
    3 3 1 546 104857600 1 YES INACTIVE 14742019016 25.10.2013 0:03:01

    Select * from v$logfile;
    GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE

    1 1 ONLINE E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG NO
    2 2 ONLINE E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG NO
    3 3 ONLINE E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO03.LOG NO

    Select * from v$archived_log; -- this one is big too. See second attachement please, it's in xls format
    Attached Files Attached Files

  8. #8
    Vader is offline Junior Member
    Join Date
    Oct 2013
    Location
    Russia
    Posts
    9
    Rep Power
    0
    Hi Gadi, thank you for your response!

    My last post wasn't published for some reason. Maybe because of attachments?
    OK, I'll try one more time.

    Yes, I did the log reset according to your recommendation here: http://www.attunity.com/forums/attun....html#post3657

    SQL> Select * from v$log;


    GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
    ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
    1 1 547 104857600 1 NO CURRENT 14742019988 25.10.2013
    2 1 545 104857600 1 YES INACTIVE 14742005040 24.10.2013
    3 1 546 104857600 1 YES INACTIVE 14742019016 25.10.2013

    SQL> Select * from v$logfile;


    GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
    ---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
    1 ONLINE E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG NO
    2 ONLINE E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG NO
    3 ONLINE E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO03.LOG NO




    See attachements for an archived_log and a CDC log.

    Thank you!
    Attached Files Attached Files

  9. #9
    Vader is offline Junior Member
    Join Date
    Oct 2013
    Location
    Russia
    Posts
    9
    Rep Power
    0
    Hi Gadi, thank you for your response!

    My last posts wasn't published for some reason. Maybe because of attachments?

    Yes, I did the log reset according to your recommendation here: http://www.attunity.com/forums/attun....html#post3657
    See attachement for CDC log: cdc_log.zip.

    SQL> Select * from v$log;



    GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
    ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
    1 1 547 104857600 1 NO CURRENT 14742019988 25.10.2013
    2 1 545 104857600 1 YES INACTIVE 14742005040 24.10.2013
    3 1 546 104857600 1 YES INACTIVE 14742019016 25.10.2013

    SQL> Select * from v$logfile;


    GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
    ---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
    1 ONLINE E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG NO
    2 ONLINE E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG NO
    3 ONLINE E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO03.LOG NO




    A portion of archived_log
    : archived_log.zip

    SQL> Select * from v$archived_log;



    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
    ---------- ---------- -------------------------------------------------------------------------------- ---------- ---------- ---------- ----------------- -------------- ------------ ------------- ----------- ------------ ----------- ---------- ---------- ------- --------- ------------ -------- ------- ------- ------ --------------- ---------------- -------------- ----------- ------------ ---------------- ----------- --------------------- ---------- --- ----------------
    539603 816684155 2 1 10756 12943707651 25.03.2013 1:4 810956753 14196528608 29.05.2013 14196726027 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:42 NO NO NO 1 1 2109150034 NO NO NO
    539604 816684267 1 1 10757 12943707651 25.03.2013 1:4 810956753 14196726027 29.05.2013 14196923760 29.05.2013 198359 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:44 NO NO NO 1 1 2109150034 NO NO NO
    539605 816684267 2 1 10757 12943707651 25.03.2013 1:4 810956753 14196726027 29.05.2013 14196923760 29.05.2013 198359 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:44 NO NO NO 1 1 2109150034 NO NO NO
    539606 816684380 1 1 10758 12943707651 25.03.2013 1:4 810956753 14196923760 29.05.2013 14197120909 29.05.2013 198359 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:46 NO NO NO 1 1 2109150034 NO NO NO
    539607 816684380 2 1 10758 12943707651 25.03.2013 1:4 810956753 14196923760 29.05.2013 14197120909 29.05.2013 198359 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:46 NO NO NO 1 1 2109150034 NO NO NO
    539608 816684482 1 1 10759 12943707651 25.03.2013 1:4 810956753 14197120909 29.05.2013 14197314094 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:48 NO NO NO 1 1 2109150034 NO NO NO
    539609 816684482 2 1 10759 12943707651 25.03.2013 1:4 810956753 14197120909 29.05.2013 14197314094 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:48 NO NO NO 1 1 2109150034 NO NO NO
    539610 816684585 1 1 10760 12943707651 25.03.2013 1:4 810956753 14197314094 29.05.2013 14197511269 29.05.2013 198359 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:49 NO NO NO 1 1 2109150034 NO NO NO
    539611 816684585 2 1 10760 12943707651 25.03.2013 1:4 810956753 14197314094 29.05.2013 14197511269 29.05.2013 198359 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:49 NO NO NO 1 1 2109150034 NO NO NO
    539612 816684632 1 1 10761 12943707651 25.03.2013 1:4 810956753 14197511269 29.05.2013 14197590134 29.05.2013 200331 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:50 NO NO NO 1 1 2109150034 NO NO NO
    539613 816684632 2 1 10761 12943707651 25.03.2013 1:4 810956753 14197511269 29.05.2013 14197590134 29.05.2013 200331 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:50 NO NO NO 1 1 2109150034 NO NO NO
    539614 816684681 1 1 10762 12943707651 25.03.2013 1:4 810956753 14197590134 29.05.2013 14197679687 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:51 NO NO NO 1 1 2109150034 NO NO NO
    539615 816684681 2 1 10762 12943707651 25.03.2013 1:4 810956753 14197590134 29.05.2013 14197679687 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:51 NO NO NO 1 1 2109150034 NO NO NO
    539616 816684800 1 1 10763 12943707651 25.03.2013 1:4 810956753 14197679687 29.05.2013 14197872581 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:53 NO NO NO 1 1 2109150034 NO NO NO
    539617 816684800 2 1 10763 12943707651 25.03.2013 1:4 810956753 14197679687 29.05.2013 14197872581 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:53 NO NO NO 1 1 2109150034 NO NO NO
    539618 816684913 1 1 10764 12943707651 25.03.2013 1:4 810956753 14197872581 29.05.2013 14198069457 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:55 NO NO NO 1 1 2109150034 NO NO NO
    539619 816684913 2 1 10764 12943707651 25.03.2013 1:4 810956753 14197872581 29.05.2013 14198069457 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:55 NO NO NO 1 1 2109150034 NO NO NO
    539620 816685018 1 1 10765 12943707651 25.03.2013 1:4 810956753 14198069457 29.05.2013 14198266807 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:56 NO NO NO 1 1 2109150034 NO NO NO
    539621 816685018 2 1 10765 12943707651 25.03.2013 1:4 810956753 14198069457 29.05.2013 14198266807 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:56 NO NO NO 1 1 2109150034 NO NO NO
    539622 816685137 1 1 10766 12943707651 25.03.2013 1:4 810956753 14198266807 29.05.2013 14198464108 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:58 NO NO NO 1 1 2109150034 NO NO NO



    Thank you!

  10. #10
    Vader is offline Junior Member
    Join Date
    Oct 2013
    Location
    Russia
    Posts
    9
    Rep Power
    0
    Hi Gadi, thank you for your response!


    My last posts wasn't published for some reason. Maybe because of attachments?


    Yes, I did the log reset according to your recommendation here: http://www.attunity.com/forums/attun....html#post3657
    See attachement for CDC log: cdc_log.zip.


    SQL> Select * from v$log;




    GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
    ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
    1 1 547 104857600 1 NO CURRENT 14742019988 25.10.2013
    2 1 545 104857600 1 YES INACTIVE 14742005040 24.10.2013
    3 1 546 104857600 1 YES INACTIVE 14742019016 25.10.2013


    SQL> Select * from v$logfile;




    GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
    ---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
    1 ONLINE E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO01.LOG NO
    2 ONLINE E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO02.LOG NO
    3 ONLINE E:\ORACLE\ORADATA\TEST\REDOLOGS\REDO03.LOG NO








    A portion of archived_log (sorry for cutting it down, I can't figure out how to attach 900KB file here):


    SQL> Select * from v$archived_log;




    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
    ---------- ---------- -------------------------------------------------------------------------------- ---------- ---------- ---------- ----------------- -------------- ------------ ------------- ----------- ------------ ----------- ---------- ---------- ------- --------- ------------ -------- ------- ------- ------ --------------- ---------------- -------------- ----------- ------------ ---------------- ----------- --------------------- ---------- --- ----------------
    539603 816684155 2 1 10756 12943707651 25.03.2013 1:4 810956753 14196528608 29.05.2013 14196726027 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:42 NO NO NO 1 1 2109150034 NO NO NO
    539604 816684267 1 1 10757 12943707651 25.03.2013 1:4 810956753 14196726027 29.05.2013 14196923760 29.05.2013 198359 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:44 NO NO NO 1 1 2109150034 NO NO NO
    539605 816684267 2 1 10757 12943707651 25.03.2013 1:4 810956753 14196726027 29.05.2013 14196923760 29.05.2013 198359 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:44 NO NO NO 1 1 2109150034 NO NO NO
    539606 816684380 1 1 10758 12943707651 25.03.2013 1:4 810956753 14196923760 29.05.2013 14197120909 29.05.2013 198359 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:46 NO NO NO 1 1 2109150034 NO NO NO
    539607 816684380 2 1 10758 12943707651 25.03.2013 1:4 810956753 14196923760 29.05.2013 14197120909 29.05.2013 198359 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:46 NO NO NO 1 1 2109150034 NO NO NO
    539608 816684482 1 1 10759 12943707651 25.03.2013 1:4 810956753 14197120909 29.05.2013 14197314094 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:48 NO NO NO 1 1 2109150034 NO NO NO
    539609 816684482 2 1 10759 12943707651 25.03.2013 1:4 810956753 14197120909 29.05.2013 14197314094 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:48 NO NO NO 1 1 2109150034 NO NO NO
    539610 816684585 1 1 10760 12943707651 25.03.2013 1:4 810956753 14197314094 29.05.2013 14197511269 29.05.2013 198359 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:49 NO NO NO 1 1 2109150034 NO NO NO
    539611 816684585 2 1 10760 12943707651 25.03.2013 1:4 810956753 14197314094 29.05.2013 14197511269 29.05.2013 198359 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:49 NO NO NO 1 1 2109150034 NO NO NO
    539612 816684632 1 1 10761 12943707651 25.03.2013 1:4 810956753 14197511269 29.05.2013 14197590134 29.05.2013 200331 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:50 NO NO NO 1 1 2109150034 NO NO NO
    539613 816684632 2 1 10761 12943707651 25.03.2013 1:4 810956753 14197511269 29.05.2013 14197590134 29.05.2013 200331 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:50 NO NO NO 1 1 2109150034 NO NO NO
    539614 816684681 1 1 10762 12943707651 25.03.2013 1:4 810956753 14197590134 29.05.2013 14197679687 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:51 NO NO NO 1 1 2109150034 NO NO NO
    539615 816684681 2 1 10762 12943707651 25.03.2013 1:4 810956753 14197590134 29.05.2013 14197679687 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:51 NO NO NO 1 1 2109150034 NO NO NO
    539616 816684800 1 1 10763 12943707651 25.03.2013 1:4 810956753 14197679687 29.05.2013 14197872581 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:53 NO NO NO 1 1 2109150034 NO NO NO
    539617 816684800 2 1 10763 12943707651 25.03.2013 1:4 810956753 14197679687 29.05.2013 14197872581 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:53 NO NO NO 1 1 2109150034 NO NO NO
    539618 816684913 1 1 10764 12943707651 25.03.2013 1:4 810956753 14197872581 29.05.2013 14198069457 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:55 NO NO NO 1 1 2109150034 NO NO NO
    539619 816684913 2 1 10764 12943707651 25.03.2013 1:4 810956753 14197872581 29.05.2013 14198069457 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:55 NO NO NO 1 1 2109150034 NO NO NO
    539620 816685018 1 1 10765 12943707651 25.03.2013 1:4 810956753 14198069457 29.05.2013 14198266807 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:56 NO NO NO 1 1 2109150034 NO NO NO
    539621 816685018 2 1 10765 12943707651 25.03.2013 1:4 810956753 14198069457 29.05.2013 14198266807 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:56 NO NO NO 1 1 2109150034 NO NO NO
    539622 816685137 1 1 10766 12943707651 25.03.2013 1:4 810956753 14198266807 29.05.2013 14198464108 29.05.2013 198360 512 ARCH ARCH NO YES NO YES D 29.05.2013 8:58 NO NO NO 1 1 2109150034 NO NO NO






    Mike

Page 1 of 2 12 LastLast

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
  •