How to restart the Goldengate when Database archivelog sequence was reset.
As database archivelog was reset, the extract process was abended. When I start the extract, it was looking for 1480 archive log and it was not available. Please let me know how to restart the extract by resetting the next log sequence no.. i.e 1.
Thank you for your help
ggserror log:
===
2013-05-04 19:40:48 INFO OGG-00948 Oracle GoldenGate Manager for Oracle, mgr.prm: Lag for EXTRACT
PMP_DDRQ is 00:00:00 (checkpoint updated 00:00:06 ago).
2013-05-04 19:40:57 ERROR OGG-00665 Oracle GoldenGate Capture for Oracle, ext_ddrq.prm: OCI Error
executing single row select (status = 3135-ORA-03135: connection lost contact), SQL<SELECT DECODE(archi
ved, 'YES', 1, 0), status FROM v$log WHERE thread# = :ora_thread AND sequence# = :ora_seq_