Re: standby rfs check script

Posted by rafiki on Feb 28, 2018; 7:33am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/standby-rfs-check-script-tp5262p5269.html

i guess it does not work by the way;

select (CASE WHEN to_char(count(sequence#)) = '0'
THEN 'no problems/no gap in transfer' ELSE 'There are '||to_char(count(sequence#))|| ' archives, still not transffered to standby' END ) as "TRANSFER GAP CONTROL"
from
(select sequence#
from v$archived_log
where standby_dest='NO' --and sequence# > 81302
minus
select sequence#
from v$archived_log
where standby_dest='YES'
minus
select min(sequence#) from v$archived_log);