DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007

    Checking Whether Physical Standby is in Sync with the Primary

    I writing script to alert dba if primary and standby database are not in sync. I use article - How To Check Whether Physical Standby is in Sync with the Primary? ID 861595.1 - from My Oracle Support

    It suggests comparing Last Sequence Generated on primary and Last Sequence Received on standby for each thread. And if they are not equal - NOT in sync.

    My assumption is that if there are multiple threads we running RAC. Is it correct ?
    And if we running RAC as far as I am aware it's sufficient to have one thread in sync.

    Please comment on this

    Thanks in advance

  2. #2
    Join Date
    Sep 2002
    no, all threads need to be in sync

  3. #3
    Join Date
    Jun 2007
    Thanks davey23uk!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.