1 Reply Latest reply: Jul 1, 2014 2:52 AM by User13260331-Oracle RSS

    Ensuring Pending Transactions Are Propagated to all sites after failure due to network/DB

    c022ed2b-ecdf-47ed-8a27-88d7f170ef50

      Hi

       

      I am new to Oracle Streams and want to clear some doubts.

      DB Version 11.2.0

      Streams Env: Oracle Streams Synchronous Capture (4 sites multi master)

      1)  If there is a network failure in multi master environment, does the streams processes automatically resume the operations after network is restored?

      2) If there is a database shutdown on one or more site, does the streams processes automatically resume the operations when DB are brought back online?

      3) If answer to any of the above question is NO then what steps must be taken to ensure that the pending transactions are propagated to all sites in a streams environment after network or DB is restored?

       

      Your comments on the above posted questions will help me a lot.

       

      Thank you