DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, September 19, 2017

OGG-01091 Unable to open file "/u01/ggh/dirdat/ab000000006" (error 2, No such file or directory).

Replicat process abends with OGG-01091 Unable to open file... (Error 2, no such file or directory)

After abnormal crash of server , all databases has been restarted and existing goldengate replicat processes abended with below error,

GGSCI (ggsource.doyensys.com) 14> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    ABENDED     REP1        00:00:00      11:56:05    


 ERROR   OGG-01091  Oracle GoldenGate Delivery for Oracle, REP1.prm:  Unable to open file <trail_file> (error 2, No such file or directory)

Whenever start of replicat process everytime same error occured. Although trail file exists in related directory, process could not start. To fix this error , related replicat process has been altered to begin with specific trail file which seems absent.

GGSCI (ggsource.doyensys.com) 15> alter REPLICAT REP1,extseqno 7 extrba 0

2017-09-19 22:29:41  INFO    OGG-06594  Replicat REP1 has been altered through GGSCI. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start REP1 with NOFILTERDUPTRANSACTIONS option.

REPLICAT altered.


GGSCI (ggsource.doyensys.com) 17> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     REP1        00:00:00      00:00:01    

trail file seq no is absent file no