GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

ogg capture scn not getting updated

edited May 3, 2014 1:06AM in GoldenGate, Streams and Distributed Database (MOSC) 8 commentsAnswered

Hello Experts,

In one of gg env , we are seeing that ogg capture processes created is not updating the scn no  from long time . which is holding the RMAN from deleting the achivelog.

We are using classic extract process with logretrention(gg version 11.2) . There are 3 capture process but only one od the capture process scn is current , the other 2 are behind.

Is there a way we can check if my extract is register properly for logretention like 'info' and also know the reason for this issue.

CAPTURE_NAME               TO_CHAR(START_SCN)                   START_TIME                                       TO_CHAR(FIRST_SCN)                   CHECKPOINT_RETENTION_TIME

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