Hello Tom,

Required your help in below scenario:

Requirement : we have primary and DR server where we need to monitor synchronization between this two server.

Method used:
I have planned to use SPOOL command which connect to primary server first and then secondary server and get max(sequence#) with append command, but still i feel for improvement i.e. what i want if this sequence number matches then i want dummy column or file name should be changed to "InSync" or "matched" and if not matched then "outofSync" or "not match" but not able to get any post in this regards.

Please help me if we can do this then it would be really helpful for me.

Also any suggestion for monitoring sync process also be welcome.

Scripts:
set linesize 250
set pagesize 500
column sequence# format a12
set heading off
set markup html on
spool CheckDatabaseSyncStatus.html
set heading on
select max(sequence#) as "LAST LOG GENERATED AT PR" from V$log_history;
spool off
conn sys/ecpix@ecpixdr as sysdba
spool CheckDatabaseSyncStatus.html append;
select max(sequence#) "LAST LOG APPLIED AT DR" from V$log_history;
spool off
disconn
exit


Hoping for some valuable input as always all gets.

Thanks..

SQL> spool c:\temp\output.txt
SQL> select 'S='||max(sequence#) sby from v$log_history;

SBY
------------------------------------------
S=1697

SQL> conn / as sysdba
Connected.

SQL> select 'P='||max(sequence#) sby from v$log_history;

SBY
------------------------------------------
P=1697

SQL> spool off

$ egrep '(^S=|^P=)' output.txt | gawk -F= '{if ( NR == 1 ) {s=$2}}{if ( NR == 2 ){p=$2}}END{if ( s == p ) {print "OK"} else {print "FAIL"}}'
OK