1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle GG extract abending with error OGG-00446

Discussion in 'Server Administration and Options' started by kalyanz, Sep 3, 2014.

  1. kalyanz

    kalyanz Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Hi All,

    As part of upgrade project on source side, source team is upgrading database from oracle 10g to 11g and applications from 11.5.9 to 11.5.10.2. During which source team is shutting down GG services, disabling supplement logging, disabling archivelogs. Once upgrade activity is completed , enabling archive logs, supplement logging. Due to some communication gap between source team and target team , after two days from db upgrade is done , GG services are started on source side and extract got abended with below error on source side.



    ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, XXXXX.prm: Could not find archived log for sequence 17 thread 1 under default destinations SQL <SELECT name FROM v$archived_log WHERE sequence# = :eek:ra_seq_no AND thread# = :eek:ra_thread AND resetlogs_id = :eek:ra_resetlog_id AND archived = 'YES' AND deleted = 'NO' AND name not like '+%' AND standby_dest = 'NO' >, error retrieving redo file name for sequence 17, archived = 1, use_alternate = 0 Not able to establish initial position for sequence 17, rba 565905936.
    2014-09-02 12:04:38 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, XXXX.prm: PROCESS ABENDING.
    2014-09-02 12:04:38 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, XXXX.prm: Could not find archived log for sequence 17 thread 1 under default destinations SQL <SELECT name FROM v$archived_log WHERE sequence# = :eek:ra_seq_no AND thread# = :eek:ra_thread AND resetlogs_id = :eek:ra_resetlog_id AND archived = 'YES' AND deleted = 'NO' AND name not like '+%' AND standby_dest = 'NO' >, error retrieving redo file name for sequence 17, archived = 1, use_alternate = 0Not able to establish initial position for sequence 17, rba 565905936.
    2014-09-02 12:04:38 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, XXXX.prm: PROCESS ABENDING.


    Do supplement logging needs to be disabled during upgrade activity?
    Archive logs are existing but why still GG is asking for specific archive logs?
    Will any delta records missing between these 2 days( btwn db upgrade and starting GG services on extract side)?


    Can you please let me know how can we fix this error. What is the reason extract is getting abended on source side.