QUERY DATAGUARD AND STANDBY STATUS
-- Find which logs were applied in the last day SELECT SEQUENCE#, to_char(FIRST_TIME,'hh24:mi:ss dd/mm/yyyy'), to_char(NEXT_TIME,'hh24:mi:ss dd/mm/yyyy'),APPLIED FROM V$ARCHIVED_LOG where next_time>sysdate-1 ORDER BY SEQUENCE# ; -- Find last applied log select to_char(max(FIRST_TIME),'hh24:mi:ss dd/mm/yyyy') FROM V$ARCHIVED_LOG where applied='YES'; -- What are the managed standby processes doing? SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY; -- Are we on production or standby? SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; -- Check for errors SELECT MESSAGE FROM V$DATAGUARD_STATUS; -- Check that the DB was openned correctly SELECT RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS; -- important lag statistics select * from v$dataguard_stats; -- co...