log_archive_format & Goldengate
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: log_archive_format & Goldengate

Hybrid View

  1. #1
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865

    log_archive_format & Goldengate

    Hi all,

    Oracle 11g R2, Goldengate 11.1, Windowz

    I need some help to clarify two things.

    1. DB is in flash recovery mode. log_archive_format = ARC%S_%R.%T. Where as archive logs are saving like O1_MF_1_30_74VZY20Z_.ARC. Any clue why parameter value and actual file name is different? Please note, I am not using OMF.

    2. As I am using flash recovery, archive logs are saving in DB_RECOVERY_FILE_DEST\ORACLE_SID\ARCHIVELOG\DATE_FOLDER. Please have a look into my GG extract parameter file.

    EXTRACT extsrc
    --CHECKPARAMS
    SETENV (ORACLE_HOME = "F:\app\VT0046014\product\11.2.0\dbhome_1")
    SETENV (ORACLE_SID = "ora11g")
    USERID gguser@ora11g, PASSWORD gguser
    EXTTRAIL F:\GoldenGate\GGS11\dirdat\lt
    TRANLOGOPTIONS ALTARCHIVELOGDEST PRIMARY F:\app\VT0046014\flash_recovery_area\ora11g\ARCHIVELOG
    TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT ARC%S_%R.%T
    TABLE scott.allobjects;
    TABLE Scott.allobjects1;
    and the excerpt from extract error report ...

    2011-08-19 12:26:40 ERROR OGG-00446 Could not find archived log for sequence 28 thread 1 under alternative destinations. SQL SELECT MAX(sequence#) FROM v$log WHERE thread# = ra_thread AND status in ('INVALIDATED', 'CURRENT', 'ACTIVE'). Last alternative log tried F:\app\VT0046014\flash_recovery_area\ora11g\ARCHIVELOG\ARC00028_0755020128.001, error retrieving redo file name for sequence 28, archived = 1, use_alternate = 0Not able to establish initial position for sequence 28, rba 11790864.
    Can some one shed some light to understand why actual archive log is storing in a different format than given in the parameter? and how to overcome this in GG extract configuration?

    Thanks in advance.

    Regards,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865

    Unhappy more troubles ...

    I have just tested changing log_archive_format to log_%t_%s_%r.arc but still archive logs are storing like O1_MF_1_31_74W801CQ_.ARC. That means, oracle is not considering log_archive_format parameter value...

    any clue(s) will be appreciated.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    I understand that if FRA is using then Oracle is creating archive log files in OMF format. If FRA is not using then it is considering the format specified in log_archive_format parameter.

    If any one contradict with my conclusion, please post.

    Regarding OGG issue, I am running post in exclusive GG forum. Any one interested to follow please see here.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

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



Click Here to Expand Forum to Full Width