Usefull Scripts

*******************Dataguard Monitoring Scripts******************************
SELECT name,
               open_mode,
               database_role,
               protection_mode
FROM v$database;
--------------------------------------------------------------------------------------------------
On Primary
select to_char(Current_SCN) from v$database;


On Standby
select to_char(Current_SCN) from v$database;


Difference of both output should not big, if big check


SELECT * from v$ARCHIVE_GAP;




SELECT MESSAGE
FROM V$DATAGUARD_STATUS;
-------------------------------------------------------------------------
SELECT PROCESS,
                STATUS,
                THREAD#,
                SEQUENCE#,
                BLOCK#,
                BLOCKS
FROM V$MANAGED_STANDBY ;




------------------------------------------------------------------------
select registrar,
          creator,
          thread#,
          sequence#,
          first_change#,
          next_change#
from v$archived_log;
------------------------------------------------------------------------




select 'Last Log applied : ' Logs, to_char(next_time,'DD-MON-YY:HH24:MI:SS') "Applied_Time"
from v$archived_log
where sequence# = (select max(sequence#) from v$archived_log where applied='YES')
union
select 'Last Log received : ' Logs, to_char(next_time,'DD-MON-YY:HH24:MI:SS') "Received_Time"
from v$archived_log
where sequence# = (select max(sequence#) from v$archived_log);






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


SELECT to_char(max(FIRST_TIME),'hh24:mi:ss dd-mm-yyyy')
FROM v$archived_log
WHERE applied='YES';




------------------------------------------------------------------------------------------------------------
SELECT thread#,
                group#,
                sequence#,
                bytes,
                archived,
               status
FROM v$standby_log
ORDER BY thread#, group#;
-----------------------------------------------------------------------------------------------------------