03.01. System status monitoring

                     <<< Back   Next >>>

-- Check REDO shipping status

select  FS_FAILOVER_STATUS,FS_FAILOVER_OBSERVER_PRESENT   from v$database;

-- Check destination status

select dest_id,status,protection_mode,destination,synchronization_status,synchronized,gap_status from V$ARCHIVE_DEST_STATUS;

select status,protection_mode,destination,synchronization_status,synchronized,gap_status from V$ARCHIVE_DEST_STATUS where dest_id=2;

-- Log with errors

alter session set nls_date_format='dd.mm.yyyy hh24:mi:ss';

SELECT 

INST_ID, FACILITY, SEVERITY, 

   DEST_ID, MESSAGE_NUM, ERROR_CODE, 

   CALLOUT, TIMESTAMP, MESSAGE, 

   CON_ID

FROM SYS.GV_$DATAGUARD_STATUS where error_code is not null 

and 

TIMESTAMP>=sysdate-30/60/24

order by TIMESTAMP desc;

                     <<< Back   Next >>>