1 Reply Latest reply: Feb 12, 2012 8:41 AM by 864403 RSS

    ERROR   OGG-01496  restarting extract

    317197
      Each time i restart the extract process after a normal stop i got this type of error:
      ERROR OGG-01496 Oracle GoldenGate Capture for Oracle, EXT1.prm: Failed to open target trail file P:\OracleGoldenGate\dirdat\lt000661, at RBA 5466894.
      Why and what can i do? No i delete the ext1 group and then i create the same group again...

      The extract group parameter file named ext1 is:

      extract ext1
      userid ggschema, password ggschema
      rmthost 192.168.2.225, mgrport 7809
      exttrail P:\OracleGoldenGate\dirdat\lt
      rmttrail P:\OracleGoldenGate\dirdat\lt

      ddl include mapped objname TESEO2.* ;
      TABLEEXCLUDE TESEO2.AGGANCI_ALL_MV ;
      TABLEEXCLUDE TESEO2.ESTREMI_RN_RISOLTI_MV ;
      TABLEEXCLUDE TESEO2.ESTREMI_UDOC_MV ;
      TABLEEXCLUDE TESEO2.MASS_CLASS_MV ;
      TABLEEXCLUDE TESEO2.NOTEDOTT_CLASS_MV ;
      TABLEEXCLUDE TESEO2.NOTE_MV ;
      TABLEEXCLUDE TESEO2.CORRELAZIONI ;
           
           
      TABLE TESEO2.* ;


      The manager param is:
      GGSCI (dbgen) 43> show param mgr

      Parameter settings:

      SET SUBDIRS ON
      SET DEBUG OFF

      Current directory: P:\OracleGoldenGate

      Using subdirectories for all process files

      Editor: notepad

      Reports (.rpt) P:\OracleGoldenGate\dirrpt
      Parameters (.prm) P:\OracleGoldenGate\dirprm
      Replicat Checkpoints (.cpr) P:\OracleGoldenGate\dirchk
      Extract Checkpoints (.cpe) P:\OracleGoldenGate\dirchk
      Process Status (.pcs) P:\OracleGoldenGate\dirpcs
      SQL Scripts (.sql) P:\OracleGoldenGate\dirsql
      Database Definitions (.def) P:\OracleGoldenGate\dirdef