alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
set lines 200

-- on PRIMARY database
----------------------
select THREAD#, max(SEQUENCE#), max(FIRST_TIME),max(NEXT_TIME),max(COMPLETION_TIME) from gv$archived_log group by THREAD#;

-- on STANDBY database
----------------------
select THREAD#, max(SEQUENCE#), max(FIRST_TIME),max(NEXT_TIME),max(COMPLETION_TIME) from gv$archived_log
  where APPLIED='YES' group by THREAD#;