-
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
-
no, all threads need to be in sync
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|