Monitorar Oracle standby manual archivelog aplicação.

set colsep   " | "
SET LINESIZE  145
SET PAGESIZE  9999
alter session set nls_date_format = 'DD/MM/YYYY HH24:MI:SS';
SELECT HOST_NAME,INSTANCE_NAME,STATUS,VERSION,(SELECT LOG_MODE FROM V$DATABASE WHERE ROWNUM =1) LOG_MODE FROM GV$INSTANCE;
SELECT FIRST_TIME APPLIED_DATE,SEQUENCE# SEQUENCE_MAX FROM V$LOG_HISTORY WHERE SEQUENCE#= (SELECT MAX(SEQUENCE#)FROM V$LOG_HISTORY);
 
SQL>
HOST_NAME                                                        | INSTANCE_NAME    | STATUS       | VERSION           | LOG_MODE
---------------------------------------------------------------- | ---------------- | ------------ | ----------------- | ------------
srv01                                    | LGX              | MOUNTED      | 11.2.0.3.0        | ARCHIVELOG
 
SQL>
 
APPLIED_DATE        | SEQUENCE_MAX
------------------- | ------------
20/10/2021 20:00:01 |       123594