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