General
=========================
Oracle Golden Gate Replicat Process abends with following error:
ERROR OGG-01091 Unable to open file "/software/ogg/191/dirdat/01/in/es000004665" (error 2, No such file or directory).
Checking the file system, indeed there is no such file:
There is indeed no such file.
First file being es000000000
ls -ltr /software/ogg/191/dirdat/01/in/es*/
-rw-r----- 1 oracle dba 499997096 Feb 13 08:26 es000000000
-rw-r----- 1 oracle dba 499996646 Feb 13 08:26 es000000001
-rw-r----- 1 oracle dba 499999334 Feb 13 08:27 es000000002
-rw-r----- 1 oracle dba 499998299 Feb 13 08:27 es000000003
-rw-r----- 1 oracle dba 499998846 Feb 13 08:27 es000000004
=========================
Solution
=========================
Solution
=========================
Reset Replicat to start at first available file:
EXTSEQNO 0 - point to file es000000000
EXTRBA 0 - point to start position of the file
GGSCI> DBLOGIN USERID USER PASSWORD PASS
GSCI (qanfv-1-dbs-1b) 17> INFO ALL
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPM_I_01 00:00:00 00:00:09
EXTRACT RUNNING DPM_P_01 00:00:00 00:00:05
EXTRACT RUNNING DPM_S_01 00:00:03 00:00:04
EXTRACT RUNNING EXT_I_01 00:00:03 00:00:02
EXTRACT RUNNING EXT_P_01 00:00:02 00:00:09
EXTRACT RUNNING EXT_S_01 00:00:02 00:00:05
REPLICAT RUNNING REP_I_01 00:00:00 00:00:04
REPLICAT RUNNING REP_P_01 00:00:00 00:00:04
REPLICAT ABENDED REP_S_01 00:00:00 07:10:31
GGSCI> ALTER REPLICAT REP_S_01, EXTSEQNO 0 EXTRBA 0
REPLICAT altered.
GGSCI> START REPLICAT REP_S_01
REPLICAT REP_P_01 starting
GGSCI> INFO ALL
MANAGER RUNNING
EXTRACT RUNNING DPM_I_01 00:00:00 00:00:02
EXTRACT RUNNING DPM_P_01 00:00:00 00:00:01
EXTRACT RUNNING DPM_S_01 00:00:00 00:00:04
EXTRACT RUNNING EXT_I_01 00:00:03 00:00:04
EXTRACT RUNNING EXT_P_01 00:00:00 00:00:03
EXTRACT RUNNING EXT_S_01 00:00:02 00:00:04
REPLICAT RUNNING REP_I_01 00:00:00 00:00:01
REPLICAT RUNNING REP_P_01 00:00:00 00:00:00
REPLICAT RUNNING REP_S_01 43:50:16 00:00:00
Since many files were pending replication, there is a backlog, which should be cleared alter some time
REPLICAT RUNNING REP_S_01 43:49:57 00:00:00
REPLICAT RUNNING REP_S_01 42:12:40 00:00:00
Because when starting without specific RBA, it will default to RBA from the old file, instead of starting with RBA=0. For example, it will try to start with EXTSEQNO 0 EXTRBA 8132, instead of EXTSEQNO 0 EXTRBA 0
GGSCI> ALTER REPLICAT REP_S_01 EXTSEQNO 0
REPLICAT altered.
GGSCI> INFO ALL
GGSCI> INFO ALL
GGSCI> REPLICAT ABENDED REP_S_01 00:00:00 07:10:31
=========================
Additional info
=========================
Additional info
=========================
Over weekend GG Replication was broken, and files filled up 100% of /software/ogg/191/dirdat/01/
Since this was a test environment, as a quick solution, existing files were deleted and GG started from scratch.
No comments:
Post a Comment