Query for sanity check in Primary and Standby Oracle database

Primary

SQL> select   thread#, max(sequence#) "Last Primary Seq Generated" from gv$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                         41

Standby

SQL> select thread#, max(sequence#) "Last Standby Seq Received" from  v$archived_log val, v$database vdb where  val.resetlogs_change# = vdb.resetlogs_change# group by thread# order by 1;

   THREAD# Last Standby Seq Received

---------- -------------------------

         1                        41