1 Reply Latest reply on Jul 29, 2019 6:07 AM by ORASCN

    Extract goldengate abend

    dlenhardt

      Oracle GoldenGate 12.3 Micro Services Architeture

       

      2019-07-26T16:50:05.584-0300 INFO | INFO OGG-02248 Oracle GoldenGate Capture for Oracle, EDSV.prm: Logmining server DDL filtering enabled. (main)

      2019-07-26T16:50:06.718-0300 ERROR| ERROR OGG-00868 Oracle GoldenGate Capture for Oracle, EDSV.prm: Error code 1291, error message: ORA-01291: missing logfile

      (Missing Log File WAITING FOR REDO: FILE NA, THREAD 1, SEQUENCE 0, SCN 0x00000000004d8df0. Read Position SCN: Unknown). (main)

      2019-07-26T16:50:06.721-0300 FATAL| ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, EDSV.prm: PROCESS ABENDING. (main)

       

      extract EDSV

      useridalias GGADMIN_DESENV domain OracleGoldenGate

      exttrail ea

      TRANLOGOPTIONS INTEGRATEDPARAMS (_LOGMINER_READ_BUFFERS 256)

      TRANLOGOPTIONS BUFSIZE 4096000

      UPDATERECORDFORMAT COMPACT

      TRANLOGOPTIONS EXCLUDEUSER GGADMIN

      TABLE DEVELOPER_CARUARU.WMS_ATIVIDADES_ATV;

        • 1. Re: Extract goldengate abend
          ORASCN

          Hi ,

           

          Is this a new one you are trying to register and create it in OGG MA? If so, there will be an option for register extract, check if this is SHARED or New. By default it would be in Shared.

           

          If this an existing one and if you are hitting this error, then it is a general archive log missing error. Run the below query or Healthcheck report to check for the missing archive log files,

           

          COLUMN CONSUMER_NAME HEADING 'Capture|Process|Name' FORMAT A15

          COLUMN SOURCE_DATABASE HEADING 'Source|Database' FORMAT A10

          COLUMN SEQUENCE# HEADING 'Sequence|Number' FORMAT 99999

          COLUMN NAME HEADING 'Required|Archived Redo Log|File Name' FORMAT A40

           

          SELECT r.CONSUMER_NAME,

                 r.SOURCE_DATABASE,

                 r.SEQUENCE#,

                 r.NAME

            FROM DBA_REGISTERED_ARCHIVED_LOG r, DBA_CAPTURE c

            WHERE r.CONSUMER_NAME =  c.CAPTURE_NAME AND

                  r.NEXT_SCN      >= c.REQUIRED_CHECKPOINT_SCN; 

           

          Healthcheck Report - GoldenGate Integrated Capture and Integrated Replicat Healthcheck Script (Doc ID 1448324.1)

           

          Regards,

          Veera