RE: Applying logs to standby in 11g

From: Bancea, Danut <Danut.Bancea_at_bmo.com>
Date: Wed, 24 Oct 2012 14:36:37 -0400
Message-ID: <475356FF5907144FA3D319BAEA39105CAAA4AE92_at_BMFGEXCMBX05.adroot.bmogc.net>

I used also the next statement:
select round(24*60*(sysdate - last_time)) from V$STANDBY_LOG where sequence# <> 0;

the result it is in minutes.

Danut Bancea
Tel: 416 643 1631

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Saibabu Devabhaktuni Sent: October 24, 2012 2:22 PM
To: free
Subject: Re: Applying logs to standby in 11g

Yong Huang just sent me a note that the below query doesn't work on the dataguard when it is in the mount mode, he is right below query works only on Active dataguard and when the standby is in read only mode. 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);

You can use below query to get the lag when standby is in mount mode in addition to relying on v$dataguard_stats:

select max(lag_time) lag_time from
(select max(timestamp) lag_time from v$recovery_progress where type='Media Recovery' and item='Last Applied Redo'
union all
select max(checkpoint_time) lag_time from v$datafile where file#=1);

Parameter standby_max_data_delay and current_scn in v$database rely on the recovery progress maintained in v$recovery_progress.

Thanks,
Sai
http://sai-oracle.blogspot.com

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 24 2012 - 20:36:37 CEST