Saber el lag de una standby

[oracle@ORA-sb-0320 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 16 11:43:32 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> 

with lag as (select cast (value as interval day(2) to second(0)) l from v$dataguard_stats where name='apply lag') select extract(second from l)+extract(minute from l)*60+extract(hour from l)*3600+extract(day from l)*86400 segundos from lag;

  SEGUNDOS
----------
         0

SQL>

select db_unique_name,dest_name,status,gap_status from v$archive_dest_status where status!='INACTIVE';

SQL> /

DB_UNIQUE_NAME                 DEST_NAME                                STATUS    GAP_STATUS

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

NONE                           LOG_ARCHIVE_DEST_1                       VALID

NONE                           STANDBY_ARCHIVE_DEST                     VALID

SQL>