Data Replication 2
Results 1 to 5 of 5

Thread: CDC hang in logger mode due to standby database

  1. #1
    minh is offline Junior Member
    Join Date
    Oct 2012
    Posts
    6
    Rep Power
    0

    CDC hang in logger mode due to standby database

    Hi,

    We have from time to time the CDC blocking in "LOGGER" mode and we cannot resume it to the "PROCESS" mode
    in the diagnostics file it seems that CDC try to retrieve the log files from our STANDBY database instead of the Primary one..
    and we don't know why it suddenly do that as the primary Db never had any availability problem ..

    is there any way to tell him not to do the switch ??


    here is the content of our trace file:

    in the connect string it's pointing at "ITASTB" our standby DB

    Thanks for your help
    Minh

    /* ************************************************** **************************** */

    timestamp,type,node,status,sub_status,status_messa ge,source, text_data,binary_data
    "3/21/2013 8:14:52 AM","INFO","bel-cdm-psql","RUNNING","IDLE","ORACDC303I:The Oracle CDC instance for service ECBI_CDC and database ECBI_CDC_ITA_EAC received a reconfigure signal.","service","",""
    "3/21/2013 8:14:52 AM","INFO","bel-cdm-psql","RUNNING","IDLE","ORACDC305I:The value of the option 'source_env_report' was changed to 2.","infrastructure","",""
    "3/21/2013 8:14:52 AM","REPORT","bel-cdm-psql","SUSPENDED","LOGGER","ORACDC000R:Oracle Diagnostics","infrastructure","
    Character set information:
    NLS_CHARACTERSET: 178
    LS_NCHAR_CHARACTERSET: 2000

    Reader Information:
    Thread: 1
    Last Transaction SCN: 9924817829358
    Last SCN: 9924817829358
    Greatest Sequence: 100072
    Start SCN: 9924817829358
    Transaction Sequencer: 1
    Context Sequencer: 0
    Max SCN: 9924817829544
    Last RBASQN: 100046
    Last RBABLK: -1
    Last RBABYTE: 65535
    State: 4

    Redo logs:
    /tablespaces/oradata/ITA_EAC/redo01.log (Sequence=100072)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100071)
    /flashrecovery/ITA_EAC/archivelog/2013_03_21/o1_mf_1_100071_8nohf333_.arc (Sequence=100071)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100070)
    /flashrecovery/ITA_EAC/archivelog/2013_03_21/o1_mf_1_100070_8nof7fp2_.arc (Sequence=100070)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100069)
    /flashrecovery/ITA_EAC/archivelog/2013_03_21/o1_mf_1_100069_8noc3rox_.arc (Sequence=100069)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100068)
    /flashrecovery/ITA_EAC/archivelog/2013_03_21/o1_mf_1_100068_8nnxyzdb_.arc (Sequence=100068)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100067)
    /flashrecovery/ITA_EAC/archivelog/2013_03_21/o1_mf_1_100067_8nno56t8_.arc (Sequence=100067)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100066)
    /flashrecovery/ITA_EAC/archivelog/2013_03_21/o1_mf_1_100066_8nnkvmrj_.arc (Sequence=100066)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100065)
    /flashrecovery/ITA_EAC/archivelog/2013_03_21/o1_mf_1_100065_8nnjdvhm_.arc (Sequence=100065)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100064)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100064_8nndd421_.arc (Sequence=100064)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100063)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100063_8nnbxvk0_.arc (Sequence=100063)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100062)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100062_8nn9qbfq_.arc (Sequence=100062)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100061)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100061_8nn9n2f7_.arc (Sequence=100061)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100060)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100060_8nn9hmxq_.arc (Sequence=100060)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100059)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100059_8nn9bsdp_.arc (Sequence=100059)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100058)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100058_8nn9503g_.arc (Sequence=100058)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100057)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100057_8nn8zgsp_.arc (Sequence=100057)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100056)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100056_8nn8vwrr_.arc (Sequence=100056)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100055)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100055_8nn7wykl_.arc (Sequence=100055)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100054)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100054_8nn7s57r_.arc (Sequence=100054)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100053)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100053_8nn7q0y9_.arc (Sequence=100053)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100052)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100052_8nn7pnoy_.arc (Sequence=100052)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100051)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100051_8nn7pbd6_.arc (Sequence=100051)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100050)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100050_8nn7os3o_.arc (Sequence=100050)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100049)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100049_8nn7o8mc_.arc (Sequence=100049)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100048)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100048_8nn7nl8v_.arc (Sequence=100048)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100047)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100047_8nn7l6xh_.arc (Sequence=100047)
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp) (HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVI CE_NAME=ITASTB_XPT.WORLD)(INSTANCE_NAME=ITASTB)(SE RVER=dedicated))) (Sequence=100046)
    /flashrecovery/ITA_EAC/archivelog/2013_03_20/o1_mf_1_100046_8nn7h9ql_.arc (Sequence=100046)

    Captured Tables:
    58609
    58598
    58539
    58462
    ",""

    /* ************************************************** ************************************** */

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


    First, please let me know why are saying that the CDC Instance is trying to access logs in the standby database? Is the redo log file path specified below belong to the standby instance?


    Also, please run the following query and attach the results:
    Select * from v$archived_log;


    Regards,

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

  3. #3
    minh is offline Junior Member
    Join Date
    Oct 2012
    Posts
    6
    Rep Power
    0
    Quote Originally Posted by Gadi.Farhat View Post
    Hi Minh,


    First, please let me know why are saying that the CDC Instance is trying to access logs in the standby database? Is the redo log file path specified below belong to the standby instance?


    Also, please run the following query and attach the results:
    Select * from v$archived_log;


    Regards,

    Gadi

    Hi Gadi,

    yes, the path specified point to our stand by database => ITASTB
    our primary database is ITA_EAC

    you can find in attach the result of the query

    thanks
    Minh
    Attached Files Attached Files

  4. #4
    SallyHabib is offline Junior Member
    Join Date
    Apr 2013
    Posts
    1
    Rep Power
    0
    Dears,

    We have the same problem, did you find a fix for it?

    Thanks

  5. #5
    minh is offline Junior Member
    Join Date
    Oct 2012
    Posts
    6
    Rep Power
    0

    Post

    no ,
    i still haven't find any solution for this issue :(

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
  •