Re: Moving Start SCN for Streams Capture process
Date: Sat, 12 Apr 2014 08:32:52 +1000
Message-ID: <CALn1tDumHpBC2zgnVC-q+XOKAF9H05KpbK-tDbF+YEjbbgwx4A_at_mail.gmail.com>
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.
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-lReceived on Sat Apr 12 2014 - 00:32:52 CEST