Re: Applying logs to standby in 11g
From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Tue, 23 Oct 2012 17:19:58 -0700 (PDT)
Message-ID: <1351037998.61979.YahooMailNeo_at_web161306.mail.bf1.yahoo.com>
Forgot to mention that below query assumes that primary and standby is in the same timezone and time is synchronized across two boxes, otherwise query needs to be modified accordingly. select
abs(nvl(max(ceil(
(extract(day from replication_lag)*24*60*60)+
(extract(hour from replication_lag)*60*60)+
(extract(minute from replication_lag)*60)+
(extract(second from replication_lag))
)),0)) lag_in_seconds from
(select sysdate-scn_to_timestamp(current_scn) replication_lag from v$database);
Date: Tue, 23 Oct 2012 17:19:58 -0700 (PDT)
Message-ID: <1351037998.61979.YahooMailNeo_at_web161306.mail.bf1.yahoo.com>
Forgot to mention that below query assumes that primary and standby is in the same timezone and time is synchronized across two boxes, otherwise query needs to be modified accordingly. select
abs(nvl(max(ceil(
(extract(day from replication_lag)*24*60*60)+
(extract(hour from replication_lag)*60*60)+
(extract(minute from replication_lag)*60)+
(extract(second from replication_lag))
)),0)) lag_in_seconds from
(select sysdate-scn_to_timestamp(current_scn) replication_lag from v$database);
Thanks,
Sai
http://sai-oracle.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 24 2012 - 02:19:58 CEST