Skip to content
Home » Oracle » How to Resolve OGG-01091 Error Message

How to Resolve OGG-01091 Error Message

OGG-01091 Unable to open file on Target Server

Saw an error OGG-01091 in REPLICAT report

2017-03-23 10:12:53  ERROR   OGG-01091  Unable to open file "./dirdat/PT0000364" (error 2, No such file or directory)

Really? There's no such file? Let's check the pump files.

[oracle@chicago ~]$ cd $OGG_HOME/dirdat
[oracle@chicago dirdat]$ ll
total 0
-rw-r-----. 1 oracle oinstall 0 Mar 23 10:04 PT0000384

Oh, it's 384, not 364. We should notify the replicat.

GGSCI (chicago) 10> ALTER REPLICAT ERPAPP_R, EXTSEQNO 384, EXTRBA 0
REPLICAT altered.

GGSCI (chicago) 11> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
REPLICAT    STOPPED     ERPAPP_R    00:00:00      00:00:42

Let's start REPLICAT.

GGSCI (chicago) 12> start ERPAPP_R

Sending START request to MANAGER ...
REPLICAT ERPAPP_R starting


GGSCI (chicago) 13> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
REPLICAT    RUNNING     ERPAPP_R    00:00:00      00:00:02

We're back. No more OGG-01091.

In this case, we have learned that the sequence numbers of EXTRACT and REPLICAT have not to be identical.

Leave a Reply

Your email address will not be published. Required fields are marked *