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.