Pump process is not moving to the next trail file.
857233Apr 22 2011 — edited Apr 22 2011Hi,
I started the extract and pump processes 2 days back and stop them after checking that they are running fine. Today when I wanted to start them again, Extract process abended because archivelogs were also deleted in between. Since it is a test server, I reset the checkpoint by using command "alter extract extract_name start now". Extract is working fine now, but my pump process is still stuck on the previous trail file. And I am getting warning
"2011-04-22 13:15:24 WARNING OGG-01519 Oracle GoldenGate Capture for Oracle, pmpchats.prm: Waiting at EOF on input trail file /u01/ogg/ggchats/trail/CA000000, which is not marked as complete; but succeeding trail file /u01/ogg/ggchats/trail/CA000001 exists. If ALTER ETROLLOVER has been performed on source extract, ALTER EXTSEQNO must be performed on each corresponding downstream reader."
Can anyone please help me in finding command to move the pump process to the next trail file. BTW, both EXTRACT and PUMP processes are running.
Thanks