13 Replies Latest reply: Apr 15, 2014 2:04 AM by 1384666 RSS

    Dataguard Stalling. Need help kickstarting.

    1384666

      Hi all,

          I have set up Dataguard between 2 servers (primary A and DR A1)

       

      A   ----- Dataguard ----- A1

       

       

      The situation is like this :

       

      When dataguard is working, When I do a "SQL> Select current_scn from v$database;" on both databases... the scn numbers on A1 will be about 20000 less than A.

       

      Recently when there was a problem with the network, I noticed that the dataguard has stalled. (A1 is more than 30000 from A).

       

      * This is how I kickstart the dataguard and update the SCN for A1 so that it is within 20000 of A.

      I transfer the rman backup and controlfile from A to A1 and then restore the backup.

       

      ** Sometimes the dataguard doesn't start.

       

      Now my question is, Is there anyway for me to kickstart the dataguard without going through *?

      and what kind of commands can I actually use to reload the archivelog transfer from A to A1?

       

      Thank you.