GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How to restart the Goldengate when Database archivelog sequence was reset.

edited May 7, 2013 6:28AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered ✓
Hi,

 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_

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center