Re: REAL TIME APPLY doesn't seem to be working correctly

Hi Sandra,
 Your alert log confirms that RTA is on:

Mon Apr 29 19:33:50 2019
Managed Standby Recovery starting Real Time Apply

Check out this note - 1481927.1

Because RTA is on, the standby is always up to date. It does not rely on archives to arrive before being applied.

So to compare the lag between primary and standby you actually need to look at the checkpoint_time in v$datafile. The values for each datafile should closely match on the primary and standby.

Cheers,
Leng

> On 30 Apr 2019, at 10:19 am, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
>
> Hi Sandra,
>
> Did you check drc*.log on the standby database? That file is sort of trace file for Data Guard.
>
> Regards
>

>> On 4/29/19 5:43 PM, Sandra Becker wrote:
>> We have created a standby database with REAL TIME APPLY, or so we thought.  Everything says it's REAL TIME APPLY, but the logs are not being applied right away.  We have to do a log switch before the log gets applied.  I've recreated the standby redo logs as described in DocID 1956103.1, but it didn't make any difference.   I cannot shutdown the primary for another two weeks if some change is needed there.  The standby I can bounce as needed.  I have 3 online redo groups in both the primary and standby.  Due to company policy, I have had to obfuscate some of the values.  Hopefully, they still match where they should. I'm open to suggestions/recommendations.  We would like to understand what's going on and get the REAL TIME APPLY working as it is in the other database on this node.
>> 
>> Thanks in advance.
>> 

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