Re: Moving Start SCN for Streams Capture process

From: Stojan Veselinovski <>
Date: Sat, 12 Apr 2014 08:32:52 +1000
Message-ID: <>

Hi Prabhu,

You can use dbms_capture_adm.alter_capture to move the start scn. I've used this a few times but there are a few quirks to it.

Sounds to me like there may be long running transactions.

You can possibly also use dbms_capture_adm.set_parameter with '_ignore_transaction' to try and skip the problematic one.

Beware you may lose data.

On Apr 12, 2014 3:19 AM, "Prabhu Krishnaswamy" <> wrote:

> Lists,
> We have facing an issue with one of our production Streams setup. The
> streams processes got broke after a network issue and once after the
> network is back alive, the capture process start reading the logs way back
> old logs. Its been 3 days still the capture process is reading old logs and
> hence the propagation is not sending any data to the target. Is there any
> way to set or moving of the start scn forward ?
> Any suggestions are highly appreciable.
> Thank you
> Prabhu

Received on Sat Apr 12 2014 - 00:32:52 CEST

Original text of this message