DATAGUARD REPLICATION STATUS or Data guard synchronization status

How to confirm replication between primary and DR server

CHECK ARCHIVE LOGS SEQUENCE ON PRIMARY RAC SERVER

Run this query on PRIMARY-SERVER either of nodes

 SQL> select thread#, max(sequence#) “Last Primary Seq Generated” from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# group by thread#
order by 1;
THREAD# Last Primary Seq Generated
———- ————————–
1 20076
2 11251
4 10119

 

DR-SERVER OUTPUT

Run this query on DR-SERVER
SQL> select THREAD#,SEQUENCE#,status,ARCHIVED,APPLIED from v$archived_log where (THREAD#=1 and SEQUENCE# > &Node1_archive_10 )or (THREAD#=2 and SEQUENCE# > &Node2_archive_10)
or (THREAD#=4 and SEQUENCE# > &Node3_archive_10 ) order by THREAD#,SEQUENCE#;

Enter value for node1_archive_10: 20066

Enter value for node2_archive_10: 11245

Enter value for node3_archive_10: 10112

 

THREAD# SEQUENCE# S ARC APP
———- ———- – — —
1 20067 A YES YES
1 20068 A YES YES
1 20069 A YES YES
1 20070 A YES YES
1 20071 A YES YES
1 20072 A YES YES
1 20073 A YES YES
1 20074 A YES YES
1 20075 A YES YES
1 20076 A YES YES  è last max sequence for node1
2 11246 A YES YES

THREAD# SEQUENCE# S ARC APP
———- ———- – — —
2 11247 A YES YES
2 11248 A YES YES
2 11249 A YES YES
2 11250 A YES YES
2 11251 A YES NO è last max sequence for node2
4 10113 A YES YES
4 10114 A YES YES
4 10115 A YES YES
4 10116 A YES YES
4 10117 A YES YES
4 10118 A YES YES

THREAD# SEQUENCE# S ARC APP
———- ———- – — —
4 10119 A YES NO è last max sequence for node3
23 rows selected.
SQL>

 

From the above result needs to check thread#, max(sequence#) and applied columns.

From the above output we can see there are thread 1 2 and 4(for instance1,2 and 3), and all archive logs are applied on DR-SERVER, so it is confirmed that DR-SERVER is fully synchronized with primary.

 

 

 

 

 

Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Oracle DataGaurd. Bookmark the permalink.

One Response to DATAGUARD REPLICATION STATUS or Data guard synchronization status

  1. Pingback: Stop and Start Recover managed Standby Database | ORACLE RAC DBA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s