We can check primary and standby database data synchronization just by running the following scripts on both database environments and the SEQUENCE# should be the same on both databases.
Example:
On primary database:
1 2 3 4 5 6 7 8 9 | SQL> select thread#,sequence#, applied from v$archived_logwhere thread#=1 and applied='YES' and sequence#<21144order by sequence# descFETCH FIRST 2 ROWS ONLY; 2 3 4 THREAD# SEQUENCE# APPLIED---------- ---------- --------- 1 2804 YES 1 2804 YES SQL> |
And on standby database:
1 2 3 4 5 6 7 8 9 | SQL> select thread#,sequence#, applied from v$archived_logwhere thread#=1 and applied='YES' and sequence#<21144order by sequence# descFETCH FIRST 2 ROWS ONLY; 2 3 4 THREAD# SEQUENCE# APPLIED---------- ---------- --------- 1 2804 YES 1 2803 YES SQL> |
Ezana Answered question 03/10/2022