SQL Script Standby Database Gap Detection

Updated: 24-Nov-2004
Version: 1.0

Description

This script lists a simple method in which to detect archive gaps. IT does need to be run in seperate parts on both the primary and standby databases.

Parameters

SQL Source

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

rem on primary, find out the lastest archived log sequence number

select sequence#, next_change# from v$archived_log
where sequence# = (select max(sequence#) from v$archived_log)
/

rem on standby see if we have received all the archive logs

select sequence#, next_change# from v$archived_log
where sequence# = (select max(sequence#) from v$archived_log)
/

rem on standby see if we have applied all the standby logs

select sequence#, next_change# from v$log_history
where sequence# = (select max(sequence#) from v$log_history)
/

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