ORACLE DATA GUARD MONITORING SCRIPT

ON STANDBY:
---------------------------------------------------------------------------------
mrp.sql
select sequence#,process,status from v$managed_standby;
---------------------------------------------------------------------------------

odg_enable_rec.sql

recover managed standby database disconnect from session;

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

odg_disable_rec.sql

recover managed standby database cancel;

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

applied.sql

column Time format a20

set pages 1000

set lines 1000

column name format a50

Select sequence#,

    to_char(COMPLETION_TIME,'DD-MM-YYYY HH24:MI:SS') "Time",

    name,STATUS,Archived,Applied

from v$Archived_log

where to_char(completion_time,'DD-MM-YYYY')=to_char(sysdate,'DD-MM-YYYY')

order by sequence#;

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

Primary

odg_mon.sql

set lines 1000

column DEST_NAME format a20

select DEST_ID,

DEST_NAME,

STATUS,

TRANSMIT_MODE,

ARCHIVER,

REOPEN_SECS,

ERROR from v$archive_dest 

where DEST_ID='&x';

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

odg_enable.sql

alter system set log_archive_dest_State_x=ENABLE scope=both;

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

odg_disable.sql

alter system set log_archive_dest_State_x=DEFER scope=both;

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

Few More Scripts:

STANDBY:

arch_gap.sql

select * from v$archive_gap;

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

odg_status.sql

select process,sequence#,status from v$managed_standby where process <> 'ARCH';

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

select process, client_process, sequence#, status from v$managed_standby;

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

PRIMARY/ STANDBY:

max_arch.sql

select max(sequence#),applied from v$archived_log group by applied;

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

last_app.sql

select thread#, max(sequence#) as "last_applied_log" from v$log_history group by thread#;

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