SQL Script Monitor Data Guard

Updated: 19-Jul-2004
Version: 1.0

Description

This script lists the important tables from which you can tell if Data Guard is working correctly.

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set pages 200

col dest_id form 999 heading "Dest ID"
col error form a10 Heading "Error"
col archived_thread# form 999 heading "Thread"
col applied_thread# form 999 heading "Thread"
col name form a40 heading "Name" wrap

spool dgprocs.lst

show parameter log
show parameter standby

select name,switchover_status, database_role, standby_mode,force_logging
from v$database
/

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

select dest_id,status, archived_thread#, archived_seq#, applied_thread#, applied_seq#, error
from v$archive_dest_status
/ 

select dest_id,status,error
from v$archive_dest

select name,creator, sequence#,applied,completion_time
from v$archived_log
/

select * from v$archive_gap
/

select message from v$dataguard_status
/

select * from v$standby_log
/


spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links