Re: Moving Start SCN for Streams Capture process

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.

Regards,
On Apr 12, 2014 3:19 AM, "Prabhu Krishnaswamy" <prabhu_adam_at_hotmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l