My Datapump was abending after start, because It was looking for MISSING remote trailfile at perticular RBA , that trailfile was deleted.
If you want to reposition extract please visit. Re-position Extract at particular RBA
here is from source side.
GGSCI (RACD1.localdomain.com) 6> INFO RMTTRAIL *
Extract Trail: ./dirdat/DE
Extract: RACDE
Seqno: 1
RBA: 1049
File Size: 10M
Extract Trail: ./dirdat/DP
Extract: RACDP
Seqno: 0
RBA: 4499
File Size: 10M
some output from ggserr.log
2012-10-17 19:47:58 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT RACDP starting. 2012-10-17 19:47:58 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, racdp.prm: EXTRACT RACDP starting. 2012-10-17 19:47:59 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, racdp.prm: EXTRACT RACDP started. 2012-10-17 19:48:04 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, racdp.prm: Socket buffer size set to 27985 (flush size 27985). --This is the error.... 2012-10-17 19:48:04 ERROR OGG-01496 Oracle GoldenGate Capture for Oracle, racdp.prm: Failed to open target trail file ./dirdat/DP000000, at RBA 4499. 2012-10-17 19:48:04 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, racdp.prm: PROCESS ABENDING.
I had trailfile missing on Target side, which DATAPUMP was looking for.
TEST:/u00/app/gghome/dirdat :TEST$ll total 12 -rw-rw-rw- 1 oracle oinstall 1167 Aug 2 09:49 XP000000 drwxr-xr-x 14 oracle oinstall 4096 Oct 17 16:10 .. drwxrwxr-x 2 oracle oinstall 4096 Oct 17 16:52 .
So i did this below on Source side and start datapump successfully.
GGSCI (RACD1.localdomain.com) 11> ALTER EXTRACT RACDP ETROLLOVER
2012-10-17 19:54:30 INFO OGG-01520 Rollover performed. For each affected output trail of Version 10 or higher format, after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file; it will not happen automatically.
EXTRACT altered.
GGSCI (RACD1.localdomain.com) 12> INFO RMTTRAIL *
Extract Trail: ./dirdat/DE
Extract: RACDE
Seqno: 1
RBA: 1049
File Size: 10M
Extract Trail: ./dirdat/DP
Extract: RACDP
Seqno: 1
RBA: 0
File Size: 10M
GGSCI (RACD1.localdomain.com) 13> START RACDP
Sending START request to MANAGER ...
EXTRACT RACDP starting
GGSCI (RACD1.localdomain.com) 14> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING RACDE 00:00:00 00:00:01
EXTRACT RUNNING RACDP 00:00:00 00:00:02
2012-10-17 19:55:20 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT RACDP starting.
2012-10-17 19:55:20 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, racdp.prm: EXTRACT RACDP starting.
2012-10-17 19:55:31 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, racdp.prm: EXTRACT RACDP started.
2012-10-17 19:55:39 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, racdp.prm: Socket buffer size set to 27985 (flush size 27985).
2012-10-17 19:55:40 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, racdp.prm: No recovery is required for target file ./dirdat/DP000001, at RBA 0 (file not opened).
2012-10-17 19:55:40 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, racdp.prm: Output file ./dirdat/DP is using format RELEASE 10.4/11.1.
